If you are going to access the database from another remote server, why don’t you place a file inside your site with some security such htpasswd protection or some authentication module I restart the MySQL Service and check to see if I can connect to using the mysql consol in dos and it just won’t let me in, saying it can’t connect to mysql! The likely culprit that people often forget is: I’ve been trying to fix this error for a couple of days now and seem to be stuck with it. Close ‘ Initialize a few local variables to store the MySQL username, password, location, driver name and database name. The error means that you are not allowed to access the web server remotely. It test connection, shows databases and tables.
|Date Added:||13 September 2009|
|File Size:||39.74 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
I dont know how to do it Can anyone give me a solution to this problem. To enable connection pooling for the MySQL driver:. Resolution To decrease the delay before Windows releases an open TCP connection, use regedit to edit the following registry value of: This question is myxql but here is to guide anyone who had a problem like mine.
Sign up or log in Sign up using Google. Sign up using Facebook.
What is the problem? May 29, Which is the result of netstat?
Note that in declaring the Server, Database, User and Password do not use quotes. The application has previously been able to successfully connect to the database. May 3 connecction at 8: In setting up Diafaan SMS server, i had the same problem.
Conncetion that’s not a good idea. It was eventually the MySql ref. Post as a guest Name. Sign up using Email and Password. I have created a user account in the MySQL Administrator and added a host to enable remote access, I have also made an exception for my Windows Firewall on port but the connection still fails.
Close ‘ Initialize a few local variables to store the MySQL username, fauled, location, driver name and database name.
Yes you can most certainly connect to mySql using root. If it’s just for data synchronization, go for db server concepts SqlClient namespace in your application.
connecting to mySql DB using ODBC driver
Edited 8 Years Ago by AndreRet: I rewrote the connection string in my web. Decreasing the value of TcpTimedWaitDelay should help, but is unlikely to permanently solve the problem for a busy system because if the system is busy the limits will still be hit. Check the mysql configuration: Especially if it’s on the MySQL default port.
The trouble is that under heavy load when lots of connections are opened and closed to the database, the system can hit a limit on the maximum number of connections allowed even though as far as the application is concerned these connections have been closed.
I doubt it is however.
I really hope you find the solution because I know what you are going through.: