cannot connect remotely on 3306
Hi, On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. Please help Nicu
Re: cannot connect remotely on 3306
Hi again, I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). Thanks Nicu On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: Hi, On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. Please help Nicu
Re: cannot connect remotely on 3306
Am 12.04.2014 16:37, schrieb Nicolae Marasoiu: I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. that's hardly a mysql problem * the windows telnet client is unuseable because it strips outputs * how long do you wait for a response? most likely you run into dns timeouts especially if ipv6 is enabled and not proper configured network wide and if your network is wrong configured at all (no PTR records for your IP's for ipv4 and ipv6 well then you have both timeouts for name-resolve) try skip-name-resolve in my.cnf but be aware that you need to use ip-addresses for mysql-permissions instead hostnames get rid of Windows and setup a virtual machine for development servers will solve a lot of problems - i maintained over years two customers with mysql on Windows servers and that wasted more time than the 30 production servers on Linux signature.asc Description: OpenPGP digital signature
Re: cannot connect remotely on 3306
solved.. firewall was up:) it had 3 profiles and i had just set it off on one of them Trimis de pe iPhone-ul meu Pe 12.04.2014, la 17:48, Reindl Harald h.rei...@thelounge.net a scris: Am 12.04.2014 16:37, schrieb Nicolae Marasoiu: I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. that's hardly a mysql problem * the windows telnet client is unuseable because it strips outputs * how long do you wait for a response? most likely you run into dns timeouts especially if ipv6 is enabled and not proper configured network wide and if your network is wrong configured at all (no PTR records for your IP's for ipv4 and ipv6 well then you have both timeouts for name-resolve) try skip-name-resolve in my.cnf but be aware that you need to use ip-addresses for mysql-permissions instead hostnames get rid of Windows and setup a virtual machine for development servers will solve a lot of problems - i maintained over years two customers with mysql on Windows servers and that wasted more time than the 30 production servers on Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Cannot connect to MySql Database
Hi, I am trying to connect to a MySql database and I keep getting the following: Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network Failed to connect to Unix socket '/var/run/lirc/lircd' No such file or directory (2) The database is located on a MacBook running OS X 10.8. The MySql Server is running. Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Cannot connect to MySql Database
On 4/9/13 1:54 PM, Joe Kosinski joj...@gmail.com wrote: Hi, I am trying to connect to a MySql database and I keep getting the following: Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network Failed to connect to Unix socket '/var/run/lirc/lircd' No such file or directory (2) The database is located on a MacBook running OS X 10.8. The MySql Server is running. Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql The hostname can't be found. Try localhost instead of Joseph-Kosinskis-MacBook. As for the next error, that's not a database error, that's a MythTV error. lircd is the daemon for remotes (Linux Infrared Remote Control Daemon). Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL running, but I cannot connect
Hi All, MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. I checked the firewall and that is successfully allowing the passage. I checked the firewall on the server and that has 3306:tcp allowed. When I try to connect I get an error (4) which when I google says: Interrupted System call I have tried using the MySQL Workbench and other client software. If I look in /var/log/mysqld.log I dont see anything but the fact the server started. I tried stopping mysql with /etc/init.d/mysqld stop Then starting with mysqld_safe --init-file=/tmp/code.txt Where code.txt contains: UPDATE mysql.user SET Password=PASSWORD('BabyToad09') WHERE User='root'; GRANT ALL ON mysql.* to 'root'@'127.0.0.1'; GRANT ALL ON mysql.* TO 'root'@'localhost'; GRANT ALL ON mysql.* TO 'root'@'my home IP'; FLUSH PRIVILEGES; commit; and I still cannot connect. What am I doing wrong? What can I check for? Things work, just not for me from home. -Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL running, but I cannot connect
Hi Jason, Here is what I did to connect: 1) start a client session on server host machine and issue a grant command. /usr/local/mysql$ bin/mysql -u root run a client session as the root, directory your executable resides might be different than what's shown mysql use mysql ; mysql grant all on mydatabase.* to root ; replace mydatabase with yours 2) start a client session from a remote host. /usr/local/mysql$ bin/mysql -u root --host=192.168.2.3 run a client session as the root, directory your executable resides might be different than what's shown, also replace the IP address with that of your MySQL server host machine. Good luck ! Hiromichi --- On Mon, 12/21/09, ML mailingli...@mailnewsrss.com wrote: From: ML mailingli...@mailnewsrss.com Subject: MySQL running, but I cannot connect To: mysql@lists.mysql.com Date: Monday, December 21, 2009, 8:35 PM Hi All, MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. I checked the firewall and that is successfully allowing the passage. I checked the firewall on the server and that has 3306:tcp allowed. When I try to connect I get an error (4) which when I google says: Interrupted System call I have tried using the MySQL Workbench and other client software. If I look in /var/log/mysqld.log I dont see anything but the fact the server started. I tried stopping mysql with /etc/init.d/mysqld stop Then starting with mysqld_safe --init-file=/tmp/code.txt Where code.txt contains: UPDATE mysql.user SET Password=PASSWORD('BabyToad09') WHERE User='root'; GRANT ALL ON mysql.* to 'root'@'127.0.0.1'; GRANT ALL ON mysql.* TO 'root'@'localhost'; GRANT ALL ON mysql.* TO 'root'@'my home IP'; FLUSH PRIVILEGES; commit; and I still cannot connect. What am I doing wrong? What can I check for? Things work, just not for me from home. -Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=hiromichiwat...@yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Cannot Connect on Windoze
Hi; I have successfully installed MySQL and got it running on Windoze. But when I try to connect, I get this error: Can't connect to MySQL server on 'localhost' (10061) Also I can't connect on Run. What do? TIA, Victor PS Only online an hour or so weekly, so if slow in responding, know why.
Re: Cannot Connect: Can't create a new thread (errno 11)
Chris, Did you check if there are any user level MAX_USER_CONNECTIONS restriction set while granting access ? Thanks Alex On 7/4/07, Chris Faust [EMAIL PROTECTED] wrote: Folks, I'm wondering is someone could help us in trying to resolve the above error, we have read through what threads we could find and tried all the suggestions, but have had no luck. There are no memory problems, in fact when this happens if there is still a localhost client connection to the server you can do whatever you want, everything is running normal. It just refuses all new connections. When it happens there is plenty of memory on the machine and no load at all (everything is running just as it should). Once things fall below 90, everything comes back. The problem happens when the process list hits the 91st process every time. 90 processes, no problems, the 91st process/connection gets the above error and any after that simple gets Can't connect to MySQL server. We've tried all the obvious things, messing with the number of connections, open files etc. Nothing seems to work. We are running MySQL 5 on Centos 5 (flavor of RedHat). The machine is dedicated to MySQL. Below is a link to a text file that shows the OS limits for the mysql account on the machine and the output from show variables (including it made the message to large for the list). http://208.3.90.212/wtresults.txt If anyone has any suggestions, it would be appreciated. Thanks!
RE: Cannot Connect: Can't create a new thread (errno 11)
Hi Alex, You mean in the user table, right? max_questions, max_updates and max_connections are all set to 0 for all accounts. Can you think of anything else? Thanks -Chris From: [EMAIL PROTECTED] on behalf of Alex Arul Lurthu Sent: Thu 7/5/2007 2:03 AM To: cfaust-dougot Cc: mysql@lists.mysql.com Subject: Re: Cannot Connect: Can't create a new thread (errno 11) Chris, Did you check if there are any user level MAX_USER_CONNECTIONS restriction set while granting access ? Thanks Alex On 7/4/07, Chris Faust [EMAIL PROTECTED] wrote: Folks, I'm wondering is someone could help us in trying to resolve the above error, we have read through what threads we could find and tried all the suggestions, but have had no luck. There are no memory problems, in fact when this happens if there is still a localhost client connection to the server you can do whatever you want, everything is running normal. It just refuses all new connections. When it happens there is plenty of memory on the machine and no load at all (everything is running just as it should). Once things fall below 90, everything comes back. The problem happens when the process list hits the 91st process every time. 90 processes, no problems, the 91st process/connection gets the above error and any after that simple gets Can't connect to MySQL server. We've tried all the obvious things, messing with the number of connections, open files etc. Nothing seems to work. We are running MySQL 5 on Centos 5 (flavor of RedHat). The machine is dedicated to MySQL. Below is a link to a text file that shows the OS limits for the mysql account on the machine and the output from show variables (including it made the message to large for the list). http://208.3.90.212/wtresults.txt If anyone has any suggestions, it would be appreciated. Thanks!
Cannot Connect: Can't create a new thread (errno 11)
Folks, I'm wondering is someone could help us in trying to resolve the above error, we have read through what threads we could find and tried all the suggestions, but have had no luck. There are no memory problems, in fact when this happens if there is still a localhost client connection to the server you can do whatever you want, everything is running normal. It just refuses all new connections. When it happens there is plenty of memory on the machine and no load at all (everything is running just as it should). Once things fall below 90, everything comes back. The problem happens when the process list hits the 91st process every time. 90 processes, no problems, the 91st process/connection gets the above error and any after that simple gets Can't connect to MySQL server. We've tried all the obvious things, messing with the number of connections, open files etc. Nothing seems to work. We are running MySQL 5 on Centos 5 (flavor of RedHat). The machine is dedicated to MySQL. Below is a link to a text file that shows the OS limits for the mysql account on the machine and the output from show variables (including it made the message to large for the list). http://208.3.90.212/wtresults.txt If anyone has any suggestions, it would be appreciated. Thanks!
Re: Cannot connect to server
Sara Woglom wrote: Thanks Shawn!! You should be thanking Mladen Adamovic for pointing you to: http://dev.mysql.com/doc/mysql/en/grant.html This page holds your answer. From the error message you got Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL server you can be assured that you made a connection to the MySQL server. The problem is the MySQL server doesn't think you should be allowed to connect. I'm sure if you read the page linked above you will be able to persuade your MySQL server into allowing you to connect to it. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect to server
I have just installed MySQL 5.0, and I am unable to connect to it from my own (remote) machine. It all works fine when I open mysqladmin from the server itself, so I know the installation is OK. I am working on a small LAN of about 15 PCs. When I try to telnet to the default port (3306), I get the following error: Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL server I am not a network person so I am having some trouble. Please advise if possible! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect to server
Sara Woglom wrote: I have just installed MySQL 5.0, and I am unable to connect to it from my own (remote) machine. It all works fine when I open mysqladmin from the server itself, so I know the installation is OK. I am working on a small LAN of about 15 PCs. When I try to telnet to the default port (3306), I get the following error: Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL server I am not a network person so I am having some trouble. Please advise if possible! You seem to have is privilage errors: check this out here http://dev.mysql.com/doc/mysql/en/grant.html -- Mladen Adamovic http://home.blic.net/adamm http://www.shortopedia.com http://www.froola.com
RE: Cannot connect to server
Thanks Shawn!! Here is some more pertinent information: * The server is running on Windows 2003 Server SP-1 * There is no switch between me and the server * I don't know the firewall program, and don't really know how to find out; I checked Program Files and running processes but nothing jumps out at me * I CAN tell you that I cannot open Windows Firewall -- I get an error message saying, Windows Firewall cannot run because another program or service is running that might use the network address translation component (Ipnan.sys). From my web research, I think the other program or service is remote access/VPN, which obviously I can't just disable * Since I can't get into Windows Firewall, I don't know how else to open up port 3306 Hopefully this information will allow someone out there to better guide me. Appreciate any help! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 1:08 PM To: Sara Woglom Cc: mysql@lists.mysql.com Subject: Re: Cannot connect to server Sara Woglom [EMAIL PROTECTED] wrote on 03/10/2006 11:54:03 AM: I have just installed MySQL 5.0, and I am unable to connect to it from my own (remote) machine. It all works fine when I open mysqladmin from the server itself, so I know the installation is OK. I am working on a small LAN of about 15 PCs. When I try to telnet to the default port (3306), I get the following error: Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL server I am not a network person so I am having some trouble. Please advise if possible! Good job on looking up that telnet test. Most newbies either don't or won't look for just that simple bit of diagnostic information (thank you!). The error you got is telling you that somewhere between your machine and the server, you have been rejected from contacting that server. Most likely it will be a firewall on the server itself but it might be a switch between you and the server but I highly doubt it with such a small LAN. I would start at the server and check it for any kind of firewall program and make sure that you open up port 3306 for inbound traffic. If you get very specific about what kind of OS your server is on, there may be some people on this list that can help you find your firewall and poke a hole through it for your DB to listen through. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to mysql
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html ghislain groulx wrote: im quite new to mysql and here is the problem. I simply cannot connect to mysql through phpmyadmin or anything else. Lets say i enter the url to connect (localhost/phpmyadmin/index.html) i end up in the welcome page but it says access denied for user [EMAIL PROTECTED] (using password: NO) when i do the phpinfo test, everything seems to be ok with the server (i run apache) and mysql and php are installed and running, but i simply cannot connect. i guess the problem is the username and password or something like in the configuration of mysql that but i cant figure it out. Can someone tell me what i am missing ? thanks a lot !! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to mysql
im quite new to mysql and here is the problem. I simply cannot connect to mysql through phpmyadmin or anything else. Lets say i enter the url to connect (localhost/phpmyadmin/index.html) i end up in the welcome page but it says access denied for user [EMAIL PROTECTED] (using password: NO) when i do the phpinfo test, everything seems to be ok with the server (i run apache) and mysql and php are installed and running, but i simply cannot connect. i guess the problem is the username and password or something like in the configuration of mysql that but i cant figure it out. Can someone tell me what i am missing ? thanks a lot !! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to database
I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to database
add a user in the table for your remote hostname or ip number. On 12/31/05, Jon Miller [EMAIL PROTECTED] wrote: I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
Re: cannot connect to the mysql server.thank you.
wrote: dear sir, nice to meet you. now i have installed the MySQL-ServerClient(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. In what platform did you install it? thanks, Ehrwin Mina Chikka Asia Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to the mysql server.thank you.
dear sir, (BThanks your answer. (BI install in Windows 2000 professional platform.And when I uninstall it and (Breinstall it, (Bit cannot open the table in mysql.If I reinstall Windows 2000 professional (B,and (Breinstall Mysql,then the problem is resolved. (BTnank you very much. (B (BAt 16:56 05/04/13, Ehrwin Mina wrote: (B$B2(B wrote: (B (Bdear sir, (Bnice to meet you. (Bnow i have installed the MySQL-ServerClient(4[1].0.15).but i cannot (Bconnect mysql server when i make a change. (Bwhat is the wrong with what i do?l (Bcan i get your help? (Bthank you very much. (B (B (B (B (B (B (BIn what platform did you install it? (B (Bthanks, (B (BEhrwin Mina (BChikka Asia Inc. (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to the mysql server.thank you.
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html dear sir, nice to meet you. now i have installed the MySQL-ServerClient(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to the mysql server.thank you.
dear sir, nice to meet you. now i have installed the MySQL-ServerClient(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Okay, with the good help I was getting, and looking at the all clues MySQL was giving me, like Table 'mysql.host' doesn't exist and Can't find file: './mysql/host.frm', I concluded that the 4.1.9 installation conflicts with the default 4.0.18 installation. For instance, 4.0.18 expects files in /var/mysql and /usr/libexec, but 4.1.9 wants them in /usr/local/mysql, etc. There isn't a mysql/data directory anywhere at all for 4.0.18. The two seem incompatible (at least, it's beyond me...). So, I backed out my 4.1.9 installation, and was able to get things going again under 4.0.18. I guess I'll have to wait until Apple upgrades MySQL with OS X 10.3.8. Thanks to all! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.sock file exists, but still cannot connect to server
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Alex Majora wrote: I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: What is this? These messages do not appear to have come from mysql. There's something you haven't told us. What is RemoteManagement/RMDB? Is this something you run by hand, or something automated? /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. Have you tried doing what it says here? MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data That doesn't appear to be mysql. When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 That certainly seems to be a message (syntax error) from mysql. 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete Not sure why, but mysqld just shut down. When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Are you sure mysqld is running? You got a shutdown message right before this. ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Well, that should mean mysqld is running. Two things: 1) Use ps to make sure there's a mysqld process (ps -aux | grep mysqld). 2) Check the permissions on /tmp (actually, /private/tmp under OS X). Some OS X updates have changed /tmp permissions in the past. Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running? You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld process running in the ps -aux listing. However, if I try to start mysqld up again, I get: 050119 14:48:43 Can't start server : Bind on unix socket: Address already in use 050119 14:48:43 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 050119 14:48:43 Aborting 050119 14:48:43 /usr/libexec/mysqld: Shutdown Complete Check the permissions on /tmp drwxrwxrwt 14 root wheel 476 19 Jan 14:43 /private/tmp Don't know if this is what it's supposed to be for /tmp. Thanks for your help! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
The postmaster is a Postgres daemon, and pg_shadow is the user table for postgres. Clint From: Michael Stassen [EMAIL PROTECTED] To: Alex Majora [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: mysql.sock file exists, but still cannot connect to server Date: Wed, 19 Jan 2005 17:42:34 -0500 Alex Majora wrote: I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: What is this? These messages do not appear to have come from mysql. There's something you haven't told us. What is RemoteManagement/RMDB? Is this something you run by hand, or something automated? /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. Have you tried doing what it says here? MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data That doesn't appear to be mysql. When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 That certainly seems to be a message (syntax error) from mysql. 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete Not sure why, but mysqld just shut down. When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Are you sure mysqld is running? You got a shutdown message right before this. ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Well, that should mean mysqld is running. Two things: 1) Use ps to make sure there's a mysqld process (ps -aux | grep mysqld). 2) Check the permissions on /tmp (actually, /private/tmp under OS X). Some OS X updates have changed /tmp permissions in the past. Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe [1] 2058 Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/whitestar.alpha.net.pid 050119 17:13:12 mysqld ended Is there a way to have mysqld issue more verbose error messages? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Alex Majora wrote: Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running? You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld process running in the ps -aux listing. However, if I try to start mysqld up again, I get: 050119 14:48:43 Can't start server : Bind on unix socket: Address already in use 050119 14:48:43 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 050119 14:48:43 Aborting 050119 14:48:43 /usr/libexec/mysqld: Shutdown Complete As you probably know, mysqld should create /tmp/mysql.sock on startup and destroy it on shutdown. As long as you are certain that mysqld is not running, that would mean that it wasn't shut down properly last time and left the socket file in the way. In that case, removing it manually with sudo rm /tmp/mysql.sock should allow mysqld to start. Check the permissions on /tmp drwxrwxrwt 14 root wheel 476 19 Jan 14:43 /private/tmp That's as it should be. Don't know if this is what it's supposed to be for /tmp. Thanks for your help! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Details should be in the .err file in the data directory (/usr/local/mysql/data/whitestar.alpha.net.err, in your case). Michael Alex Majora wrote: Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe [1] 2058 Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/whitestar.alpha.net.pid 050119 17:13:12 mysqld ended Is there a way to have mysqld issue more verbose error messages? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote: Details should be in the .err file in the data directory Here's the contents of the file: 050119 17:30:02 mysqld started 050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 050119 17:30:02 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050119 17:30:02 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050119 17:30:02 InnoDB: Flushing modified pages from the buffer pool... 050119 17:30:02 InnoDB: Started; log sequence number 0 43634 050119 17:30:02 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050119 17:30:02 mysqld ended It would seem that the issue about table 'mysql.host' is the problem. Is there a way to create this table outside of mysql? Or does this indicate no schema at all in the DB? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect to mysql through network while unix socket works
N,jjkj{zwkozz xjDear all, I have a mysql-4.0.12 server installed on RH 8, it works fine for months before I find the server unavailable from the remote host on the same LAN. I am sure there isn't any firewall between server and client. I ssh to the server and find the mysqld is running and functional, because I can connect to it via unix socket!!! Things not changed event restart the mysql service, so I have to reboot the server :( Anybody here has the same experience, and how this happened? Oscar Yen.
Re: Cannot connect to local server problem
Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Leandro Melo [EMAIL PROTECTED] wrote: Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a laptop, which runs Windows 2000. When i installed MySQL 4.0.17 and tried to run the client from command line, i got the following error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I don't remember this problem when i first installed the db in windows XP (or maybe i just don't remeber solving it). What am i missing? How do i fix that? Thanks, ltcmelo ___ Yahoo! Mail - Agora com 250MB de espa?o gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect to local server problem
Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a laptop, which runs Windows 2000. When i installed MySQL 4.0.17 and tried to run the client from command line, i got the following error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I don't remember this problem when i first installed the db in windows XP (or maybe i just don't remeber solving it). What am i missing? How do i fix that? Thanks, ltcmelo ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cannot connect to local server problem
Did you reboor after install? -Original Message- From: Leandro Melo [mailto:[EMAIL PROTECTED] Sent: woensdag 15 december 2004 14:51 To: lista mysql Subject: Cannot connect to local server problem Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a laptop, which runs Windows 2000. When i installed MySQL 4.0.17 and tried to run the client from command line, i got the following error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I don't remember this problem when i first installed the db in windows XP (or maybe i just don't remeber solving it). What am i missing? How do i fix that? Thanks, ltcmelo ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect to local server problem
Have you verified that the MySQL server is currently running? Was this installed as service to automatically start up? Leandro Melo wrote: Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a laptop, which runs Windows 2000. When i installed MySQL 4.0.17 and tried to run the client from command line, i got the following error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I don't remember this problem when i first installed the db in windows XP (or maybe i just don't remeber solving it). What am i missing? How do i fix that? Thanks, ltcmelo ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot Connect to local MYSQL server through socket
../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738
Re: cannot Connect to local MYSQL server through socket
Is the MySQL server running and you can not connect? Or are you not able to start the MySQL server? Morris, Andrew wrote: ../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot Connect to local MYSQL server through socket
Hello, The mysql sock file is used for Unix Domain Sockets communication. In essence, it is used for interconnection between processes running on the same system. They function just like ordinary-over-the-net sockets. They are just faster for interprocess communication. I am not sure I understand what your problem is with the file, or what chmod/chown have to do with it. Please explain. MarkP On Wed, 24 Nov 2004 12:00:45 -0600, Victor Pendleton [EMAIL PROTECTED] wrote: Is the MySQL server running and you can not connect? Or are you not able to start the MySQL server? Morris, Andrew wrote: ../var/lib/mysql/mysql.sock. I've been round the houses with this following the thread but I can't get past this error despite all the chmod and chown modifications, installed MySQL admin and it still won't start. Am I best to chuck it in the bin or uninstall the lot and start again? This is Fedora Core 3 with MySQL 3.23.58-13. Any help gladly appreciated but its not obvious from the web site how to go beyond the chmod and chown fixes. What does the socks file do anyway? Thanks Andrew G Morris ILT Advisor (Technical) JISC RSC West Midlands 01902 824434 07980 982738 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Mark Papadakis Head of RD Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect via TCP (Lost connection to MySQL server during query)
Hi, I'm running into troubles trying to connect to MySQL (version 4.0.18) via TCP/IP. Connecting on the actual machine via Unix sockets works just fine--it's solid as a rock. But as soon as I attempt to connect via TCP (from either the local machine or a remote machine), mysqld crashes and I get the ERROR 2013: Lost connection to MySQL server during query error. This happens to me using both version 4.0.18 and 4.0.20 (I was running .20 and downgraded to .18 to see if that fixed the problem. It didn't, but I haven't upgraded back to .20 again yet.) So for instance, after starting mysqld, this works fine: $ mysql -h localhost But the following command does not: $ mysql -h 127.0.0.1 ERROR 2013: Lost connection to MySQL server during query Running mysqladmin version immediately after getting the error confirms that the server did crash and come back up. If I telnet to 127.0.0.1 port 3306, it just immediately closes the connection. (Connection closed by foreign host.) Again, this is due to the server crashing. I haven't been able to get any useful (to me, anyway) information out of mysqld.err. I get a backtrace, but the stack trace ends in New values of fp=0x81bdea4 failed sanity check, terminating stack trace! (which doesn't look normal to me). When I try to follow the instructions at http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html, nm tells me there are no symbols for mysqld. I'm not familiar with resolving stack traces, so treat me as a newbie in that regard. For that matter, it's entirely possible that I'm making a newbie mistake somewhere else. If that's the case, please point me to a FAQ and flame away. :) But I've read the docs and Googled this one pretty thoroughly, and although I've found people that seem to have the same problem, I haven't yet found the answer to that problem. Let me know if I can provide anything to make the problem more clear. Thanks for your help! Matt Winckler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect via TCP (Lost connection to MySQL server during query)
What hardware and OS? How did you get and install mysql? MySQL supplied binary? 3rd party binary? Built from source? If the answer is not MySQL supplied binary, my first suggestion would be to try that to see if the problem goes away. Michael Matt Winckler wrote: Hi, I'm running into troubles trying to connect to MySQL (version 4.0.18) via TCP/IP. Connecting on the actual machine via Unix sockets works just fine--it's solid as a rock. But as soon as I attempt to connect via TCP (from either the local machine or a remote machine), mysqld crashes and I get the ERROR 2013: Lost connection to MySQL server during query error. This happens to me using both version 4.0.18 and 4.0.20 (I was running .20 and downgraded to .18 to see if that fixed the problem. It didn't, but I haven't upgraded back to .20 again yet.) So for instance, after starting mysqld, this works fine: $ mysql -h localhost But the following command does not: $ mysql -h 127.0.0.1 ERROR 2013: Lost connection to MySQL server during query Running mysqladmin version immediately after getting the error confirms that the server did crash and come back up. If I telnet to 127.0.0.1 port 3306, it just immediately closes the connection. (Connection closed by foreign host.) Again, this is due to the server crashing. I haven't been able to get any useful (to me, anyway) information out of mysqld.err. I get a backtrace, but the stack trace ends in New values of fp=0x81bdea4 failed sanity check, terminating stack trace! (which doesn't look normal to me). When I try to follow the instructions at http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html, nm tells me there are no symbols for mysqld. I'm not familiar with resolving stack traces, so treat me as a newbie in that regard. For that matter, it's entirely possible that I'm making a newbie mistake somewhere else. If that's the case, please point me to a FAQ and flame away. :) But I've read the docs and Googled this one pretty thoroughly, and although I've found people that seem to have the same problem, I haven't yet found the answer to that problem. Let me know if I can provide anything to make the problem more clear. Thanks for your help! Matt Winckler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect via TCP (Lost connection to MySQL server during query)
Michael Stassen wrote: What hardware and OS? Pentium II 300, 192 MB RAM, almost-brand-new 80GB hard drive, running Gentoo Linux (kernel 2.4.25-gentoo). How did you get and install mysql? MySQL supplied binary? 3rd party binary? Built from source? If the answer is not MySQL supplied binary, my first suggestion would be to try that to see if the problem goes away. I installed it from an ebuild, via Gentoo's portage system, compiled from source. Thanks for the suggestion; I'll give the MySQL binaries a shot. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect via TCP (Lost connection to MySQL server during query)
Michael Stassen wrote: What hardware and OS? How did you get and install mysql? MySQL supplied binary? 3rd party binary? Built from source? If the answer is not MySQL supplied binary, my first suggestion would be to try that to see if the problem goes away. Michael That did end up being the problem...MySQL's binaries seem to work fine. Thanks again for your rapid insight! Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
On Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote: tcp0 0 *:3307 *:* LISTEN It seems that the correct socket is used. Here is the output: unix 2 [ ACC ] STREAM LISTENING 3303 private/relay unix 2 [ ACC ] STREAM LISTENING 3307 public/showq Looks like 3307 is indeed open, so you may want to modify your mysql_connect to use localhost:3307 - since that is likely to be the port mysqld is using based upon this output. The default is usually 3306, so if you do not include the :3307 port reference you may very well not be able to connect. Brad Eacker ([EMAIL PROTECTED]) I tried to connect to socket #3307 as follows: $link = mysql_connect(localhost:3307, root, passwd); but without any changes. Hmmm ... I did not expect this to be so hard. Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
n Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote: tcp0 0 *:3307 *:* LISTEN It seems that the correct socket is used. Here is the output: unix 2 [ ACC ] STREAM LISTENING 3303 private/relay unix 2 [ ACC ] STREAM LISTENING 3307 public/showq Looks like 3307 is indeed open, so you may want to modify your mysql_connect to use localhost:3307 - since that is likely to be the port mysqld is using based upon this output. The default is usually 3306, so if you do not include the :3307 port reference you may very well not be able to connect. Brad Eacker ([EMAIL PROTECTED]) I tried to connect to socket #3307 as follows: $link = mysql_connect(localhost:3307, root, passwd); but without any changes. Hmmm ... I did not expect this to be so hard. -- I've lost track of this thread so sorry if this is no longer valid... Have you read http://www.mysql.com/doc/en/Multiple_servers.html? Its not as simple as just specying a port, i don't think, you'll need to make sure mysql in using a different socket file on start up if you want to connect to an additional/different port. I set two up once..one on 3.x and one on 4.0x, and specifying the socket file/listen port was the magic combo for me.(2 years ago now, so my memory may not be serving me well) Does this already work on 3306 for you? Again, sorry if this is no longer valid or redundant. Jeff ___ Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
Sami Maisniemi [EMAIL PROTECTED] writes: It seems that the correct socket is used. Here is the output: unix 2 [ ACC ] STREAM LISTENING 3303 private/relay unix 2 [ ACC ] STREAM LISTENING 3307 public/showq ... I tried to connect to socket #3307 as follows: $link = mysql_connect(localhost:3307, root, passwd); Sami, Could you verify that you can connect with mysql via mysql -h localhost -P 3307 If we have identified the proper host/port you should receive the standard 'mysql ' prompt. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP script cannot connect MySQL server
I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /srv/www/htdocs/sqltest.php on line 4 Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link resource in /srv/www/htdocs/sqltest.php on line 5 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/sqltest.php on line 6 Any idea what might be wrong? There is no file 'mysql.sock' in '/var/lib/ mysql'. The PHP script is as follows: htmlbody ?php $link_id = mysql_connect(localhost, root); $result = mysql_list_dbs($link_id); $num_rows = mysql_num_rows($result); while ($db_data = mysql_fetch_row($result)) { echo $db_data[0]. BR; $result2 = mysql_list_tables($db_data[0]); $num_rows2 = mysql_num_rows($result2); while ($table_data = mysql_fetch_row($result2)) { echo -- . $table_data[0]. BR; } echo == $num_rows2 table(s) in . $db_data[0] . BR; } ? /body/html Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
/var/lib/mysql/mysql.sock is created when the mysql server starts. It disappears when mysql shuts down. Did you provide access to the databases as root? Is there a password associated with access? For instance, how do you statr mysql from the command line: mysql -u root -ppassword mydatabase rick People will forget what you said. People will forget what you did. But people will never forget how you made them feel. - Original Message - From: Sami Maisniemi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:25 PM Subject: PHP script cannot connect MySQL server I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /srv/www/htdocs/sqltest.php on line 4 Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link resource in /srv/www/htdocs/sqltest.php on line 5 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/sqltest.php on line 6 Any idea what might be wrong? There is no file 'mysql.sock' in '/var/lib/ mysql'. The PHP script is as follows: htmlbody ?php $link_id = mysql_connect(localhost, root); $result = mysql_list_dbs($link_id); $num_rows = mysql_num_rows($result); while ($db_data = mysql_fetch_row($result)) { echo $db_data[0]. BR; $result2 = mysql_list_tables($db_data[0]); $num_rows2 = mysql_num_rows($result2); while ($table_data = mysql_fetch_row($result2)) { echo -- . $table_data[0]. BR; } echo == $num_rows2 table(s) in . $db_data[0] . BR; } ? /body/html Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: _ This means that your server is not up, most likely. Can you connect from the command line? try running ps -efc | grep mys do you see an entry for mysqld? How did you start your server? HTH Jeff Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /srv/www/htdocs/sqltest.php on line 4 Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link resource in /srv/www/htdocs/sqltest.php on line 5 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/sqltest.php on line 6 Any idea what might be wrong? There is no file 'mysql.sock' in '/var/lib/ mysql'. The PHP script is as follows: htmlbody ?php $link_id = mysql_connect(localhost, root); $result = mysql_list_dbs($link_id); $num_rows = mysql_num_rows($result); while ($db_data = mysql_fetch_row($result)) { echo $db_data[0]. BR; $result2 = mysql_list_tables($db_data[0]); $num_rows2 = mysql_num_rows($result2); while ($table_data = mysql_fetch_row($result2)) { echo -- . $table_data[0]. BR; } echo == $num_rows2 table(s) in . $db_data[0] . BR; } ? /body/html Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script cannot access MySQL server, because the following error message is displayed: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /srv/www/htdocs/sqltest.php on line 4 This error could result from a number of possible problems. First off I would check to make sure the mysqld is running and attaching to the default socket (3306). If you have it set up otherwise, you will likely need the connect to contain the ':3307' socket adjustment to the name of the host being sought. I have validated that the rest of your logic is correct once the connection is established. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
On Monday 22 March 2004 20:36, [EMAIL PROTECTED] wrote: This means that your server is not up, most likely. Can you connect from the command line? try running ps -efc | grep mys do you see an entry for mysqld? It seems that the server is up and running, because I am able to see multiple processes referring to MySQL. How did you start your server? I have some scripts that start MySQL server automatically during login. Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
On Monday 22 March 2004 21:45, [EMAIL PROTECTED] wrote: This error could result from a number of possible problems. First off I would check to make sure the mysqld is running and attaching to the default socket (3306). If you have it set up otherwise, you will likely need the connect to contain the ':3307' socket adjustment to the name of the host being sought. I have validated that the rest of your logic is correct once the connection is established. It seems that mysqld is up and running (view the results below), but could you specify how to check the socket, please? Regards Sami dhcppc9:/home/smaisnie # ps -efc | grep mys root 1211 1 -21 19:45 ?00:00:00 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/dhcppc9.pid mysql 1240 1211 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1288 1240 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1289 1288 -20 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1290 1288 -23 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1291 1288 -23 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1292 1288 -20 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1294 1288 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1295 1288 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1296 1288 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking mysql 1297 1288 -24 19:45 ?00:00:00 /usr/local/mysql/bin/ mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/usr/ local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/ local/mysql/data/dhcppc9.pid --skip-locking root 2206 1829 -21 21:57 pts/100:00:00 grep mys -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
Did you provide access to the databases as root? Is there a password associated with access? For instance, how do you statr mysql from the command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create another user name for MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I view the user? I tried to create a root password and I added the password to the PHP script, but I did not see any impact. Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote: Did you provide access to the databases as root? Is there a password associated with access? For instance, how do you statr mysql from the command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create another user name for MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I view the user? I tried to create a root password and I added the password to the PHP script, but I did not see any impact. You may want to look at some tutorials at php.net and devshed.com first. They should get you started. B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
It seems that mysqld is up and running (view the results below), but could you specify how to check the socket, please? Based on your ps information, the socket will likely be in the /usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way to tell if there is a socket open for the server would be to use netstat -a | grep 330 Which would show a line similar to this: tcp0 0 *:3307 *:* LISTEN with the port I'm using {3307} showing up as currently in use, tcp protocol with a listener {LISTEN} connected to the socket. Hopefully the port specified in the my.cnf will show on the netstat output as described above. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
Sami Maisniemi writes: I think I am using root access, but should I create another user name for MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I view the user? from the mysql program: mysql use mysql mysql select User,Host,Password,Select_priv from user; which will show basic access capabilities for user/host/password mysql select Host,Db,User,Table_Name,Table_priv from tables_priv; will show similar information on a db/table basis for the host/user combinations. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
On Monday 22 March 2004 22:43, [EMAIL PROTECTED] wrote: specify how to check the socket, please? Based on your ps information, the socket will likely be in the /usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way to tell if there is a socket open for the server would be to use netstat -a | grep 330 Which would show a line similar to this: tcp0 0 *:3307 *:* LISTEN It seems that the correct socket is used. Here is the output: unix 2 [ ACC ] STREAM LISTENING 3303 private/relay unix 2 [ ACC ] STREAM LISTENING 3307 public/showq unix 3 [ ] STREAM CONNECTED 3330 unix 3 [ ] STREAM CONNECTED 3309 unix 3 [ ] STREAM CONNECTED 3306 unix 3 [ ] STREAM CONNECTED 3305 unix 3 [ ] STREAM CONNECTED 3302 unix 3 [ ] STREAM CONNECTED 3301 Regards Sami -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
tcp0 0 *:3307 *:* LISTEN It seems that the correct socket is used. Here is the output: unix 2 [ ACC ] STREAM LISTENING 3303 private/relay unix 2 [ ACC ] STREAM LISTENING 3307 public/showq Looks like 3307 is indeed open, so you may want to modify your mysql_connect to use localhost:3307 - since that is likely to be the port mysqld is using based upon this output. The default is usually 3306, so if you do not include the :3307 port reference you may very well not be able to connect. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP script cannot connect MySQL server
Sami Maisniemi [EMAIL PROTECTED] writes: mysql use mysql mysql select User,Host,Password,Select_priv from user; which will show basic access capabilities for user/host/password Hmmm ... did not work as you can see: mysql select User,Host,Password,Select_priv from user; ERROR 1054: Unknown column 'User' in 'field list' H, that's interesting. You'll probably need to take a look at the 'desc user;' output. Mine reports the following initial portion: mysql desc user - ; +---+---+--+-+- +---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+- +---+ | Host | varchar(60) binary| | PRI | | | | User | varchar(16) binary| | PRI | | | | Password | varchar(16) binary| | | | | | Select_priv | enum('N','Y') | | | N | | ... If yours does not report Host and User as the first two columns, your user table has been corrupted in some manner. You haven't tried to define your own user table have you? If so, that may be what is causing the errors. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect on the internet...Do I need to open a port on my router?
Hello all, This might not be a mysql problem, but I just need clarity. My Mysql is sitting on port 3306. I have a router that sits in front of my server. Do I need to open the port number on my router for my suystem to work well? Right now, the only port opened on my router is 80 for Apache. The following are pertinent information for my system Router -WAN IP 216.49.74.183 LAN IP 192.168.1.1 Server LAN IP 192.168.1.22 Sever DNS entry 192.168.1.22 - Microsoft recommended Windows 2000 Advanced Server with Active Directory and Local DNS Apache 2.0.47 PHP 4.3.2 Mysql 4.0.13 Geeklog 1.3.8 Gallery 1.4 Is there any entry in mysql configuration that I need to edit to move from my localhost to my website on the internet. I can only see my site locally on the webserver but not on the internet. Since my initial installation was done before I had access to the internet via DSL, do I need to edit anything now that I have the DSL installed? Am I supposed to share any of my directories to make my site work? Please I am desperate.. Ola -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot connect on the internet...Do I need to open a port on my router?
If remote clients will connect directly to your MySQL server then you will need to open port 3306. If you are only going to access MySQL via server side scripts (PHP) then you will not need to open this port as the scripts will connect to the localhost. If you cannot see your web site then it sounds like a configuration problem with Apache. You might check your Apache config file. You might also check your firewall and router settings to make certain that port 80 is open. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot Connect to Server
Hi All, Having problems with connecting to mysql server as we have had to change all the IP addresses on the server. I am assuming that localhost is the problem, how can I manually change localhost to be an IP address? The error message is: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3 Unable to select database TIA Phil. Phil Ewington - Technical Director -- 43 Plc 35 Broad Street, Wokingham Berkshire RG40 1AU T: +44 (0)118 978 9500 F: +44 (0)118 978 4994 E: mailto:[EMAIL PROTECTED] W: http://www.43plc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot Connect to Server
On Mon, 1 Sep 2003 11:34:31 +0100 Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote: The error message is: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3 Unable to select database is MySQL socket really placed in /var/tmp? if not, than you need to specify path to it in mysql.default_socket directive in php.ini or your MySQL server isn't running on localhost at all? --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cannot Connect to Server
Could not read response from last sender :o( -Original Message- From: Phil Ewington - 43 Plc [mailto:[EMAIL PROTECTED] Sent: 01 September 2003 11:35 To: Mysql Subject: Cannot Connect to Server Hi All, Having problems with connecting to mysql server as we have had to change all the IP addresses on the server. I am assuming that localhost is the problem, how can I manually change localhost to be an IP address? The error message is: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3 Unable to select database TIA Phil. Phil Ewington - Technical Director -- 43 Plc 35 Broad Street, Wokingham Berkshire RG40 1AU T: +44 (0)118 978 9500 F: +44 (0)118 978 4994 E: mailto:[EMAIL PROTECTED] W: http://www.43plc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot Connect to Server
On Mon, 1 Sep 2003 11:51:07 +0100 Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote: Could not read response from last sender :o( from [EMAIL PROTECTED] ? it's Yet Another Spammer(or Autoresponder) on this list. YAS(A) =) dunno why list administration haven't blocked him yet. These robots are autoresponding on each message to the list with senseless messages: [EMAIL PROTECTED] [EMAIL PROTECTED] --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot Connect to Server
Make sure %WINDOWS%\my.ini has the entry bind-address=127.0.0.1 -Martin - Original Message - From: Antony Dovgal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 3:42 AM Subject: Re: Cannot Connect to Server On Mon, 1 Sep 2003 11:34:31 +0100 Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote: The error message is: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (111) in /home/sites/.. on line 3 Unable to select database is MySQL socket really placed in /var/tmp? if not, than you need to specify path to it in mysql.default_socket directive in php.ini or your MySQL server isn't running on localhost at all? --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help: cannot connect on localhost (10061)
At 15:15 -0500 7/18/03, Kyle Goetz wrote: hey, i'm new to mySQL...this meaning that i have tried ~1 times to install it and get it working over the past few weeks...and it always gives me the same error (scroll further down to see it) despite following the manual's windows installation exactly i have version 4.0.13 for windows and i used the installer once i was done, i followed the instructions in the manual exactly i have no firewall running i am on windows XP i am running the client and server on the same computer i ran winmysqladmin and it starts up fine the 'mysqld-nt' service is in my processes tab of task manager i go to dos prompt and type net start and mysql is there running fine You're sure? Look in C:\mysql\data for the .err file and take a look at it. Does it indicate any problems starting the server? The error you show below is typical for a situation in which the MySQL server is not actually running. however, when in c:\mysql\bin and i run 'mySQL' i get this error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) i have tried devshed, mysql help, etc. and cannot figure out why mine doesn't work...it seems most people just reboot and it voile! works... but i've rebooted over and over and over, and nothing changes...same error... when i use mySQL Control Center v0.9.2-beta i get the same error when i click Action-Connect all i can say is ARGH! all i can ask is does anyone have any idea why this happens? or how to stop it? i can telnet to port 3306, and get this readout (i have no idea how really to use telnet...) c:\telnet localhost 3306 * 4.0.13-nt?;[EMAIL PROTECTED],? ??ܶBad handshake Connection to host lost. (this when i press backspace, so i understand you don't do that in telnet...) i guess it is getting to mySQL, cuz the 4.0.13 at the beginning is my version of mySQL i'll paste my my.ini (which is in c:\windows) thanks so much, \Kyle, who has been frustrated for a while now... --beginning of my.ini #This File was made using the WinMySQLAdmin 1.4 Tool #7/18/2003 3:06:59 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=sakurak password=sfzero2 --end of my.ini -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to mysql server
I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED]
Re: cannot connect to mysql server
At 12:00 -0500 4/5/03, Peter Gumbrell wrote: I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' mysqld isn't running. You can check to see if it is running with (run this in a terminal window): cd /usr/local/mysql ./bin/mysqlamdin ping to start mysqld use: shell bin/safe_mysqld --user=mysql or shell bin/mysqld_safe --user=mysql if you are running MySQL 4.x --user=msyql should be the user that you set up to own the msql directories. I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to mysql server
Try the following cd /usr/local/mysql ./bin/mysqld_safe and see if that starts up the server. If it doesn't, check to make sure you don't have a proxy set in your internet configurations. Todd On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote: I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect to mysql server
Hello, I have an interesting problem. I installed mysql client and server from Redhat 7.3 RPM. Then I set up a username and password for a user monty (to use example from the manual). Then I grant priveleges for the user with: mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; and restarted mysql server. Let's assume the server name is sql.domain.edu I then tried to connect to the server as user monty from localhost: $ mysql -u monty -p and then tried it from another machine console: $ mysql -u monty -h sql.domain.edu -p and all is well. But when i tried to connect using the console from localhost (ie. sql.domain.edu) by specifiying hostname: $ mysql -u monty -h sql.domain.edu -p I got the cannot connect user [EMAIL PROTECTED] error message. Why does this happen? I fixed this by doing mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; but I thought I already specified the wildcard on my previous grant previlege so that monty can access from *any* machine. Just curious as t why this happens, can anyone help? Thanks a lot. Reuben D. Budiardja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to MySQL
I'm having a problem connecting to MySQL database using phpMyAdmin from a remote location. I've had a look at the manual but I'm not too clear on what has to be done. I see that the connection is through a socket. Can I change this to connect using an ip connection? Reason I ask is because the MySQL server actually sits behind a firewall (iptables Forward rule) and I have the port 3306 opened and forwarding packets (at least I think I do) to the SQL server. The following error is what I get: --Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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: cannot connect to MySQL
Please read the warning. It attempting a LOCAL connection. Please enter the host ( server) you wish to connect to. Jon Miller wrote: I'm having a problem connecting to MySQL database using phpMyAdmin from a remote location. I've had a look at the manual but I'm not too clear on what has to be done. I see that the connection is through a socket. Can I change this to connect using an ip connection? Reason I ask is because the MySQL server actually sits behind a firewall (iptables Forward rule) and I have the port 3306 opened and forwarding packets (at least I think I do) to the SQL server. The following error is what I get: --Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - 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[2]: Cannot Connect
RBE, 4) How exactly are you tring to connect (mysql -hlocalhost -uuser -psecret)? One of the problems is that I was not only not able to enter a password, but cannot seem to get one entered. I get error 2002 with that or almost any other entry. So far, following the suggestions given me in the manual doesn't seem to fix anything. Sorry, but this doesn't answer my question. You said you used MySQL Monitor (the command line tool) when trying to connect to the server. When you started MySQL Monitor, how did you do that? Did you just double-click mysql (the MySQL Monitor) in some graphical file manager tool, or did you cd to the directory where mysql is sitting, and then type mysql? To make this more clear. Under Windows, I do the following on the command line: C:\ cd mysql\bin C:\mysql\bin mysql -usuperuser -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.10-gamma-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Now I'm connected to the server, and I can issue SQL statements. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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[4]: Cannot Connect
RBE, Sorry, but this doesn't answer my question. You said you used MySQL Monitor (the command line tool) when trying to connect to the server. When you started MySQL Monitor, how did you do that? Did you just double-click mysql (the MySQL Monitor) in some graphical file manager tool, or did you cd to the directory where mysql is sitting, and then type mysql? I put a desktop icon link to the directory where mysqlcc was located and it asks for a connection. When I click on the connection, I am asked for a user and password, but no password or user combination works. I've also done the command line option mysql -urbe -ppassword but the connection is refused with error 2002. Error 2002, strange. When the MySQL server is down, you should get error 2003, but maybe that's different with MySQLCC. To track down the problem, try as follows: 1) Make sure the MySQL server is running. Do something like ps xa | grep mysqld. If it's not running, try to start it like this: mysqld. This should report errors on startup, telling you where the problem lies. 2) If the problem reported says something about host.frm missing, you forgot the post-installation duties, i.e. to set up the grant tables. Here's how you do that: http://www.mysql.com/doc/en/Post-installation.html 3) If it's running, you have a privilege problem. If your MySQL installation is new, you'll have just some basic users set up. One of them is called root, who can connect from localhost without password. Thus, try this: mysql -uroot. Hope this helps. BTW, please keep the discussion on the list! Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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: Re[4]: Cannot Connect
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 15 February 2003 3:03 pm, Stefan Hinz wrote: RBE, Sorry, but this doesn't answer my question. You said you used MySQL Monitor (the command line tool) when trying to connect to the server. When you started MySQL Monitor, how did you do that? Did you just double-click mysql (the MySQL Monitor) in some graphical file manager tool, or did you cd to the directory where mysql is sitting, and then type mysql? I put a desktop icon link to the directory where mysqlcc was located and it asks for a connection. When I click on the connection, I am asked for a user and password, but no password or user combination works. I've also done the command line option mysql -urbe -ppassword but the connection is refused with error 2002. Error 2002, strange. When the MySQL server is down, you should get error 2003, but maybe that's different with MySQLCC. To track down the problem, try as follows: 1) Make sure the MySQL server is running. Do something like ps xa | grep mysqld. If it's not running, try to start it like this: mysqld. This should report errors on startup, telling you where the problem lies. mysqld is running. 2) If the problem reported says something about host.frm missing, you forgot the post-installation duties, i.e. to set up the grant tables. Here's how you do that: http://www.mysql.com/doc/en/Post-installation.html No reported problem. 3) If it's running, you have a privilege problem. If your MySQL installation is new, you'll have just some basic users set up. One of them is called root, who can connect from localhost without password. Thus, try this: mysql -uroot. mysql -uroot gives me the following error message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) - -- Robert Black Eagle (DS) Get my key from http://www.keyserver.net/en Trying to copyright bits is like trying to make water dry. But politicians try, anyway. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+TrmatjSYKkYJrmcRAoyfAJ0dViac9pCbzXgrN2JW0ooumSSkoACbB5ky Znw467FvLJwxGMxfeWob1Fw= =slla -END PGP SIGNATURE- - 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[6]: Cannot Connect
Robert, 3) If it's running, you have a privilege problem. If your MySQL installation is new, you'll have just some basic users set up. One of them is called root, who can connect from localhost without password. Thus, try this: mysql -uroot. mysql -uroot gives me the following error message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Okay, my guess was wrong. It's not a privilege problem, it's a socket problem. You can specify the socket through which to connect when under Unix and connecting via localhost in a number of ways: a) In one of the my.cnf files, b) as a server start option on the command line, c) in a script that starts the server with an appropriate option. For a), you could look into /etc/my.cnf; maybe there's something wrong. You could also check ~/.my.cnf. Look for socket entries both in the [mysqld] and [client] sections. b) It's pretty unlikely that you start the server with a wrong socket option manually. c) There's a good chance that a start script will start the server with an option that's not apt to your system setup. Look for the script mysqld_safe and check for socket. d) Maybe mysqld can't create a socket in /var/lib/mysql/. Check the file permissions for this directory. If everything fails and you can't find a solution for your problem, you can connect via TCP/IP. In this case, specify the host and DON'T use localhost as host name, but rather the name of your machine. Suppose it's called 'machine', you would connect like this: mysql -hmachine -uroot (Frankly said, I'm not a Unix user, so others might be a better help if this can't solve your problems.) Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - 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
Cannot Connect
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. I installed the binary for glibc 2.2 (using 2.2.5), but cannot get anything to connect. The website documentation indicates a procedure that requires certain sub-directories, none of which exist in this implementation. Could someone give me at least a hint as to how I can set this up so I can use it? - -- Robert Black Eagle (DS) Get my key from http://www.keyserver.net/en Trying to copyright bits is like trying to make water dry. But politicians try, anyway. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+TS78tjSYKkYJrmcRAiyFAKCMzo4PZCsVCL4VXgkPwgaf4QLpXwCgkgb2 QJ15fho4kWWvngoUei4VIGw= =5Q6h -END PGP SIGNATURE- - 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: Cannot Connect
On Fri, Feb 14, 2003 at 12:01:32PM -0600, RBE wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. I installed the binary for glibc 2.2 (using 2.2.5), but cannot get anything to connect. The website documentation indicates a procedure that requires certain sub-directories, none of which exist in this implementation. Could someone give me at least a hint as to how I can set this up so I can use it? Check if you are actually running the daemon :) It should be listening either or both of UNIX socket and TCP port. eg. netstat -l -p and look to the daemon. - Adam - 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: Cannot Connect
RBE, I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. It bit more information could help to track down the problem: 1) Which MySQL version do you use? 2) Which OS? 3) Do you connect via localhost, i.e. are your clients running on the same machine as your MySQL server? 4) How exactly are you tring to connect (mysql -hlocalhost -uuser -psecret)? Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - 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
Cannot connect to remote server
No respond from remote server. Tried using mysqladmin -h hostname version. There was no response just hanged there. Even tried telnet hostname 3306. Same problem. However the remote server is working cos i tried to access it from another computer. I have also tried to install mysql 4.0.8 gamma and connect to localhost, it work. and tried to connect to another machine running mysql 3.0. Both worked except with the remote server. Both system are running on W2K and so is the server. Any ideas? Thanxs a lot in advance. P.S tried sniffing the packets, there was a send packet to the server, one reply from the server and one packet send again to the server. Then there was no more packet being sent around. In summary client - server server - client client - server dead silence -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - 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: Cannot connect from WInXp MYSQL server - help - cont.
I ahve upgraded to gcc v 3.2.7:- Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) I have also added the line:= set-variable = thread_stack=256K// Thats a uppercase 'K' in my my.cnf file Same bloady error. Ideas? Scott - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Scott Lewis [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 10:48 PM Subject: Re: Cannot connect from WInXp MYSQL server - help Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp MYSQL server - help OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - 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: Cannot connect from WInXp MYSQL server - help
I've been having the same problem with WinXP to MySQL running under a totally up2date-ed Red Hat 8 installation. What I did was to modify my /etc/my.cnf to look like: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock set-variable=max_allowed_packet=10M set-variable=thread_stack=1M [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] port=3306 socket=/raid/mysql/mysql.sock That, according to a Bugzilla note at Red Hat (which, IIRC, mentions the problem being with glibc) should fix the problem. And it did - sort of. The MySQLGUI.exe Windows client could connect from WinXP, but Access databases through MyODBC would not. After taking a close look at the c:\my.cnf file: [mysqld] datadir=/raid/mysql socket=/raid/mysql/mysql.sock [mysql.server] user=mysql basedir=/raid [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid seems correct to me. There was one thing missing: When configuring the MyODBC driver, I had to check the option Read options from C:\my.cnf for this to work. The **really** strange thing is that I have a different database on the same RedHat 8 server, and I **didn't** have to select that option for it to connect... Cheers, Mike -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 7:18 PM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Cannot connect from WInXp MYSQL server - help Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp MYSQL server - help OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - 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
Cannot connect from WInXp MYSQL server - help
OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - 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: Cannot connect from WInXp MYSQL server - help
Scott, most probably, you've got a glibc problem on your Red Hat box. Try upgrading to a newer version of glibc, and if the problem (mysqld dies when trying to connect from anywhere else than localhost) has gone, I was right :) (There was a very similar question a couple of days ago on this list. I don't know if the Red Hat problem is exactly the same as the SuSE problem I could solve by updating glibc, but the symptom is the same.) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Scott Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:51 PM Subject: Cannot connect from WInXp MYSQL server - help OK, I have a mysql server running on my home server. The main os is Redhat8. I know that Mysql is running on port 3306 as its showing as listening. I ahve opened the tcp port for boh internal and external connections - fione. I ahve also disbaled it to test aswell. Anyway - I have loaded several MYsql clients on my winxp pro pc on my home LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and connection I get the error:- Lost connection to mysql durring query. In the loags it says:- Number of processes running now: 1 mysqld process hanging, pid 2522 - killed 030125 17:49:36 mysqld restarted /usr/libexec/mysqld: ready for connections So - its killing the pid, which I assume is my connections. Any ideas on what to look for. Scott www.toptravelsites.net www.myeyes-youreyes.co.uk - 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: Cannot connect after upgrading to mysql-4.0.8
On Saturday 11 January 2003 04:35, Claus Olesen wrote: Description: The problem described on http://bugzilla.redhat.com/bugzilla/long_list.cgi?buglist=75128 with solution described on http://rhn.redhat.com/errata/RHSA-2002-197.html comes back after upgrading to mysql-4.0.8 from 3.23.54a. How-To-Repeat: Install the mysql-4.0.8 rpm posted by www.mysql.com using either rpm -U or rpm -e followed by rpm -i on stock Redhat 7.3 with all updates from Redhat using Redhat's up2date service. After that, connect attempts to the mysql server on Linux from a mysql client such as mysql or mysqlcc on W2000 all fail no matter how user accounting (host,user,privileges) is setup on either box. Fix: The above solution appears to work i.e. add the involved hosts in /etc/hosts and \WINNT\system32\drivers\etc\hosts. This is already fixed in 4.0.9: http://www.mysql.com/doc/en/News-4.0.9.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
Cannot connect after upgrading to mysql-4.0.8
Description: The problem described on http://bugzilla.redhat.com/bugzilla/long_list.cgi?buglist=75128 with solution described on http://rhn.redhat.com/errata/RHSA-2002-197.html comes back after upgrading to mysql-4.0.8 from 3.23.54a. How-To-Repeat: Install the mysql-4.0.8 rpm posted by www.mysql.com using either rpm -U or rpm -e followed by rpm -i on stock Redhat 7.3 with all updates from Redhat using Redhat's up2date service. After that, connect attempts to the mysql server on Linux from a mysql client such as mysql or mysqlcc on W2000 all fail no matter how user accounting (host,user,privileges) is setup on either box. Fix: The above solution appears to work i.e. add the involved hosts in /etc/hosts and \WINNT\system32\drivers\etc\hosts. Submitter-Id: ? Originator:Claus Olesen Organization: Transdyn Controls, Inc. MySQL support: none Synopsis: Cannot connect after upgrading to mysql-4.0.8 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.8-gamma (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: Stock Redhat 7.3 fully up-to-date using Redhat's up2date service. System: Linux saturn 2.4.18-19.7.x #1 Thu Dec 12 07:56:46 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-113) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 7 10:36 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Oct 10 08:16 /lib/libc-2.2.5.so -rw-r--r--1 root root 2312442 Oct 10 07:51 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 10 07:46 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' - 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: beginner's question - cannot connect with database
Sistertech, Wednesday, October 23, 2002, 4:11:31 AM, you wrote: S I'm trying to host a discussion forum for my philosophy class...to make a long story short: S I've now got phpBB2 and MySQL on my virtual domain. S My host doesn't offer any MySQL support. I'm installing phpBB and S I receive an error critical error: cannot connect with database. S All the fields appear to be correct (DB name, server, passwords, phpBB__, etc.) S I've search archives and can't find anything that specifically addresses my issue S AND one that compensates for the fact that I've **never used MySQL or done S any programming**. S I've given full permissions to everything (the folder where phpBb is located, cgi-bin, config.php). S It appears that the database is working (status is OK) although I don't know how to run a test query S (or if such a thing is possible without *any* data or tables in the DB. S Question: I need internet access to a beginner's guide that can help me. S The MySQL FAQ and Manual assume far too much background in programming to be of much help. S An e-book or online tutorial (for pay is fine) is better now than a book, although I'll get one, too. There are some articles at: http://www.mysql.com/articles/index.html Hope that helps. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
beginner's question - cannot connect with database
Greetings all, I'm trying to host a discussion forum for my philosophy class...to make a long story short: I've now got phpBB2 and MySQL on my virtual domain. My host doesn't offer any MySQL support. I'm installing phpBB and I receive an error critical error: cannot connect with database. All the fields appear to be correct (DB name, server, passwords, phpBB__, etc.) I've search archives and can't find anything that specifically addresses my issue AND one that compensates for the fact that I've **never used MySQL or done any programming**. I've given full permissions to everything (the folder where phpBb is located, cgi-bin, config.php). It appears that the database is working (status is OK) although I don't know how to run a test query (or if such a thing is possible without *any* data or tables in the DB. Question: I need internet access to a beginner's guide that can help me. The MySQL FAQ and Manual assume far too much background in programming to be of much help. An e-book or online tutorial (for pay is fine) is better now than a book, although I'll get one, too. Thanks! Prof. Pamela Hood San Francisco State University [EMAIL PROTECTED] or [EMAIL PROTECTED] - 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
cannot connect to local mysql server through socket
Hi, I am trying to set up a mail server using Postfix, Web-cyradm and mysql on SusE 8. I have followed all the steps in Luc de Louw's documentation so far and MySQL server is running. When I try to use the scripts that came with Web-Cyradm to create the databases and tables I get the folowing error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have checked that mysqld is running and I have moved the mysql.sock file from /tmp to /var/lib/mysql, checked ownership and permissions but still no luck. As you can probably tell, I am no database guy so please excuse if it is a real daft question. Thanks - 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: cannot connect to local mysql server through socket
Lawrence, Monday, September 30, 2002, 2:47:44 PM, you wrote: LS I am trying to set up a mail server using Postfix, Web-cyradm and mysql LS on SusE 8. I have followed all the steps in Luc de Louw's documentation LS so far and MySQL server is running. When I try to use the scripts that LS came with Web-Cyradm to create the databases and tables I get the LS folowing error: LS ERROR 2002: Can't connect to local MySQL server through socket LS '/var/lib/mysql/mysql.sock' (2) LS I have checked that mysqld is running and I have moved the mysql.sock LS file from /tmp to /var/lib/mysql, checked ownership and permissions but LS still no luck. LS As you can probably tell, I am no database guy so please excuse if it is LS a real daft question. You shouldn't move mysql.sock file. You can just set up path to the socket file in the my.cnf or with --socket option of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
Re: Replication Failure (or Bug?): Cannot Connect, but Should?
Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - 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: Replication Failure (or Bug?): Cannot Connect, but Should?
Leonard, This is pretty clearly (IMHO) a permissions issue. Make sure the username you use to replicate with, has a '%' in the Host field of the user table. mysql use mysql mysql select * from user where user = 'your_replication_user' \G *** 1. row *** Host: % User: your_replication_user Password: encrypted_password Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: Y Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.01 sec) Scott Helms Director of Technology, ZCorum - Original Message - From: Leonard Megliola [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 12:16 PM Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - 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: Replication Failure (or Bug?): Cannot Connect, but Should?
Hrm, I'll take a stab at it, since I've got replication working atm... Have you tried basic connectivity tests between the slave and master? ( Just making sure.. ie - can you telnet to port 3306 on the master, from the slave? ) Did you flush the privileges after adding the repl user? Here's my master my.cnf - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 And slave my.cnf - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 2 master-host=db.mine.com master-user=bkup master-password=password master-port=3306 Can you copy and paste your whole my.cnf from the slave? It doesn't sound like it's reading it correctly ( maybe why it's keeping the timeout at 0 and trying to connect to the wrong ip? ) -- sh On Wed, 2002-03-27 at 09:16, Leonard Megliola wrote: Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - 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: Replication Failure (or Bug?): Cannot Connect, but Should?
Thanks Steven, I can telnet to port 3306 of the master system just fine. A (likely unimportant and useless) test I did was to telnet to 3306 on the master and then run netstat -an on the master to see if the connect was made. Yes it was... tcp0 0 10.0.0.10:3306 10.0.0.9:3017 ESTABLISHED What are the chances that MySQL doesn't work so well with 10.0.0.0 network addresses? I did flush privileges after adding the user. It didn't help. I had the same feeling about the configuration file being incorrect because of the IP address and timeout not being set correctly. I have compared yours and mine and don't see any significant differences except that I am using a numerical IP address for my master-host. Here is my slave my.cnf: [mysqld] datadir=/home/mysql socket=/var/lib/mysql/mysql.sock server-id=2 master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 [mysql.server] user=mysql basedir=/home/mysql [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks for any more help you can give, Leonard At 09:39 AM 3/27/2002 -0800, Steven Hajducko wrote: Hrm, I'll take a stab at it, since I've got replication working atm... Have you tried basic connectivity tests between the slave and master? ( Just making sure.. ie - can you telnet to port 3306 on the master, from the slave? ) Did you flush the privileges after adding the repl user? Here's my master my.cnf - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 And slave my.cnf - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 2 master-host=db.mine.com master-user=bkup master-password=password master-port=3306 Can you copy and paste your whole my.cnf from the slave? It doesn't sound like it's reading it correctly ( maybe why it's keeping the timeout at 0 and trying to connect to the wrong ip? ) -- sh On Wed, 2002-03-27 at 09:16, Leonard Megliola wrote: Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
Re: Replication Failure (or Bug?): Cannot Connect, but Should?
Thanks Scott. It looks like permissions could be the issue, but checking out the table shows that I have all of the correct permissions setup exactly as you have listed them below. If you have any other ideas, I'd appreciate them. Thanks, Leonard At 12:49 PM 3/27/2002 -0500, you wrote: Leonard, This is pretty clearly (IMHO) a permissions issue. Make sure the username you use to replicate with, has a '%' in the Host field of the user table. mysql use mysql mysql select * from user where user = 'your_replication_user' \G *** 1. row *** Host: % User: your_replication_user Password: encrypted_password Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: Y Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.01 sec) Scott Helms Director of Technology, ZCorum - Original Message - From: Leonard Megliola [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 12:16 PM Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - 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 - 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
Re: Replication Failure (or Bug?): Cannot Connect, but Should?
Leonard, What command are you using to start the slave server? I was thinking maybe it wasn't reading the correct configuration file? This one is pretty strange. Have you thought about upgrading the slave mysql version, just to disregard that it might be a problem between the two versions? One thing, in your user table, are you using the hostname of the slave server to specify where it's coming from? ( I know you said you did % already, so this shouldn't matter.. but.. who knows? ). Here's what my replication user looks like - | %| bkup | password | N | N | N | N | N | N | N | N | N| Y | N | N | N | N | What do you currently have in the mysql 'user' table for the repl user? -- sh On Wed, 2002-03-27 at 17:18, Leonard Megliola wrote: Thanks Scott. It looks like permissions could be the issue, but checking out the table shows that I have all of the correct permissions setup exactly as you have listed them below. If you have any other ideas, I'd appreciate them. Thanks, Leonard At 12:49 PM 3/27/2002 -0500, you wrote: Leonard, This is pretty clearly (IMHO) a permissions issue. Make sure the username you use to replicate with, has a '%' in the Host field of the user table. mysql use mysql mysql select * from user where user = 'your_replication_user' \G *** 1. row *** Host: % User: your_replication_user Password: encrypted_password Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: Y Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.01 sec) Scott Helms Director of Technology, ZCorum - Original Message - From: Leonard Megliola [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 12:16 PM Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0' when I have clearly entered the IP address, and that it says retrying in 0 seconds when I made the timeout 10 seconds. The MySQL version on the master server is 3.23.35 and the slave version is at 3.23.32. Any help would be greatly appreciated. Thanks, Leonard P.S. sql query - 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: Replication Failure (or Bug?): Cannot Connect, but Should?
Honestly, I don't know what was wrong, but I have managed to get this problem fixed. It was one of two things... I upgraded the MySQL slave server to 3.23.49a. I also deleted the master.info file based on something I read in the release info for all of the releases in between the release that I was running and the one that I just installed. Deleting the master.info file must have done the trick because I fired up the slave server and everything is now running beautifully. Next question: do you have to manually delete the bin files on the master server and how do you know when you can do that? Thanks, Leonard At 05:30 PM 3/27/2002 -0800, Steven Hajducko wrote: Leonard, What command are you using to start the slave server? I was thinking maybe it wasn't reading the correct configuration file? This one is pretty strange. Have you thought about upgrading the slave mysql version, just to disregard that it might be a problem between the two versions? One thing, in your user table, are you using the hostname of the slave server to specify where it's coming from? ( I know you said you did % already, so this shouldn't matter.. but.. who knows? ). Here's what my replication user looks like - | %| bkup | password | N | N | N | N | N | N | N | N | N| Y | N | N | N | N | What do you currently have in the mysql 'user' table for the repl user? -- sh On Wed, 2002-03-27 at 17:18, Leonard Megliola wrote: Thanks Scott. It looks like permissions could be the issue, but checking out the table shows that I have all of the correct permissions setup exactly as you have listed them below. If you have any other ideas, I'd appreciate them. Thanks, Leonard At 12:49 PM 3/27/2002 -0500, you wrote: Leonard, This is pretty clearly (IMHO) a permissions issue. Make sure the username you use to replicate with, has a '%' in the Host field of the user table. mysql use mysql mysql select * from user where user = 'your_replication_user' \G *** 1. row *** Host: % User: your_replication_user Password: encrypted_password Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: Y Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.01 sec) Scott Helms Director of Technology, ZCorum - Original Message - From: Leonard Megliola [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 12:16 PM Subject: Re: Replication Failure (or Bug?): Cannot Connect, but Should? Sorry to bring this up again, but I haven't received any helpful responses. Does anyone have any clues about this or is this something I should report as a bug? I can't imagine it is. Thank you, Leonard At 12:43 AM 3/26/2002 -0800, you wrote: Hello, I have been attempting to get replication working for a week now and am having little luck. I have followed the instructions in the documentation but get the following errors in the error log on the slave server: 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not allowed to connect to this MySQL server(0), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 020325 0:32:24 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec Here are the relevant lines from my configuration files Master my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock log-bin server-id=1 Slave my.cnf: [mysqld] socket=/var/lib/mysql/mysql.sock master-host=10.0.0.10 master-user=repl master-password=password master-connect-retry=10 master-port=3306 server-id=2 I created the repl account on the master and have tried giving it FILE privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the slave server. The thing that stands out most for me about the error messages is that it says Can't connect to MySQL server on '0