修改mysql用户密码有以下几种方式:
1、mysqladmin
mysqladmin -S /home/mysql/run/mysql.sock -u root -pmysql password "123456"
2、set password
mysql> set password=password("123456");或下面语句指定用户
mysql> set password for root@localhost = password("123456");
3、update mysql.user
mysql> update mysql.user set password=password("123456") where host='localhost' and user='root';
mysql> flush privileges;
4、grant usage
mysql> grant usage on *.* to root@localhost identified by '123456';
grant usage用于修改用户的密码、资源限制等,而不会修改用户相关权限,包括用户的连接、查询
GRANT USAGE ON *.* TO root@localhost
WITH MAX_QUERIES_PER_HOUR 20
MAX_UPDATES_PER_HOUR 10
MAX_CONNECTIONS_PER_HOUR 5
MAX_USER_CONNECTIONS 5;
限制root用户每小时20次查询、10次更新、5次连接服务器及root用户同时连接数最多为5。