Mysql/Mariadb connection issues
by KrazyKanuk from LinuxQuestions.org on (#5P6CC)
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> -pbut if i use
Code:mysql --host=localhost --protocol=tcp --port=3307 testi 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 ACCEPTi 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.
Code:mysql -u <username> -pbut if i use
Code:mysql --host=localhost --protocol=tcp --port=3307 testi 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 ACCEPTi 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.