Restart MySQL under Windows

The second method is ineffective for me, and I'll find out later!

First, MySQL service

My Computer-(right-click) management-Services and applications-service--mysql--on (stop, restart)

Second, the command line mode

Windows

1. Click "Start", "Run" (shortcut key Win+r).

2. Start: Enter net stop MySQL

3. Stop: Enter net start MySQL

Hint * Redhat Linux also supports service command, boot: # service mysqld start stop: # service mysqld Stop restart: # service mysqld Restart

* Windows can not be restarted directly (restart), can only stop, then start.

Third, Too many connections

2008-04-30┆379,578 views┆56,071

Error Number:1040

Problem Analysis:

The number of connections exceeds the MySQL setting value, which is related to Max_connections and wait_timeout. The larger the value of the wait_timeout, the longer the idle wait for the connection, which results in a greater number of current connections.

Workaround:

1, virtual host users please contact the space provider to optimize the configuration of MySQL server;

2, independent host users please contact the server administrator to optimize the configuration of MySQL server, can refer to:

Modify the parameters in the MySQL configuration file (under Windows My.ini, Linux for my.cnf):

• CODE: [COPY]
• max_connections= 1000
• Wait_timeout = 5

If you do not have the ability to add, modify and restart MySQL, if you regularly report this error, please follow the server Environment Setup tutorial Check your server

Restart MySQL under Windows