MySQL安装及用户管理

#MySQL配置root密码为123；

root@slave01 opt]# mysqladmin -uroot password '2345'

 修改用户密码

    [root@slave01 ~]# mysqladmin -uroot -p'123' password '1234'

    mysql> update mysql.user set password=password('1234') where user='root';
    Query OK, 3 rows affected (0.00 sec)
    Rows matched: 3 Changed: 3 Warnings: 0

    mysql> UPDATE mysql.user SET password=PASSWORD('123') WHERE user='root';
    Query OK, 3 rows affected (0.00 sec)
    Rows matched: 3 Changed: 3 Warnings: 0

 查询当前登陆用户

    mysql> select user();
    +----------------+
    | user() |
    +----------------+
    | root@localhost |
    +----------------+
    1 row in set (0.00 sec)

 登陆MySQL数据库，查询用户

    mysql> select user,host,password from mysql.user;
    +--------+-------------+-------------------------------------------+
    | user | host | password |
    +--------+-------------+-------------------------------------------+
    | root | localhost | *A4B6157319038724E3560894F7F932C8886EBFCF |
    | root | master | |
    | root | 127.0.0.1 | |
    | rep | 192.168.1.% | *9FF2C222F44C7BBA5CC7E3BE8573AA4E1776278C |
    | pinhui | 192.168.1.% | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
    +--------+-------------+-------------------------------------------+
    5 rows in set (0.00 sec)

设置一个与root相同权限的用户

    mysql> grant all privileges on *.* to 'system'@'localhost' identified by 'xiao' with grant option;
    Query OK, 0 rows affected (0.00 sec)

创建用户及赋予权限

    mysql> grant all on shop.* to pinhui@'192.168.1.%' identified by '123';
    Query OK, 0 rows affected (0.00 sec)

 查询用户权限

    mysql >show grants;
    +----------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for root@localhost |
    +----------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' WITH GRANT OPTION |
    | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
    +----------------------------------------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)

    mysql > show grants for 'pinhui'@'192.168.1.%';
    +-----------------------------------------------------------------------------------------------------------------+
    | Grants for pinhui@192.168.1.% |
    +-----------------------------------------------------------------------------------------------------------------+
    | GRANT USAGE ON *.* TO 'pinhui'@'192.168.1.%' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
    | GRANT ALL PRIVILEGES ON `shop`.* TO 'pinhui'@'192.168.1.%' |
    +-----------------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)

 删除用户

    mysql> drop user ''@master;
    Query OK, 0 rows affected (0.00 sec)

    mysql> drop user ''@'localhost';
    Query OK, 0 rows affected (0.00 sec)
    mysql> drop user 'root'@'::1';
    Query OK, 0 rows affected (0.00 sec)

撤销已经赋予给 MySQL 用户权限的权限。

grant  all on *.* to   dba@localhost;  
revoke all on *.* from dba@localhost;