Lost connection to MySQL server during query

[latheesan]

Im running the latest version of xampp on my windows xp SP2 server, but im getting the following error:

mysql_connect(): Lost connection to MySQL server during query

when my website tries to connect to it remotely. e.g.

mywebsite.com/test.php (website hosted on linux server)

Code: Select all

mysql_connect("home_pc.no-ip.com", "root", "123456");
mysql_select_db("test_db");

so when i run test.php, i get that error.... How can i fix this??? This problem is already discussed at webhostingtalk.com - http://webhostingtalk.com/showthread.php?t=537508 (still no luck, plz help)

[Wiedmann]

Maybe:
http://community.apachefriends.org/f/viewtopic.php?t=19458

[latheesan]

i tried the suggestion, especially "ping", i get the result "MySQL is Alive"

so, why isnt it still working???

[Wiedmann]

i tried the suggestion, especially "ping", i get the result "MySQL is Alive"

I hope, you have executed this command on the Linux box?

[latheesan]

no i executed that ping command on my windows box on cmd.exe

CD C:\WWW\xampp\mysql\bin
mysqladmin user==root pass==123456 ping

result = mysql is alive

[Wiedmann]

no i executed that ping command on my windows box on cmd.exe

That does not make a sense

Your problem is not the connection from pc1 (Windows) to pc1 (Windows). It's the connection from pc2 (Linux) to pc1 (Windows).

[WorldDrknss]

first off did you allow mysql to accept remote connection.
You can do this by logging into phpmyadmin -> Privileges -> Edit Privileges -> scroll down to Login Information and change Host: to Any host and then click on go, or you can select use text field: and enter a host name in, then click on go.

[latheesan]

Thanks allot for your reply.

I logged in phpmyadmin and did the privilages first:



Now, i went to my script, still no luck... Do i have to remove the pma and localhost users, leaving only my pc.no-ip.com account there and restart the server?

Take a look at my process list:



Is there something on it that shouln't be there???