mysql如何修改密码
1. /usr/local/mysql/bin/mysqladmin -u root -p password liang
Enter password:原root密码,新密码是liang
[root@denver ~]# /usr/local/mysql/bin/mysqladmin -u liang -p password guanqun -h 192.168.128.183
Enter password:
2. root用户登陆进去后(已有用户存在情况下)
mysql> replace into mysql.user(host,user,password) values('%','liang',PASSWORD('king100'));
Query OK, 2 rows affected, 3 warnings (0.05 sec)
mysql> flush privileges; (一定要做这步,否则可能进不去)
Query OK, 0 rows affected (0.05 sec)
3. 新增用户
mysql> insert into mysql.user(host,user,password) values('%','lastday',PASSWORD('kingdee'));
Query OK, 1 row affected, 3 warnings (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
4. mysql> set PASSWORD FOR liang@'%'=PASSWORD('kingdee');
Query OK, 0 rows affected (0.03 sec)
此步骤不用做flush privileges
5. mysql> grant usage on *.* to liang@'%' identified by 'liang';
Query OK, 0 rows affected (0.05 sec)
不用做flush privileges
6. 使用phpmyadmin
看当前用户
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.01 sec)
如何得到mysql储存过程的列表:
select name,db from mysql.proc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15119715/viewspace-677115/ ，如需转载，请注明出处，否则将追究法律责任。
