text: [SOLVED] mysql sock file issue on Linux Red Hat 6
  11-21-2012, 06:17 AM #1
  mysql sock file issue on Linux Red Hat 6
  consider I am beginner in mysql.
  I have mysql DB install on Reh Hat 6 server. I do want to make some changes in /etc/my.cnf file but for that I do require file /var/run/mysqld/mysqld.sock.
  when I check mysqld.sock file i do not found this on above mention location but do found this file at /var/lib/mysql/mysql.sock.
  I just want to know whether this is the same file which I want at /var/run/mysqld/mysqld.sock location?
  it will be the same thing, but it's not that you "need the file" it's that that socket file is how the local client will connect to the server, and lack of it says that mysql is not running in the first place.
  11-21-2012, 08:00 AM #3
  let me explain the exact issue. I have win 7 system and some users want to connect mysqlDB from win 7.but they are getting connection error.when I googled the issue I found the solution but for it I need to do some changes in /etc/my.cnf file on mysqlDB server(os is red hat6)changes need to be done as per below.
  but when I checked all files mention above, I found all files but .sock file is not on the place as mention above.as I mention below i found the file in location /var/lib/mysql/mysql.sock instead of /var/run/mysqld/mysqld.sock.
  now my confusion is that, can I mention in /etc/my.cnf that the sock file location as /var/lib/mysql/mysql.sock instead of /var/run/mysqld/mysqld.sock?
  also I have observe that the size of /var/lib/mysql/mysql.sock which is available now on server is "0".
  is that will work? any idea?
  11-21-2012, 09:14 AM #4
  you shouldn't be changing the socket file from the default, there shoudl be no need. Did you install it in some unusual way?
  The file has no size, as it's a socket file, a pipe held on the filesystem which the server should already have open.
  note that you need to ignore connectivity from windows etc... either Mysqkl is working or it's not. Can you not even connecrt with the mysql client tool locally on the box?
  11-22-2012, 04:40 AM #5
  issue has been resolved now. I open port on MsqlDB server in Iptables and create a user for the specific server(remote windows system)