MySql environment Configuration

Keyword: MySQL 5.6.17 phpmyadmin

[Download MySQL]

MySQL Community Server MySQL Community edition free of charge

Note: oracle Account Login and download are required

[Install MySQL]

1、unzip mysql-5.6.17-winx64.zip to the d: \ Program Files \ mysql \ mysql-5.6.17-winx64 directory.

2. Clear the debugging file (not required)
Clear the files suffixed with. lib or. pdb in the folder and the debug directory.

3. Create my. ini as the MySQL configuration file
Create a text file in the root directory and name it my. ini. Open it and copy and save the content:

Port =-character-= port = character_set_server = # character_set_server = basedir = datadir = SQL _mode ##################### ####################################View Code

 

4. Configure Environment Variables

Add in system environment variables; D: \ Program Files \ mysql \ mysql-5.6.17-winx64 \ bin;

 

4. Install MySQL as a service

The Administrator runs cmd and mysqld-install. A message is displayed, indicating that the service is successfully installed! Start the Service net start MySQL

[Configure MySQL]

1. Configure root User Logon (the default password is blank)

The Administrator runs cmd and mysql-uroot-p. When the user is prompted to enter the password, press enter to check whether the prompt is successful. Then, enter Quit to exit mysql.

Enter mysqladmin-uroot-p password <new password>, replace <new password> with your custom password, and press Enter. The system will prompt you to enter the password. The original password is empty and you can press enter to complete the settings.

[Configure phpmyadmin]

1. Download phpmyadmin

2. Configure iis

Enable windows

Internet Information Services-World Wide Web Service-application development function-CGI

By default, iis does not support adding php via web Platform Installation Tools.

3. Installation

Create a site through iis, put the downloaded site in the program, and start the access