mysql使用经验

命令行登录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列为%