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