One of the greatest tricks for starting and disabling MySQL

This article describes how to start and stop MySQL. We all know that MySQL is often started and closed in practical applications, therefore, optimization is also highly concerned. The following describes the specific solution and hopes it will be helpful in your future study.

A: In linux: for example, My MySQL is installed in/usr/local/MySQL by source code.

Automatic: copy/usr/local/MySQL/share/MySQL. server to/etc/rc. d/init. d/, and

Chkconfig -- add MySQL. server to start the MySQL service after it is started.

Manual: Run/usr/local/MySQL/bin/MySQLd_safe -- user = MySQL as root

Windows:

Automatic:

Use cmd to go to the bin folder in the MySQL installation path and run: MySQLd-nt -- install

Manual: directly go to the bin folder of the MySQL installation path and execute net start MySQL.

If you do not want MySQL to start the service when the computer is started, execute: MySQLd-nt -- remove

You can also delete the corresponding service in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services and restart the computer.

Close MySQL: MySQLadmin-uroot-p shutdown

Start MySQL:

 
 

  
  
MySQLd-nt --install  
  
  
net start MySQL 
 
 

Q: How do I log on to MySQL?

A: MySQL-uroot-p. Press enter, enter the password, and then press Enter. If you have not modified the password, the default password is null.

Q: How can MySQL be converted into a graphical database? Is there any built-in graphical tool?

A: There are many, such as MySQL_center, SQLyog, phpMyAdmin, MySQL Query Browser, and MySQL Administrator,

MySQL_centerd on this site: http://bbs.MySQL.cn/thread-517-1-1.html

SQLyog searches the Internet. Many SQLyog407 versions are good.

I will not provide them one by one. I will search and download them online.

The above content is an introduction to MySQL startup and shutdown. I hope you will have some gains.

The above content describes how to start and stop MySQL. I hope it will help you in this regard.