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]
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 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
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
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: 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]
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]
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
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
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
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
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
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.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: 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: 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
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: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]
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 3.23.46 - Redhat 6.2 - cannot connect to server
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2 for a while and all has been well. I've also installed mysql several times with no issues. We had a hard drive go out today, and since then we have not been able to get mysql to successfully start and accept connections. Typing an simple "mysqladmin version" gives no error message whatsoever. When trying to reinstall and use the latest version, running 'make test' hangs at "Installing Master Databases". Though the server does start up, we can't interact with it in any way. If anyone can be of use, please advise. Thanks, -Bart - 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