Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL server for Windows help needed!

Status
Not open for further replies.

iisuser

ISP
Feb 1, 2003
6
DE
Hello all!
I have Windows-2000 Server with IIS-5.0, PHP (4.3.0) and MySQL (3.23.55).
There are about 4000 users with their MySQL databases. Users can access databases using their PHP scripts. Only local users are allowed.
To create a user I use this command:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `User_database` . * TO 'User'@'localhost' IDENTIFIED BY 'Pass';

The problem: after 3-4 hours of work, all users getting the error message: "Can't connect to MySQL database at localhost (10061)".
I can't connect to MySQL using mysql.exe with admin username and password too!
But MySQL service is still running! Restarting of MySQL service gives no result. Restarting of IIS gives no result.
Only reboot of server solves the problem.
But after 3-4 hours problem appears again!
Now I have to reboot server every 4 hours... It's crazy!
I have tryed everything I know. I going to crush my head into the wall :(

Here is my.ini file:
[mysqld]
basedir=C:/mysql
tmpdir=C:/mysql/tmp
datadir=E:/mysql/data
port=3306
skip-locking
default-character-set=latin1
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=600
skip-innodb
set-variable = max_connections = 3000

And here is [MySQL] section of php.ini file:
[MySQL]
mysql.allow_persistent = Off
mysql.max_persistent = 200
mysql.max_links = 500
mysql.default_port = 3306
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off

Please help! Thank you!
kostya_r@hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top