How to restart MySQL under Windows

How do I restart MySQL under Windows ? this has 3 A way for everyone to refer

First,MYSQL service

My Computer- ( Right-click ) management - Services and Applications - - service --mysql-- turn 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, start:# service mysqld start stop: # service mysqld stop restart:# service mysqld Restart

　　* Windows cannot be restarted directly (restart) , it can only be stopped and then started.

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 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 quotient optimization MySQL configuration of the server ;

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

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

　　CODE: [COPY]

　　max_connections= 1000

　　Wait_timeout = 5

The above content by the multi-backup www.dbfen.com Summary of reproduced please indicate the source!

This article is from the "Big Meatball" blog, please make sure to keep this source http://12478147.blog.51cto.com/9663367/1605829

How to restart MySQL under Windows