Install and configure MySQL in Windows (compressed package, installation package) _ MySQL

Install and configure MySQL in Windows (compressed package, installation package), download mysqluninstalled zippackage (mysql-5.6.16-winx64.zip), decompress and configure my. ini.

• Add MySQL file bin Path to Path

• Add key: MYSQL_HOME = E:/development/DataBase/MySQL/mysql-5.6.16-winx64/

• Path added: % MYSQL_HOME %/bin

• Copy my-default.ini, rename my. ini

• Modify my. ini configuration

• Basedir = E:/development/DataBase/MySQL/mysql-5.6.16-winx64/

• Datadir = E:/development/DataBase/MySQL/mysql-5.6.16-winx64/data

• Port = 3306

• Max_connections = 200

• Install the MySQL service:

• Mysqld -- install

Service successfully installed.

• Enable MySQL service

• Net start mysql

MySQL service is starting.

The MySQL service has been started successfully.

To delete the MySQL service

• Stop MySQL service

• Net stop mysql

• Delete MySQL service
  

• SC delete "MySQL"

• Run the command services. msc to view the service name: MySQL.

• Modify the default MySQL password

• Mysqladmin-uroot-p password

Enter password: # Null by default. press Enter.

New password: root # set the New password: root

Confirm new password: root # Confirm new password: root

• Now you can log on with a new password: mysql-h localhost-uroot-proot

...

Mysql>

To install the compressed version, follow these steps.

For details about the installation package, refer to the graphic tutorial on installing MySQL in Win7.

MySQL5.5: http://dev.mysql.com/downloads/mysql/5.5.html

MySQL5.6: http://dev.mysql.com/downloads/mysql/5.6.html

(Baidu online storage)