mysql知识管理

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博客 ” ，链接：http://blog.itpub.net/15119715/viewspace-677115/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15119715/viewspace-677115/