Problem with MySQL-GUI
Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me what I'm doing wrong? I tried to set the path using a shell program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. Sincerely, Allan J Horwitz P.S. -- I don't remember it being this difficult with Windows98. In Windows, you just unzipped it and put it in with the rest of your mysql program file (C:\MySql\ ) and it ran fine without a hitch. - 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: Problem with MySQL-GUI
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote: Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me what I'm doing wrong? I tried to set the path using a shell program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. I believe MySQL-GUI tried by default to connect to the mysql server (mysqld) running on localhost using the socket connection (as supposed to tcp/ip ). The error message you are getting seems to indicate that your computer does not run mysqld. Check out here how to get it started: http://www.mysql.com/doc/en/Automatic_start.html /h - 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: Problem with MySQL-GUI
running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote: Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me what I'm doing wrong? I tried to set the path using a shell program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. I believe MySQL-GUI tried by default to connect to the mysql server (mysqld) running on localhost using the socket connection (as supposed to tcp/ip ). The error message you are getting seems to indicate that your computer does not run mysqld. Check out here how to get it started: http://www.mysql.com/doc/en/Automatic_start.html /h - 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: Problem with MySQL-GUI
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? If I am not mistaken the socket works only for a connection between server and client running on the same host. It is more effective since it skips the network stacks and you can see it as a kind of shortcut. But whenever you connect from the outside (or use mysql -h localhost -P 3306 for the localhost connection) the communication between client and server happens via tcp/ip via port 3306 (standard port you may choose another if you see fit or run several servers on the same host). This is very much like a browser contacting a webserver via port 80 (again that is just the default). I am sure other members on this excellent list will fill in the gaps or correct me where I am in error. Best/h - 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: Problem with MySQL-GUI
i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? If I am not mistaken the socket works only for a connection between server and client running on the same host. It is more effective since it skips the network stacks and you can see it as a kind of shortcut. But whenever you connect from the outside (or use mysql -h localhost -P 3306 for the localhost connection) the communication between client and server happens via tcp/ip via port 3306 (standard port you may choose another if you see fit or run several servers on the same host). This is very much like a browser contacting a webserver via port 80 (again that is just the default). I am sure other members on this excellent list will fill in the gaps or correct me where I am in error. Best/h - 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: Problem with MySQL-GUI
On 11/10/02 9:42 PM, daniel [EMAIL PROTECTED] wrote: i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same computer you can just type: 'mysql' on the command line and then the client automatically connects you to the server using the socket. The computer in this case is called 'localhost': local: because everything happens local, and is completely independent if you are connected to any network or not host: because your computer hosts the mysql server As soon as you connect to a mysql server running on a remote computer you can either telnet or ssh into that remote computer, call mysql and connect via the socket on that computer but in many cases (if you have remote connect privileges) you can just call: mysql -h the.remote.dbhost -P 3306 -u dbusername -p and use your local client (running on your computer) to connect to the mysqld (server) running on the remote computer and then you use tcp/ip and not the socket. ...but you knew all this anyway :-)/h - 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: problem wtih mysql GUI
D. Veerasamy writes: Dear Sir/ Madam Can you please help me with the GUI client running under linux. I'm having an error message saying: Can't connect to local MySQL server through socket (111) Thanking you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Hi! Beside Ralf's comments, please follow the instructions from the README, here is the 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
problem wtih mysql GUI
Dear Sir/ Madam Can you please help me with the GUI client running under linux. I'm having an error message saying: Can't connect to local MySQL server through socket (111) Thanking you. - 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: problem wtih mysql GUI
1. Check that the connection is correct. 2. Check that the mysql server is running and that the socket file exists. 3. Check that the socket file is in the correct place and has the correct permissions. - Original Message - From: D. Veerasamy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 1:48 Subject: problem wtih mysql GUI Dear Sir/ Madam Can you please help me with the GUI client running under linux. I'm having an error message saying: Can't connect to local MySQL server through socket (111) Thanking you. - 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
problem of MYSQL GUI
I am experienced a problem of using MYSQL GUI on windowME to connect mysql server, which was v3.22 and installed on open linux . I couldn't make any connection with it and don't know why. I checked my password and Ip address, they both are correct and working properly. please be kind to giving hand Thanks
Re: problem of MYSQL GUI
I am experienced a problem of using MYSQL GUI on windowME to connect = mysql server, which was v3.22 and installed on open linux . I couldn't make any connection with it and don't know why. =20 I checked my password and Ip address, they both are correct and working = properly. please be kind to giving hand Thanks Hi! All you have to do is follow instructions from the README file that came with mysqlgui. 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