Shulou(Shulou.com)06/01 Report--

In this article, the editor introduces in detail "how to start and use the mysql database". The content is detailed, the steps are clear, and the details are handled properly. I hope this article "how to start and use the mysql database" can help you solve your doubts.

Start MySQL in the background service mode

Enter: net start mysql at the command line

Show that the MySQL service has been started successfully.

Note: if the "access denied" error appears here, run it in administrator mode.

Turn off the MySQL service

Enter: net stop mysql at the command line

Show that the MySQL service has been successfully stopped.

Start MySQL in command mode

Enter the following instructions to run: mysqld-- console

Note: this directive can start the MySQL server without administrator privileges, and the service will be shut down as soon as the open command prompt is closed.

In this way, you can see the console output of the database, which is easy to debug.

Note, because the service stops when you close the command prompt in this way, you need to open another command prompt for SQL.

Log in to your MySQL account

Type mysql-u username-p directly on the command line to log in to the MySQL command line.

-u, followed by the user name.

You need to enter a password after entering the instruction.

Go to the MySQL command line and use the command line for SQL operations.

After reading this, the article "how to start and use mysql database" has been introduced. If you want to master the knowledge points of this article, you still need to practice and use it yourself. If you want to know more about related articles, welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.