MySql 5.6.14 winx64 configuration method (without installation), 5.6.14winx64
1. Download MySQL Community Server 5.6.14
2. decompress the MySQL package
Decompress the downloaded MySQL package to the custom directory.
3. Add Environment Variables
Variable name: MYSQL_HOME
Variable value: D: \ Program Files \ mysql-5.6.14-winx64
That is, the custom extract directory of mysql.
Add % MYSQL_HOME % \ bin in Path.
4. Register a windows system service
Register mysql as a windows system service
The procedure is as follows:
1) Create a New my. ini file and copy the my. ini file to the c: \ windows directory. The content of my. ini is as follows:
[Client] port = 3306default-character-set = utf8 [mysqld] # Set to MYSQL installation directory basedir = D: \ Program Files \ mysql-5.6.14-winx64 # Set to mysql data directory datadir = D: \ Program Files \ mysql-5.6.14-winx64/dataport = 3306character_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
2) log on to the bin directory under the MySQL extract directory from the console.
3) enter the service installation command:
mysqld.exe -install
If Install/Remove of the Service Denied appears!
Because Windows 7 and vista have stricter permissions.
Go to C: \ Window \ System32, right-click CMD. EXE, and select "Run as administrator". Then, go to the corresponding directory and execute the command. Everything is OK.
After the installation is successful, a message is displayed, indicating that the service is successfully installed.
Note: The my-default.ini file is in the root directory after MySQL decompression, if not, can be obtained from other places.
Command: mysqld remove
5. Start the MySQL Service
Method 1:
Run the following command to start the service: net start mysql.
Method 2:
Open the management tools service and find the MySQL service.
Right-click Start or click Start on the left to start the service.
6. Modify the password of the root account
When the installation is complete, the default password of the root account is blank. You can change the password to the specified password. Example: 123456
Method 1:
C:> mysql-urootmysql> show databases; mysql> use mysql; mysql> UPDATE user SET password = PASSWORD ("123456") WHERE user = 'root'; mysql> flush privileges; [do not forget this sentence, otherwise the password change will not take effect] mysql> QUIT
Method 2:
Use a third-party management tool to change the password. For example, Navicat for MySQL
The above is a small series of MySql 5.6.14 winx64 configuration method (without installation), I hope to help you, if you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!