MySQL 5.6.23 Installation and Configuration Environment Variables Tutorial

This article shares the installation and configuration tutorial of MySQL 5.6.23 for your reference. The specific contents are as follows

1 Download mysql

2 Install MySQL

3 Configure environment variables

Open My Computer->Properties->Advanced->Environment Variables, select PATH in System Variables, and add the path of your mysql bin folder after it, such as:

4 Testing

The above interface appears, indicating that the configuration is successful.

You can also enter "net start mysql" to start mysql. The above interface appears, indicating that the startup is successful. Then enter "mysql -hlocalhost -uroot -proot" (the "-h" is your IP address, the "-u" is your username, and the "-p" is your password. If there is no password, you can write "mysql -hlocalhost -uroot -p"), then click Enter. The following interface appears, indicating that the database connection is successful.

5 If the service is not started, you need to start the service

one,

1). Startup method

1. Start using service: service mysqld start

2. Start using the mysqld script: /etc/init.d/mysqld start

3. Start with safe_mysqld: safe_mysqld&

2) Stop

1. Start using service: service mysqld stop

2. Start using the mysqld script: /etc/init.d/mysqld stop

3.mysqladmin shutdown

3) Restart

1. Start using service: service mysqld restart

2. Start using the mysqld script: /etc/init.d/mysqld restart

4). Check the running status

1. Start using service: service mysql status

2. Start using the mysqld script: /init.d/mysqld status

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.