安裝mysql:
參考教程:https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
shell> sudo apt-get install mysql-server
根據提示設定root賬戶密碼
複製程式碼
修改配置
1.修改配置檔案
sudo vim /etc/mysql/my.cnf或sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
註釋`bind-address = 127.0.0.1`
2.建立host(如果有"%"這個host值,則跳過這一步)
輸入 use mysql; select user,host from user;我們的目的是要把localhost用%代替即可。
如果沒有"%"這個host值,就執行下面這兩句:
mysql> update user set host='%' where user='root'; / update user set host='%' where host='localhost';
mysql> flush privileges;
3、授權使用者(需要先修改1的配置檔案,2不用)
(1)任意主機以使用者root和密碼pwd連線到mysql伺服器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;
mysql> flush privileges;
(2)指定IP為(如192.168.1.100)的主機以使用者tuser和密碼tpwd連線到mysql伺服器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'tuser'@'192.168.1.100' IDENTIFIED BY 'tpwd' WITH GRANT OPTION;
mysql> flush privileges;
4.修改配置檔案後重啟
重啟mysql:/etc/init.d/mysql restart;
複製程式碼