Re: mysqlgui problem - can't connect via tmp/mysql.sock
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]
mySQLGUI problem
everytime i submit a query, it closes the connection to my (remote) database - why? Jan Jan Davies animonkeyweb design, animation & interactive media 07 808 120 310 - 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 Problem
Rex Yuan writes: > Hello, > > When I tried to run mysqlgui, this is the error message that I received: > "can't connect to local MySQL server trough socket (111)" > > I've checked and created all the client files. What does it mean? How can > I correct it? MySQL server is up and running. > > Thank you. > > Rex Yuan > Senior IT Engineer > [EMAIL PROTECTED] > http://www.arescom.com > Tel: (510)445-3638 ext.310 > Fax: (510)445-3636 Hi! All you have to do is follow instructions from README that came with mysqlgui. Click on 'Options', fill up all entries as explained in README , click on 'Save' and re-connect. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.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
MySQLGUI Problem
Rex, Monday, February 25, 2002, 6:18:41 AM, you wrote: RY> Hello, RY> When I tried to run mysqlgui, this is the error message that I received: RY> "can't connect to local MySQL server trough socket (111)" RY> I've checked and created all the client files. What does it mean? How can RY> I correct it? MySQL server is up and running. Is there any "socket=..." line in my.cnf? Did you change the socket pathname for the server? Do you have privileges for the socket file or for the directory that contains the socket file? RY> Thank you. RY> Rex Yuan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
MySQLGUI Problem
Hello, When I tried to run mysqlgui, this is the error message that I received: "can't connect to local MySQL server trough socket (111)" I've checked and created all the client files. What does it mean? How can I correct it? MySQL server is up and running. Thank you. Rex Yuan Senior IT Engineer [EMAIL PROTECTED] http://www.arescom.com Tel: (510)445-3638 ext.310 Fax: (510)445-3636 - 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 problem
Hello Mike, I just would like to know, did you mean in your message the EMS MySQL Manager or something else? In first case your words sound very strange to me: no one of our users had write us something like this, and many of them are praises our product. Some opinions of our users about EMS MySQL Manager you can read at http://www.mysqlmanager.com . Regards, Igor Brynskich --- mailto:[EMAIL PROTECTED] http://www.ems-hitech.com - Original Message - From: "Mike Barber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 10:30 PM Subject: Re: MySQLGUI problem > I have found the MySQL Manager to be incredibly buggy and a pain to even do > the most simplest things. > > I would suggest that you try MySQL-Front > http://www.anse.de/mysqlfront/ > > Very easy to use and very functional. > > - Original Message - > From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, October 19, 2001 10:28 AM > Subject: Re: MySQLGUI problem > > > > cedric writes: > > > MySQLGUI-1.7.5 was working. > > > Now, when I start it and put the mouse pointer over it, it disappears. > > > Reinstalled only to get the same thing. > > > > > > Any ideas? > > > > > > cedric > > > > > > > What operating system do you use ?? > > > > Have you changed X version or window manager ?? > > > > > > I never heard of something like that. > > > > -- > > Regards, > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer > > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > ><___/ www.mysql.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 > > > > > > > - > 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
Re: MySQLGUI problem
I have found the MySQL Manager to be incredibly buggy and a pain to even do the most simplest things. I would suggest that you try MySQL-Front http://www.anse.de/mysqlfront/ Very easy to use and very functional. - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 10:28 AM Subject: Re: MySQLGUI problem > cedric writes: > > MySQLGUI-1.7.5 was working. > > Now, when I start it and put the mouse pointer over it, it disappears. > > Reinstalled only to get the same thing. > > > > Any ideas? > > > > cedric > > > > What operating system do you use ?? > > Have you changed X version or window manager ?? > > > I never heard of something like that. > > -- > Regards, >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ><___/ www.mysql.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 > > - 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 problem
cedric writes: > MySQLGUI-1.7.5 was working. > Now, when I start it and put the mouse pointer over it, it disappears. > Reinstalled only to get the same thing. > > Any ideas? > > cedric > What operating system do you use ?? Have you changed X version or window manager ?? I never heard of something like that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.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
MySQLGUI problem
MySQLGUI-1.7.5 was working. Now, when I start it and put the mouse pointer over it, it disappears. Reinstalled only to get the same thing. Any ideas? cedric - 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 problem
I compiled all the components of MySQLgui without problems, but when I ran the mysqlgui program, I got the following error message: "error while loading shared libraries: libsqlplus.so.1: cannot open shared object file: no such file or directory." Can you help me? -Kingsley - 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 problem - won't connect
David Reid writes:
> I just downloaded the latest version on MySQL as well as the MYSQLGUI
> program. I have MySQL installed and I can access it from the mysql
> command line but I just can't get MYSQLGUI to connect. It keeps giving
> me - Can't connect to local MySQL server through socket " (111) -
> Can you tell me where I am going wrong. I get the same error with both
> the static and semi-static versions for Linux.
>
> Thanks,
>
> David
>
Hi!
All you have to do is follow instructions from README that comes from
any of the above distros.
Here is a relevant excerpt.
When you start it for the first time, click on ``Options'' button, fill up
all entries correctly and click on ``Save'' button. From then on, you will
logon automatically to the running server on every mysqlgui startup.
Take care to put the right value in ``Ask for password'' button. Also, if
you have problems with location of socket files on *nix, enter a full path
of the socket file in the ``SQL command on the start-up''. This input field
is used on Windoze if you wish to specify that named pipe option.
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 problem - won't connect
I just downloaded the latest version on MySQL as well as the MYSQLGUI program. I have MySQL installed and I can access it from the mysql command line but I just can't get MYSQLGUI to connect. It keeps giving me - Can't connect to local MySQL server through socket " (111) - Can you tell me where I am going wrong. I get the same error with both the static and semi-static versions for Linux. Thanks, David - 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 problem - won't connect
I just downloaded the latest version on MySQL as well as the MYSQLGUI program. I have MySQL installed and I can access it from the mysql command line but I just can't get MYSQLGUI to connect. It keeps giving me - Can't connect to local MySQL server through socket " (111) - Can you tell me where I am going wrong. I get the same error with both the static and semi-static versions for Linux. Thanks, David - 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: Wierd mysqlgui problem
David Wilde writes:
> I have tried that with no avail. The GUI asks for my password when I
> connect, and I am able to run select queries from the GUI, but all of the
> things on the Commands menu that involve changing data don't work. Thanks,
>
> Dave W.
HI!
What exactly does not work except "Table Edit" and "Create Table",
which are in the works or on our TODO list.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
RE: Wierd mysqlgui problem
I have tried that with no avail. The GUI asks for my password when I
connect, and I am able to run select queries from the GUI, but all of the
things on the Commands menu that involve changing data don't work. Thanks,
Dave W.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 5:55 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject:Re: Wierd mysqlgui problem
David Wilde writes:
> Hello All,
>
> I am new to MySQL and I am sure you have all heard this question a
million
> times, so I appologize in advance. My question is, I have installed
MySQL
> on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
> running fine with one minor exception. When using mysqlgui from a
windows
> machine I get the error "Error in database function: Access Denied for
user:
> '[EMAIL PROTECTED]" (Using password: YES)" I have added the username to
> the mysql database using the command "GRANT ALL ON *.* TO user@"%"
> IDENTIFIED BY "password" WITH GRANT OPTION" and have also added the
> [EMAIL PROTECTED] and removed all of the anonymous entries (just in
case).
> Since I am new to this I am not sure what I am doing wrong. The user can
> create databases and tables using the mysql command on the linux box.
> Thanks in advance for the help.
Hi!
As you have a password set for that user, you should enable "Ask for
password" button in Options page, so that you can enter password.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
-
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: Wierd mysqlgui problem
David Wilde writes:
> Hello All,
>
> I am new to MySQL and I am sure you have all heard this question a million
> times, so I appologize in advance. My question is, I have installed MySQL
> on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
> running fine with one minor exception. When using mysqlgui from a windows
> machine I get the error "Error in database function: Access Denied for user:
> '[EMAIL PROTECTED]" (Using password: YES)" I have added the username to
> the mysql database using the command "GRANT ALL ON *.* TO user@"%"
> IDENTIFIED BY "password" WITH GRANT OPTION" and have also added the
> [EMAIL PROTECTED] and removed all of the anonymous entries (just in case).
> Since I am new to this I am not sure what I am doing wrong. The user can
> create databases and tables using the mysql command on the linux box.
> Thanks in advance for the help.
Hi!
As you have a password set for that user, you should enable "Ask for
password" button in Options page, so that you can enter password.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
Wierd mysqlgui problem
Hello All, I am new to MySQL and I am sure you have all heard this question a million times, so I appologize in advance. My question is, I have installed MySQL on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be running fine with one minor exception. When using mysqlgui from a windows machine I get the error "Error in database function: Access Denied for user: '[EMAIL PROTECTED]" (Using password: YES)" I have added the username to the mysql database using the command "GRANT ALL ON *.* TO user@"%" IDENTIFIED BY "password" WITH GRANT OPTION" and have also added the [EMAIL PROTECTED] and removed all of the anonymous entries (just in case). Since I am new to this I am not sure what I am doing wrong. The user can create databases and tables using the mysql command on the linux box. Thanks in advance for the help. - 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
