Dmitry Rusak writes: > Hi! > I have a problem using musqlgui-1.7.2 under FreeBSD 4.9 STABLE. It "Can't connect to > mysql > server via tmp/mysql.sock" > > My setup: > 1) mysql is installed in /usr/local/mysql > data base directory - /usr/local/mysql/data > socket directory - /usr/local/mysql/tmp/mysql.sock > > 2) currenlty i am using FreeBSD 4.2 static binary of MySQLGUI 1.7.2 > 3) I have created: > /etc/my.cnf > /etc/.my.cnf > ~/my.cnf > ~/.my.cnf > /usr/local/etc/my.cnf > /usr/local/etc/.my.cnf > > with the same content: > ----------------------------------- > [client] > port = 3306 > host = localhost > user = root > > [client_fltk] > client_file=~/.mysql.options > queries_file=~/.mysql_history > history_length=100 > database=my_db - (this db exists!) > ----------------------------------------- > > The problem: > When executing mysqlgui it first asks me for a password. I assume it should be the > root > password (or not? actually in my case mysql is configured to work under "mysql" > user, but i > tryed password for this user also). > > I am entering the password and then it says in "Info" line at the bottom of window > that "Can't > connect to mysql server via tmp/mysql.sock". > > When i am pressing on "+" to see full message log it shows the lines that options > are > successifully read from options file and so on - so, no problem here. > > In "options" of mysqlgui i have localhost, port 3306. > > There is no problem with running ordinary "mysql" client. > > I think probably because mysql server has been installed not in standard directory, > it can not > find it. So, maybe there is a chance to configure the path to mysql? > > Or something other? > > Best regards, > Dmitry
First of all, please use version 1.7.5. 1.7.2 has too many bugs. You should add socket option under [client] and you should put /usr/local/mysql/tmp/mysql.sock there as well as under [mysqld] options header. You should also make /usr/local/mysql/tmp/ directory scannable etc .. by all, plus with temporary attribute. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus Meet the MySQL at User Conference ! (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]