MySQL 用户和权限-向日葵屋

MySQL 用户和权限

悠悠 2022-08-19 05:50 288阅读 0赞

一。登录MySQL
shell> mysql -h host -u user -p
Enter password: ********
注：host: 主机名，MySQL运行在这台服务器上。
user: 用户名，MySQL的用户账号

\#sock登录方式  
shell>mysql -uroot -p -S /tmp/mysql5\_6.sock
如果登录成功，会有mysql>这样的提示符出现，等着你输入SQL语句。  
如果有 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 这样的错误出现，  
说明mysql服务没有运行。  
启动mysql命令，  
shell>bin/mysqld\_safe --user=mysql &  
关闭mysql命令  
shell> mysqladmin -u root -p shutdown  
Enter password: (enter root password here)

二。退出MySQL
命令是quit(\q)
mysql>quit
Bye
三。添加用户
mysql>CREATE USER ‘test’@’localhost’ IDENTIFIED BY ‘123456’;
四。修改用户密码
mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘new_password’);

mysql> UPDATE mysql.user SET Password = PASSWORD('new\_password') WHERE User = 'root';  
mysql> FLUSH PRIVILEGES;  
shell> mysqladmin -u root password "new\_password"  
shell> mysqladmin -u root -h host\_name password "new\_password"

五。添加用户和权限
详细请参考官网 http://dev.mysql.com/doc/refman/5.6/en/grant.html
mysql>GRANT ALL ON *.* TO ‘test’@’localhost’ identified by ‘123456’ WITH GRANT OPTION;
mysql>GRANT SELECT ON DB_NAME.* TO ‘test’@’localhost’ identified by ‘123456’ WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
六。查看用户权限
mysql>SHOW GRANTS FOR ‘test’@’localhost’;
七。回收权限
mysql>REVOKE ALL ON *.* FROM ‘test’@’localhost’;
八。删除用户
mysql>DROP USER ‘test’@’localhost’;