Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install mysql 5.6.23 and configure environment variables, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

1 download mysql

2 install mysql

3 configure environment variables

Open my computer-> Properties-> Advanced-> Environment variable, select PATH in the system variable, and add: the path to your mysql bin folder such as:

4 Test

The above interface shows that the configuration is successful.

You can also type "net start mysql" to start mysq, and the above interface indicates that the startup is successful. Then enter "mysql-hlocalhost-uroot-proot" ("- h" followed by your ip, "- u" followed by your user name, and "- p" followed by your password. If you don't have a password, you can write "mysql-hlocalhost-uroot-p"), and then click enter. The following interface indicates that the database connection is successful.

5 if you do not start the service, you need to start the service.

I.

1)。 Startup mode

1. Start with service: service mysqld start

2. Start with mysqld script: / etc/init.d/mysqld start

3. Start with safe_mysqld: safe_mysqld&

2)。 Stop it

1. Start with service: service mysqld stop

2. Start with mysqld script: / etc/init.d/mysqld stop

3 、 mysqladmin shutdown

3)。 Restart

1. Start with service: service mysqld restart

2. Start with mysqld script: / etc/init.d/mysqld restart

4)。 View running status

1. Start with service: service mysql status

2. Start with mysqld script: / init.d/mysqld status

On how to install mysql 5.6.23 and configure environment variables to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.