1

Cant connect to localhost mysql when firewall script is running

view story
linux-howto

http://serverfault.com – I have the following problem: I cant get etherpad running, when my firewall rules are active. My firewall: http://pastebin.com/82APzKhi telnet localhost 3306 gives connection timeout ps aux | grep mysql: root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ? Sl 13:54 0:27 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 root 15527 0.0 0.0 5512 720 ? (HowTos)

taskli's picture
Submitted by taskli on 08/30/2012

Stories similar to Cant connect to localhost mysql when firewall script is running

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file.

how can i log in to MySQL 1 year 26 weeks ago

I am new to ubuntu and installed MySQL use a rpm file, and started it use sudo start mysql, when i try

mysqladmin -u root password test

I get

mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I checked the my

Hello.

Running 10.04 server and mysql 5.01.

I experimendted innobackup which made a one backup file of all databases.

Tested restoring the database by first stopping mysql service (stop mysql), extracting the backup to a new dir (/var/lib/data), modified the /etc/mysql/my.cnf to point there and to check the mysqld.sock to point to /var/run/mysqld/mysqld.sock .

Code: [client] port

I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.

have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock.

I am trying to run the same server on /var/run/mysqld/mysqld1.sock.

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them --

$ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07

$ ps -ef | grep -i mysqld | grep -v grep mysql 2364 1 0 16:17 ?

I have got a error message with my MySQL server. Linux with 8 GB memory.

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid

Memory is at %10 always and Cpu at %1 Also /usr/local/apache/bin/httpd -k start -DSSL I have like 10 of them running

Mysql fun! 3 years 44 weeks ago

I am trying to set my root password for my mysql database. After I enter /etc/init.d/mysqld start

Starting MySQL: [FAILED] [root@server server]# [root@server server]# mysqladmin -u root password 'mypassword' mysqladmin: connect to server at 'localhost' failed