hippypink Posted January 23, 2007 Share Posted January 23, 2007 also getting errors in my application: Lost connection to MySQL server during queryI cannot login to phpmyadmin, nor mysql from the command line.restarting mysql and db server no help. it occurs for multiple databases as well, each with different username and password. Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/ Share on other sites More sharing options...
hippypink Posted January 23, 2007 Author Share Posted January 23, 2007 oh, one mroe thing about this, the database is running on a separate database server. I have many different applications. I also have two different databases setup (on different ports). Neither of them work. IF I copy over a database from the database server and run it on the same box as the web application, then it works. This problem appeared all of a sudden, after several years of this setup arrangement. Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/#findComment-167441 Share on other sites More sharing options...
hippypink Posted January 23, 2007 Author Share Posted January 23, 2007 one more thing: I am willing to pay to get an answer to this problem. Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/#findComment-167456 Share on other sites More sharing options...
fenway Posted January 23, 2007 Share Posted January 23, 2007 [quote author=hippypink link=topic=123695.msg511633#msg511633 date=1169580946]oh, one mroe thing about this, the database is running on a separate database server. I have many different applications. I also have two different databases setup (on different ports). Neither of them work. IF I copy over a database from the database server and run it on the same box as the web application, then it works. This problem appeared all of a sudden, after several years of this setup arrangement.[/quote]If you're willing to pay, pay your admin (or hire one). Otherwise, it seems like the connection was established, then timed out... how are these boxes separated? Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/#findComment-167477 Share on other sites More sharing options...
hippypink Posted January 23, 2007 Author Share Posted January 23, 2007 Thats the thing, my admin is stumped on this one, and I don't know how to outsource/hire another for this one issue. Where do I go/start? Are you for hire on a support issue like this?The boxes are all on the same subnet mask, all behind the same switch.Does this answer your question ?After re-evaluation, I believe only the one mysql server was having problems (not sure though). The mysql installation having the problem was for one software application--but it doesnt make sense that I could not connect via command prompt (shell)--not unless someone changed the password to the db (e.g. hacker, or, one of our guys), or mysql/password file was corrupt. Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/#findComment-167601 Share on other sites More sharing options...
fenway Posted January 24, 2007 Share Posted January 24, 2007 I'm just trying to determine how such a connection could be dropped... if it's all on the same local network, effectively, that should never happen. Quote Link to comment https://forums.phpfreaks.com/topic/35401-cannot-connect-to-mysql-from-command-line-locally/#findComment-167986 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.