How to restart MySQL under Windows

The second method is not valid for me, then make sure!

One, MySQL service

My Computer--(right key) management--Service and application--service--mysql--(stop, reboot)

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 directly restarted (restart), can only stop first, then start.

We can actually save it as mysqlreset.bat through batch processing.

The code is as follows:

net stop MySQL

net start MySQL

Third, Too many connections

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

Error Number: 1040

Problem Analysis:

The number of connections exceeds the value set by MySQL and is related to both max_connections and wait_timeout. The larger the value of the wait_timeout, the longer the idle wait for the connection, which causes the current number of connections to become larger.

Workaround:

1, the virtual host user please contact space business to optimize the MySQL server configuration;

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

Modify the parameters in the MySQL configuration file (My.ini under Windows, MY.CNF under Linux):

CODE: [COPY]

max_connections= 1000

Wait_timeout = 5

If you are not able to add, modify and restart MySQL, if you regularly report this error, please follow the server environment to build a tutorial check your server.