Step 1: ensure we have mysql-server installed.
apt-get install mysql-server
Then: vim /etc/mysql/my.cnf
COMMENT OUT (with a '#'):
"bind-address = 127.0.0.1"
Restart Server with
service mysql restart
——– To test with another linux client, use
mysql -h ip.or.hostname -u root -p
(ERROR 2003 (HY000): Can’t connect to MySQL server on ‘xyz’)
iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
( ERROR 1130 (HY000): Host ‘69.80.43.240’ is not allowed to connect to this MySQL server)
Fix in phpmyadmin
Privileges Tab > root > add a new root with All hosts '%'
Recent Comments