命令行登录mysql
mysql -u用户名 -p用户密码
创建用户
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
授权用户
GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;
GRANT select ON mydb.mytable TO username@localhost ;
创建并授权用户
grant all privileges on *.* to userAAA@'localhost' identified by 'pwpwpwpw';
eg:GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
允许远程连接:
更新host列为%