Re: Problem connecting to MySQL server
Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Schalk Neethling <[EMAIL PROTECTED]> wrote: > Hey there > > I have upgraded the MySQL server on my Windows machine to 4.0.22 > following the docs at: > http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html > > When I start the server using NET START MySQL the server starts with no > problems and the following is written to my error log: > > 041108 14:24:28 InnoDB: Started > MySQL: ready for connections. > Version: '4.0.22-debug' socket: '' port: 3306 Source distribution > > When I stop the server using NET STOP MySQL the server stops without any > problems and the following is written to the log: > > 041108 14:25:43 MySQL: Normal shutdown > > 041108 14:25:43 InnoDB: Starting shutdown... > 041108 14:25:46 InnoDB: Shutdown completed > 041108 14:25:46 MySQL: Shutdown Complete > > Now, here is the problem. When I have started the MySQL server and it is > running I then go to c:\mysql\bin\ and execute the command: mysql > > The following message is then returned: > ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) > > Any ideas why this is happening? Any help on pointers to where I may > find more answers will be appreciated. Thanks! > -- 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]
Problem connecting to MySQL server
Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24:28 InnoDB: Started MySQL: ready for connections. Version: '4.0.22-debug' socket: '' port: 3306 Source distribution When I stop the server using NET STOP MySQL the server stops without any problems and the following is written to the log: 041108 14:25:43 MySQL: Normal shutdown 041108 14:25:43 InnoDB: Starting shutdown... 041108 14:25:46 InnoDB: Shutdown completed 041108 14:25:46 MySQL: Shutdown Complete Now, here is the problem. When I have started the MySQL server and it is running I then go to c:\mysql\bin\ and execute the command: mysql The following message is then returned: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem Connecting To Mysql Server
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## I get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . When i do a netstat -atn in my mysql server, i get : tcp 0 48 xxx.local.ip.xxx :3306 yyy.outsideserver.xxx:2886 FIN_WAIT1 A telnet to my server through the port 3306 goes well i'm under linux 8 and mysql 4.0.13 Does anybody knows how i can fix this ? Thanx a Lot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem Connecting To mysql server
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## i get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . when i do a netstat -atn in my mysql server, i get : tcp0 48 xxx.local.ip.xxx :3306 yyy.outsideserver.xxx:2886 FIN_WAIT1 a telnet to my server through the port 3306 goes well i'm under linux 8 and mysql 4.0.13 Does anybody knows how i can fix this ? ThanX LoT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connecting to mysql server from other machines
See this thread : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 - Original Message - From: "Michael Gargiullo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 9:26 AM Subject: connecting to mysql server from other machines > I have a huge problem. I have several remote machines that connect to a > mysql server. On Friday, the mysql server started returning ERROR 2013: > Lost connection to MySQL server during query > > Any idea. > > > Michael Gargiullo > Network Administrator > Warp Drive Networks > 590 Valley Health Plaza > Paramus NJ 07650 > > 1-201-576-9292 x260 > 1-201-225-0007 - F > > www.warpdrive.net > > > - > 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
connecting to mysql server from other machines
I have a huge problem. I have several remote machines that connect to a mysql server. On Friday, the mysql server started returning ERROR 2013: Lost connection to MySQL server during query Any idea. Michael Gargiullo Network Administrator Warp Drive Networks 590 Valley Health Plaza Paramus NJ 07650 1-201-576-9292 x260 1-201-225-0007 - F www.warpdrive.net - 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: Connecting to mysql Server
Thanx all, I am new to this and still learning, when I installed Linux, I did not have to do anything to PHP however I did just get the mysql rpm and install without any special configuration, Does anyone have an idea of any article that will help me recompile my php with my apache. Thanx - Original Message - From: "Jeremy 'Circ' Charles" <[EMAIL PROTECTED]> To: "Oladejo, Tokunboh" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 3:21 PM Subject: Re: Connecting to mysql Server > On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: > > Does anyone have an idea why I am getting an error "Fatal error: Call to > > undefined function: mysql_connect() in /var/www" > > That's the error you get if you try to call mysql_connect() but don't have > the MySQL support compiled in to the PHP module. Rebuild the module, > making sure that you have the MySQL support enabled. Watch the output > from the configure stage, and see the PHP installation docs for more info. > > > > - > 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: Connecting to mysql Server
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: > Does anyone have an idea why I am getting an error "Fatal error: Call to > undefined function: mysql_connect() in /var/www" That's the error you get if you try to call mysql_connect() but don't have the MySQL support compiled in to the PHP module. Rebuild the module, making sure that you have the MySQL support enabled. Watch the output from the configure stage, and see the PHP installation docs for more info. - 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
Connecting to mysql Server
Hi All,
Does anyone have an idea why I am getting an error "Fatal error: Call to
undefined function: mysql_connect() in /var/www"
in this PHP function
"mysql_connect("localhost","root","password");"
Thanx All
-
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: Connecting to mysql server in a remote site and using LOAD command
Make sure you have permissions to connect to the remote site from your current server or host. Permissions need to be set for that user to connect from your server host - Original Message - From: "Hamzat Kamal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 8:27 AM Subject: Connecting to mysql server in a remote site and using LOAD command > Dear All, > > I have Mysql server installed at remote site which i need to connect to. > > I have tried this from my local computer but didn't work; > > c:\mysql\bin>mysql -h myhost -u myusername -pmypassword > > I will also like to use LOAD command to load a text file from my local > computer to the database on this mysql server at the remote site. > > I have been able to achieve both actions from my local machine. > > I am using win 98, Mysql 3.23 > > All supports to get these done will be appreciated. > > Thanks to you all. > > kamal. > > > > > - > 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
Connecting to mysql server in a remote site and using LOAD command
Dear All, I have Mysql server installed at remote site which i need to connect to. I have tried this from my local computer but didn't work; c:\mysql\bin>mysql -h myhost -u myusername -pmypassword I will also like to use LOAD command to load a text file from my local computer to the database on this mysql server at the remote site. I have been able to achieve both actions from my local machine. I am using win 98, Mysql 3.23 All supports to get these done will be appreciated. Thanks to you all. kamal. - 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
Connecting to mysql server in a remote site and using LOAD command
Dear All, I have Mysql server installed at remote site which i need to connect to. I have tried this from my local computer but didn't work; c:\mysql\bin>mysql -h myhost -u myusername -pmypassword I will also like to use LOAD command to load a text file from my local computer to the database on this mysql server at the remote site. I have been able to achieve both actions from my local machine. I am using win 98, Mysql 3.23 All supports to get these done will be appreciated. Thanks to you all. kamal. - 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: Trouble connecting to MySQL server using MySQLGUI and VCC
Chris Johnson writes: > The remote hosts you mention are not allowed to access the database. This > is a permissions problem, in particular the value of "hosts" in one of the > permissions tables. It sounds like they only allow connections from the > localhost or their own network. > > ..chris > > - Original Message - > From: "Robert Anderson" <[EMAIL PROTECTED]> > > > I've been playing with MySQL and trying to get connected to my web-hosting > company's MySQL server that they set up for me. In trying to use the > MySQLGui and also the VCC, I get the error "Host 'junior.dsl.neticus.com' is > not allowed to connect to this MySQL server". And if I'm plugged in at work > I get the same error with a different 'dsl.neticus.com' thing. > I can telnet to the company and then use their 'mysql.pm' utility using the > same parameters from the exact same workstation and locations. > Any ideas? > > Thanks in advance, > Rob > > > Chris is of course right. If you want to skip the above problem, grant privileges to user@"%", -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trouble connecting to MySQL server using MySQLGUI and VCC
The remote hosts you mention are not allowed to access the database. This is a permissions problem, in particular the value of "hosts" in one of the permissions tables. It sounds like they only allow connections from the localhost or their own network. ..chris - Original Message - From: "Robert Anderson" <[EMAIL PROTECTED]> I've been playing with MySQL and trying to get connected to my web-hosting company's MySQL server that they set up for me. In trying to use the MySQLGui and also the VCC, I get the error "Host 'junior.dsl.neticus.com' is not allowed to connect to this MySQL server". And if I'm plugged in at work I get the same error with a different 'dsl.neticus.com' thing. I can telnet to the company and then use their 'mysql.pm' utility using the same parameters from the exact same workstation and locations. Any ideas? Thanks in advance, Rob - 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
Trouble connecting to MySQL server using MySQLGUI and VCC
I've been playing with MySQL and trying to get connected to my web-hosting company's MySQL server that they set up for me. In trying to use the MySQLGui and also the VCC, I get the error "Host 'junior.dsl.neticus.com' is not allowed to connect to this MySQL server". And if I'm plugged in at work I get the same error with a different 'dsl.neticus.com' thing. I can telnet to the company and then use their 'mysql.pm' utility using the same parameters from the exact same workstation and locations. Any ideas? Thanks in advance, Rob - 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
