【MySQL】設定MySQL密碼

標籤：centos 7.1 mysql password

// 啟動MySQL

[[email protected] tools]# systemctl start mysqld

// 以root串連到MySQL

[[email protected] tools]# mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.6.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

mysql>

// 查看使用者表

mysql> select user,host,password from mysql.user

    -> ;

+------+-----------+----------+

| user | host      | password |

+------+-----------+----------+

| root | localhost |          |

| root | 127.0.0.1 |          |

| root | ::1       |          |

|      | localhost |          |

+------+-----------+----------+

4 rows in set (0.00 sec)

mysql> 

// 設定密碼

mysql> set password for [email protected]=password(‘your-password‘);

Query OK, 0 rows affected (0.00 sec)

// 查看密碼

mysql> select user,host,password from mysql.user;

+------+-----------+-------------------------------------------+

| user | host      | password                                  |

+------+-----------+-------------------------------------------+

| root | localhost | *21ACDCFEB260C9C42B0FC5E5DC741C453A48C99D |

| root | 127.0.0.1 |                                           |

| root | ::1       |                                           |

|      | localhost |                                           |

+------+-----------+-------------------------------------------+

4 rows in set (0.00 sec)

// 退出MySQL

mysql> exit

Bye

// 重新登入MySQL

[[email protected] tools]# mysql -u root -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 5.6.25 MySQL Community Server (GPL)

【MySQL】設定MySQL密碼