I believe you need to change the socket to the location in your /etc/my.cnf file.
I usually add both sections in it just to kep things straight. [client] socket=path-for-socket-file [mysqld] socket=path-for-socket-file I used /ldata/mysql/tmp/mysql.sock my.cnf isn't automatically there so you may have to create it. then change $cfg['Servers'][$i]['socket'] = ''; to $cfg['Servers'][$i]['socket'] = 'path-used-in-my.cnf'; I am probably wrong, but its something that you can try without any danger of screwing up everything. If it doesn't work, simply remove the socket information and lines from the my.cnf file. Jason -----Original Message----- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:55 PM To: '[EMAIL PROTECTED]' Subject: phpMyAdmin/MySQL Question Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. >>Welcome to phpMyAdmin 2.3.1-rc1 >>Error >>MySQL said: >>Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '*******'; $cfg['Servers'][$i]['password'] = '*******'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info'] = ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill > William Easton > Creative Media Group > The University of Iowa > Room 1185 Westlawn > Iowa City, IA 52242 > > 319/353-3022 voice > 319/335-9127 fax > [EMAIL PROTECTED] > http://www.medicine.uiowa.edu/creative > http://telemed.medicine.uiowa.edu > > Notice: This e-mail (including attachments) is covered by the Electronic > Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may > be legally privileged. If you are not the intended recipient, you are > hereby notified that any retention, dissemination, distribution, or > copying of this communication is strictly prohibited. Please reply to the > sender that you have received the message in error, then delete it. 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 --------------------------------------------------------------------- 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
