[SOLVED] Mysql/Mariadb connection issues

KrazyKanuk · 09-05-2021, 09:50 AM

I am running Slackware current with a 5.10.26 kernel. I have mysql/mariadb set up and running, i have bind-address=127.0.0.1 in the mysqld section of /etc/my.cnf.d/server.cnf. I can connect perfectly if I use

Code:

mysql -u <username> -p

but if i use

Code:

mysql --host=localhost --protocol=tcp --port=3307 test

i get

Code:

ERROR 2002 (HY000): Can't connect to server on 'localhost' (111)

I have tried this with localhost,127.0.0.1,192.168.0.250 for ports 3306 & 3307 (read somewhere mariadb uses 3307 and not 3306)

I have opened the ports in iptables

Code:

sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 3307 -j ACCEPT

i have verified it is running (wouldn't let me connect if i used mysql -u <username> -p if it wasn't. I really need this to work and at a loss on what else to try, any help you could shed on this would be greatly appreciated.

berndbausch · 09-05-2021, 12:11 PM

Quote:

Originally Posted by KrazyKanuk

but if i use

Code:

mysql --host=localhost --protocol=tcp --port=3307 test

i get

Code:

ERROR 2002 (HY000): Can't connect to server on 'localhost' (111)

The port is 3306. Use ss -lntp | grep 3306 to see if something listens.

Quote:

I have tried this with localhost,127.0.0.1,192.168.0.250 for ports 3306 & 3307 (read somewhere mariadb uses 3307 and not 3306)

What error message do you get with localhost and 3306, and with 192.168.0.250 and 3306?

Can you show all netfilter rules (e.g., output of iptables -S)?

KrazyKanuk · 09-05-2021, 01:08 PM

I found the problem my /etc/rc.d/rc.mysqld had this in it:

Code:

SKIP="--skip-networking"

I changed it to this:

Code:

#SKIP="--skip-networking"

restarted mysqld and now all is well, persistence pays off.