3、設(shè)置/修改密碼
方式一：
1.登陸到mysql中，將密碼修改為123456
mysql> set password for root@localhost = password('123456');
Query OK, 0 rows affected (0.00 sec)
2.退出mysql
mysql> exit;
Bye
3.再次登陸需要使用密碼登陸
[root@server-mysql src]# mysql -u root -p
Enter password: root
方式二：
1.登陸到mysql中，切換到mysql庫(kù)
mysql> use mysql;
2.直接更新user表
mysql> update user set password=password('123456') where user='root' and host='localhost';
3.刷新權(quán)限表
mysql> flush privileges;
方式三： 使用navicat修改炮赦，需要使用navicat連接上這個(gè)數(shù)據(jù)庫(kù)
image.png
image.png
4、修改遠(yuǎn)程連接權(quán)限
1.切換到mysql庫(kù)
mysql> use mysql;
Database changed
2.查看用戶和能連接的主機(jī), 發(fā)現(xiàn)root用戶只能在本機(jī)連接(host中地址都是代表本機(jī))样勃，不能遠(yuǎn)程用navicat連接
mysql> select user, host from user where user = 'root';
+------+--------------+
| user | host |
+------+--------------+
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
| root | server-mysql |
+------+--------------+
4 rows in set (0.00 sec)
3.修改用戶訪問的地址
mysql> Grant all privileges on *.* to root@'%' identified by '123456' with grant option;
Query OK, 0 rows affected (0.00 sec)
說明：*.*指對(duì)數(shù)據(jù)的所有權(quán)限(增刪改查), root指連接上來的用戶名,
‘%’指所有外部ip地址都可以連接上來吠勘，如果要指定地址可以這樣寫 ‘100.100.100.100’,
identified by 后跟的是連接上來的密碼
4.再次查看, 發(fā)現(xiàn)root用戶多了一個(gè)主機(jī)地址（%）
mysql> select user, host from user where user = 'root';
+------+--------------+
| user | host |
+------+--------------+
| root | % |
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
| root | server-mysql |
+------+--------------+
5 rows in set (0.00 sec)
5.刷新一下權(quán)限表
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
6.開放端口
[root@server-mysql src]# firewall-cmd --add-port=3306/tcp --permanent
success
[root@server-mysql src]# firewall-cmd --reload
success
