本人在虛擬機上又安裝了一臺linux機器，作為MySQL資料庫伺服器用，在安裝時選擇了系統自帶的MySQL伺服器端，以下是啟用步驟。 首先開啟mysqld服務 #service mysqld start 進入/usr/bin目錄#cd /usr/bin 設定mysql資料庫root用戶的密碼#mys ...
本人在虛擬機上又安裝了一臺linux機器，作為MySQL資料庫伺服器用，在安裝時選擇了系統自帶的MySQL伺服器端，以下是啟用步驟。
首先開啟mysqld服務
#service mysqld start
進入/usr/bin目錄
#cd /usr/bin
設定mysql資料庫root用戶的密碼
#mysqladmin -u root password '123456'
進入mysql資料庫管理控制台
#./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.67 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all privileges on *.* to root@'%' identified by "root";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> grant select,update,insert,delete on *.* to [email protected] identified by "root";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
上面的步驟是進行授權
然後重啟mysqld服務
# service mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
再次進入mysql管理控制台
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=password('12345678') where user='root';
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
以上步驟是修改root用戶的密碼
之後開啟防火牆的3306埠
# vi /etc/sysconfig/iptables
以下是/etc/sysconfig/iptables的內容，其中藍色一行是新加的。這一行可以由上一行複製得到，方法是在22哪行按下yy，然後按p，然後點insert鍵進入編輯模式，修改22為3306，然後點esc，輸入wq保存退出。
# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
防火牆重啟
# service iptables restart
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
iptables: Applying firewall rules: [ OK ]
之後就可以在192.168.0.100上用mysqlfront連接資料庫了。
本文轉自張昺華-sky博客園博客，原文鏈接：http://www.cnblogs.com/xiandedanteng/p/5799417.html，如需轉載請自行聯繫原作者
