Disable/enable Red hat Firewall
/* Disable the firewall */
Service iptables stop
/* Enable Firewall */
Service iptables start
/* Disable the firewall by default */
Chkconfig iptables off
Authorization method.
For example, if you want myuser to use mypassword to connect to the mysql server from any host.
Grant all privileges on *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option;
Flush privileges;
If you want to allow myuser to connect to the mysql server from a host whose ip address is 192.168.1.6, and use mypassword as the password
Grant all privileges on *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;
Flush privileges;
If you want to allow myuser to connect to the dk database of the mysql server from a host with ip address 192.168.1.6, and use mypassword as the password
Grant all privileges on dk. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;
Flush privileges;
I used the first method. I first found that it could not work. I checked it online and executed one less statement mysql> FLUSH RIVILEGES to make the modification take effect.
Iloveyin