新版mysql修改初始密码语句_MySql增加用户、授权、修改密码等语句

MySql增加用户、授权、修改密码等语句

数据库top_develop

登录数据库

1：新增用户

[mysql@lcamdb ~]$ mysql -u root -p

Enter password: *****

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>use mysql

mysql> insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("localhost","top_hdz",password("top_hdz"),'','','');

Query OK, 1 row affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT host, user, password FROM user WHERE user = "top_hdz";

+-----------+---------+-------------------------------------------+

| host      | user    | password                                  |

+-----------+---------+----------------------