mysqluser - juedaiyuer/researchNote GitHub Wiki

mysql账户

创建用户

CREATE USER 'username'@'host' IDENTIFIED BY 'passwd';

host指定该用户在哪个主机上可以登录，如果是本地用户可用localhost.如果想让该用户可以在任意远程主机登录，可以使用通配符%

查询用户

mysql> select user,host,password from mysql.user;
+----------------+-----------+-------------------------------------------+
| user           | host      | password                                  |
+----------------+-----------+-------------------------------------------+
| root           | localhost | *4D0DD2673C1DE57138354E81A957460B774C4BC2 |
| root           | %         | *4D0DD2673C1DE57138354E81A957460B774C4BC2 |
| remote         | %         | *531272762E7FD8F12C4FF4A5B586D4B293944EE9 |
| hibernate      | localhost | *531272762E7FD8F12C4FF4A5B586D4B293944EE9 |
| myblogcmsadmin | localhost | *0EFDDA6BC02D31400B1DC14AB19883A1BBEA9018 |
| admin          | localhost | *0EFDDA6BC02D31400B1DC14AB19883A1BBEA9018 |
+----------------+-----------+-------------------------------------------+
6 rows in set (0.00 sec)

更改用户名

mysql> update user set user='新用户名' where user='旧用户名';

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

修改密码

mysqladmin -u 用户名 -p password 新密码

error

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 37. Created with MySQL 50022, now running 50557. Please use mysql_upgrade to fix this error.

升级不当导致

$ mysql_upgrade -uroot -p

Could not create the upgrade info file '/home/juedaiyuer/winddata/mysql_upgrade_info' in the MySQL Servers datadir, errno: 13

source