5

Cannot connect to MySQL Server on RHEL 5.7

view full story
linux-howto

http://serverfault.com – 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. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks ; # to do so, uncomment this line: # symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid bind-ad (HowTos)

xskl's picture
Submitted by xskl on 02/22/2012 – Made popular on 02/22/2012

Stories similar to Cannot connect to MySQL Server on RHEL 5.7

I am getting following error:

error: Found option without preceding group in config file: /etc/my.cnf at line: 1 Fatal error in defaults handling.

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

The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6.

I type mysql -u username -p and I get this message:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

any idea what happened? How to fix it?

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 ?

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.

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 mistakenly deleted some of the dependent file for mysql when I am trying to use mysql command i am getting following error :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have tried reinstalling mysql-server but it still not resolved .

What should I do to bring back everything to normal condition.

mysqld fails on F16 41 weeks 4 days ago

I have installed mysql and phpmyadmin via, yum. I get the message

#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured).

The problem though, is with mysql itself.

# service mysqld start Redirecting to /bin/systemctl start mysqld.service Job failed.