Re: Can not connect (again)
The client has to be able to search var/lib/mysql and read and write the var/lib/mysql/mysql.socket. It is probably not able to do one of the above due to imprpoer privileges at the filesystem level. Doug Thompson wrote: Egor: Yesterday, I wrote and described that my fix for a single cpu, non-RAID environment was installing a new version. What I didn't say at the time is that the mysql.sock file was present exactly where it was supposed to be and at exactly the location the error message said it couldn't find it: var/lib/mysql/mysql.socket. Go figure. There is obviously something else going on, but I am ill-equipped to say what it is. The point I am trying to make, however, is that the procedures in the manual and all the stock answers are failing to provide a correction in many cases. I'm happy to have 3.23.49a functioning and now want to get to work with it. However, if there are data to be collected that would be helpful, I suppose I can revert to the RPM that came with RH7.1 and see if I can re-create the failure. Doug Bot Bottleneck Botulin - query On Thu, 7 Mar 2002 17:18:01 +0200, Egor Egorov wrote: d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can not connect (again)
Ok people, I'm desperate for the help. I'm going to try to be as detailed as possible, because I need the two year old explanation. I recently installed MySQL on my Cobalt Raq3. I was running fine, created a db, table created a user, gave some permissions, and thought I was rolling along. Somewhere in setting the permissions and using safe_mysql I messed something up. I am now getting an Error 2002 can't connect to local Mysql through socket var/lib/mysql/mysql.socket. I don't know much about the socket file, so if that has something to do with the problem, I'll need a brief explanation. Can someone PLEASE HELP because I'm desperate to get this fixed yesterday. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can not connect (again)
Thursday, March 07, 2002, 4:49:57 PM, you wrote: d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. dlyles, as I answered you 2 days ago: If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html d Thank you. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can not connect (again)
Bonjour, Did you try to connect to the server from network ? Try to force mysql client not to use the socket (what is does when it's connecting to localhost). Try to connect from another server or even from the same server but with the --host=xxx.xxx.xxx.xxx where xxx.xxx.xxx.xxx is the IP of the server (not 127.0.0.0 which is localhost !). This way you should be able to shutdown mysqld safely. When you restart Mysql, it will recreate the socket file. Regards, Alex. d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can not connect again
Ok, that worked. I started MySQL. I still don't know how to shutdown mysql, or if that was my problem. Unfortunately, that is the ONLY way I can log into mysql. Anyway, that would be fine, only now I have an ASP script but I am a privelegas idiot, so I don't know how to set a UID and Password. -- D. Lyles Uniquest Designs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can not connect (again)
Hi, You are closer.This error is generated only if you wish to connect from the localhost or 127.0.0.1 (i believe).To avoid this inconvenient, in arguments of mysql client,you must put -S path_of_the_mysql.socket.Usualy mysql create the socket file in tmp directory.You can also, made some modification in my.cnf file. I.E. mysql -u mysql(or root) -h localhost -S /tmp/mysql.sock This work ONLY if the mysql daemon is started. And if is not started you can do: safe_mysqld.After this you can verify if the mysql processess are active with ps -ax. Good luck, Gelu - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 5:18 PM Subject: Can not connect (again) Thursday, March 07, 2002, 4:49:57 PM, you wrote: d Ok people, I'm desperate for the help. I'm going to try to be as detailed d as possible, because I need the two year old explanation. I recently d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table d created a user, gave some permissions, and thought I was rolling along. d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. dlyles, as I answered you 2 days ago: If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html d Thank you. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can not connect (again)
Egor: Yesterday, I wrote and described that my fix for a single cpu, non-RAID environment was installing a new version. What I didn't say at the time is that the mysql.sock file was present exactly where it was supposed to be and at exactly the location the error message said it couldn't find it: var/lib/mysql/mysql.socket. Go figure. There is obviously something else going on, but I am ill-equipped to say what it is. The point I am trying to make, however, is that the procedures in the manual and all the stock answers are failing to provide a correction in many cases. I'm happy to have 3.23.49a functioning and now want to get to work with it. However, if there are data to be collected that would be helpful, I suppose I can revert to the RPM that came with RH7.1 and see if I can re-create the failure. Doug Bot Bottleneck Botulin - query On Thu, 7 Mar 2002 17:18:01 +0200, Egor Egorov wrote: d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php