How to solve an error when connecting to the mysql database

Solution 1: connect to the mysql database and report an error. mysql ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' www.2cto.com solution: Disable firewall, in linux, run the [root @ etl01 bin] # chkconfig -- list | grep-I iptables === check fire walliptables 0: off 1: off 2: on 3: on 4: on 5: on 6: off [root @ etl01 bin] #/sbin/service iptables stop === stop fire wallFlushing firewall rules: [OK] Setting chains to policy ACCEPT: nat filter [OK] Unloading iptables modules: [OK] 2. error: 1130-host... is not allowed to connect to this MySql server solution: for example, the account is root and the password is rootuse mysql; grant all privileges on *. * TO 'root' @ '%' identified by 'root' with grant option; if you want TO allow the user zz TO connect TO the mysql server from a host WITH the ip address 192.168.1.3, and use 123456 as the password grant all privileges on *. * TO 'root' @ '192. 168.1.3 'identified BY '20140901' with grant option;