Graphic explanation of Mysql5.7.11 Green Edition installation tutorial, mysql5.7.11 graphic

Graphic explanation of Mysql5.7.11 Green Edition installation tutorial, mysql5.7.11 graphic

The installation tutorial of Mysql5.7.11 Green Edition is illustrated as follows:

1. decompress the mysql-5.7.11 package to the disk folder you want to store;

2. Create a new data folder and a new my. ini file in the folder, and configure the my. ini file.

My. ini file content: the key point is to configure the data DIRECTORY and storage root directory in the Mysql folder.

3. on my computer, choose Properties> advanced system Settings> environment variables> Configure path variables;

Variable value:

4. Open the cmd.exe program with the administrator ID

NOTE: If cmd.exe is not opened using the administrator ID, it will appear during mysql installation.

---------- Install/Removeof the Service Denied! ---------------------------------------------------------------

5. initialize the new data folder;

Command 1:>mysqld--initialize-insecure; (No root password after initialization. We recommend that you use it)

Command 2:>mysqld–initialize; (A random root password is generated after initialization)

Select either of the preceding commands:

Data folder after successful execution

6. Install the mysql Service

Command:>mysqld-install

Installed successfully!

-------------------------- Servicesuccessfully installed .----------------------------

7. Start mysql

Command:>net start mysql

8. log on to mysql

Command:>mysql -u root -p(If you do not have a password for the first login, press enter to log in)

Login successful !!

9. Set the User Password

Command:>setpassword for root@localhost = password(‘new password');

Password set !!!

Key commands:

Command 1:>mysqld--initialize-insecure; (No root password after initialization. We recommend that you use it)

Command 2:>mysqld–initialize; (A random root password is generated after initialization)

Command:>mysqld-install

Command:>net startmysql

Command:>mysql -uroot -p

Command:>setpassword for root@localhost = password(‘new password');

10. Access the mysql service through the user and password

Login successful !!!!!

11. Stop and quit the service.

Command:>quit;>exit; >\q;

Simple Test Operation:

1. show databases; // list of all databases

2. create database dbName; // create a database

3. use dbName; // select a database

4. show tables; // display the table list

The above is a graphic explanation of the Mysql5.7.11 green installation tutorial. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!