utf8mb4 #
XShelll 数据库查询，中文变成问号
SET NAMES utf8mb4 COLLATE utf8mb4_general_ci;
grants #
search grants status
SHOW GRANTS FOR 'root'@'localhost';
set password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxx';
grant the necessary permissions:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;
FLUSH PRIVILEGES;