Re: mysqlgui: Can't connect to local MySQL server through socket '' ( 111) error
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
Re: mysqlgui: Can't connect to local MySQL server through socket '' (111) error
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
mysqlgui: Can't connect to local MySQL server through socket '' (111) error
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. ~/.my.cnf configuration file: -- # Example mysql config file. # You can copy this to one of: # @sysconfdir@/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] port= 3306 host = localhost user = mysql_user [client_fltk] help_file=/usr/doc/mysqlgui/MySQL.help client_file=~/.mysql/mysqlgui.options history_length=20 queries_root=~/.mysql/log queries_file=~/.mysql_history last_database_file=~/.mysql/ladb -- ~/.mysql/mysqlgui.options configuration file: -- # Options file generated by MySQL client user=mysql_user host=localhost port=3306 num_of_queries=20 timeout=60 defbase=mysql_db socket= queries_file=/my/home/path/.mysql_history queries_root=/my/home/path/.mysql/log last_database_file=/my/home/path/.mysql/ladb terminator=, enclose=' password=1 compress=0 ask=1 max_width=50 update_timeout=10 font_used=0 style_file= -- Philippe Jausions Applications Services Group Cap Gemini Ernst Young U.S. LLC
