Mysql基本命令总结

一、用户管理类命令

创建用户

mysql> CREATE USER ‘wlw‘@‘192.168.0.22‘ IDENTIFIED BY ‘wlw‘;
mysql> use mysql;
mysql> SELECT User,Host,Password FROM user WHERE User=‘wlw‘;
+------+--------------+-------------------------------------------+
| User | Host         | Password                                  |
+------+--------------+-------------------------------------------+
| wlw  | 192.168.0.22 | *9A3A20395B8C68934181EE113D46B8056580904B |
+------+--------------+-------------------------------------------+

删除用户

mysql> DROP USER ‘wlw‘@‘192.168.0.22‘;

修改用户密码

mysql> SET PASSWORD FOR ‘wlw‘@‘192.168.0.22‘ = PASSWORD(‘test‘);
mysql> SELECT User,Host,Password FROM user WHERE User=‘wlw‘;
+------+--------------+-------------------------------------------+
| User | Host         | Password                                  |
+------+--------------+-------------------------------------------+
| wlw  | 192.168.0.22 | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+------+--------------+-------------------------------------------+

‘wlw‘@‘192.168.0.22‘授权可以管理Mysql中的所有数据库所有表。相当于管理员权限

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘wlw‘@‘192.168.0.22‘;

本文出自 “马尔高” 博客，请务必保留此出处http://kgdbfmwfn.blog.51cto.com/5062471/1704859

原文：http://kgdbfmwfn.blog.51cto.com/5062471/1704859