Re: mysqlgui: Can't connect to local MySQL server through socket '' ( 111) error

[David Zhao]

Hi there,
Where do I find mysql.sock file? I couldn't find it
under mysql or mysql-gui directory.
Thanks
Wei
--- Sinisa Milivojevic [EMAIL PROTECTED] wrote:
 Jausions, Philippe writes:
  Hi,
   
  Just wondering how to get through that Can't
 connect to local MySQL server
  through socket '' (111) error message with MySQL
 GUI for Linux (RedHat
  7.0). I configured mysqlgui through ~/.my.cnf and
 client configuration file.
  I tried the static and semi-static binary
 versions. If I put a socket
  parameter (/var/lib/mysql/mysql.sock as shown in
 mysqladmin variables. I
  also tried a /tmp/my.sock just in case...) then
 the GUI crashes with a
  core dumped. If I leave the SQL command on
 connect (or socket) blank, then
  it just gives me the connection error message
 (Yes, I'm being prompted for
  the password...)
   
  I read a lot of the messages in this mailing list,
 they all seem to refer to
  misconfigured files. I must be blind... Connection
 with the regular mysql
  client works fine.
   
  If anyone could help?
   
  Thanks.
 
 
 
 Hi!
 
 You should put /var/lib/mysql/mysql.sock in the
 specified field .
 
 But you should also use only static version of
 mysqlgui on RH 7.*, due
 to some problems on RH 7.*.
 
 This combination should work.
 
 
 Regards,
 
 Sinisa
 
     __ _   _  ___ ==  MySQL
 AB
  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa
 Milivojevic
 /*/ /*/ /*/   \*\_   |*|   |*||*|
 mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca,
 Cyprus
   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
   /*/^^^\*\^^^
  /*/ \*\   
 Developers Team
 

-
 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
 


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.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

mysql newbie question

[David Zhao]

Hi there,
I'm trying to install MySql and Mysql client
(including MySql GUI) both on Windows and Unix/Linux.
I'm having trouble reset the root password:
I ran:
./bin/mysqladmin -u root password 'mysqlroot'

./bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user: 'root@localhost'
(Using password: NO)'
and when I install MySql RPM on Linux, mysql user will
be automatically created, and do I need to change the
password for mysql too?
Please pardon my stupidity, but I just can't pass the
first step, help!
Thanks,
Wei

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.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