Lamp_01_win under Install configuration MySQL

1. Unzip MySQL server to D drive
Configuring Environment variables
Mysql_home D:\J2EE\apache-ant-1.9.7
PATH%mysql_home%\bin;

2. Modify the MySQL boot configuration file
My-default.ini
Note Copy the backup and then modify
Basedir = d:\\j2ee\\mysql-5.7.14-winx64
DataDir = D:\\j2ee\\mysql-5.7.14-winx64/data
Port = 3306

3. Installing the MySQL Service
Run command prompt cmd as Administrator and note that the directory will be in the MySQL bin directory

4. Start the MySQL service
Input net start MySQL
Discovery failed to start

The reason is that the version does not have the data directory initialized to generate the data directory by default
Mysqld--initialize-insecure automatically generate password-free root users
Start again, service started successfully

5.Test
Mysqlshow-u root MySQL to see if MySQL is configured successfully

6. Change the MySQL password
Mysqladmin-u root password "root";
Log in to MySQL

7. View the database

See only the SYS database on Workbench

Lamp_01_win under Install configuration MySQL