mysql 知识管理_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;