MySQL Installation and setup

Download Zip, configure

1, System variable added: ... \mysql-5.7.10-winx64, environment variable added:%mysql_home%\bin

2, modify Mysql.ini

Basedir= (same system variable path)

Datadir= (System variable path \data)

Port = 3306

3,cmd:%mysql_home%\bin\mysqld--initialize--user=mysql--console

A randomly generated initial password appears at the end of the console message and is noted

4,

%mysql_home%\bin\mysqld--install MYSQL

net start MySQL

5,

Mysql-u root-p

Enter the random password that you just recorded after you execute the carriage return

After successful execution, the console displays Mysql>

Input command set password for [email protected] = password (' 123 '); (Note semicolon)

At this point the root user's password is modified to 123

MySQL Installation and setup