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
