Install MySql notes

1. First, decompress the mysql-noinstall-5.2.3-falcon-alpha-win32.zip package in the E drive and change it to Mysql, which is placed in the root directory of the E drive.

2. Create a new "my. ini" file in notepad and enter

[WinMySQLAdmin]
Servers = E:/Mysql/bin/mysqld-nt.exe
[Mysqld]
Basedir = E:/Mysql
Datadir = E:/Mysql/data

And put it in the root directory of drive C.

3. Modify the Path environment variable and add "; E: \ Mysql \ bin.

4. Run CMD and enter "mysqld-nt-install" in the E: \ Mysql \ bin directory. The prompt "Service successfully installed." appears ."

5. Continue to enter "net start mysql". "MYSQL service is starting."; "MYSQL service started successfully ."

OK!

6. due to errors in the middle, there are always 1067 errors. Sometimes you need to restart the machine.

7. There is no password for the new installation. Enter "mysql-uroot-p" to enter, and the prompt is changed to "mysql>". Change the password to "mysqladmin-uroot-password 123456 ".