1、登錄寶塔面板進(jìn)行安裝
2、設(shè)置MySQL連接密碼
3、安裝好了設(shè)置navicat連接
登錄MySQL
[root@hecs-394544 ~]# mysql -uroot -p
Enter password:
切換到MySQL數(shù)據(jù)
mysql> use mysql
Database changed
mysql>
查詢用戶信息
mysql> select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| 127.0.0.1 | test1 |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | test1 |
+-----------+------------------+
6 rows in set (0.00 sec)
mysql>
第一行host是我自己添加的，最下面一行是一開始就有的root賬戶，可以直接把user表的root賬戶對應(yīng)的host改為’%'就可以在Navicat上遠(yuǎn)程登錄了，就是SQL的update語句，不用搞得那么復(fù)雜
update user set host = '%' where host = 'localhost' and user = 'root';
mysql> update user set host = '%' where host = 'localhost' and user = 'root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| 127.0.0.1 | test1 |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | test1 |
+-----------+------------------+
6 rows in set (0.00 sec)
mysql>
刷新權(quán)限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
設(shè)置navicat連接文章來源：http://www.zghlxwxcb.cn/news/detail-827086.html
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; ### 123456 mysql的登錄密碼
Query OK, 0 rows affected (0.00 sec)
mysql>
刷新權(quán)限文章來源地址http://www.zghlxwxcb.cn/news/detail-827086.html
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
到了這里，關(guān)于寶塔安裝MySQL、設(shè)置MySQL密碼、設(shè)置navicat連接的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
