Mysql 5.6.13 installation-free configuration method details, mysql5.6.13

Mysql 5.6.13 installation-free configuration method details, mysql5.6.13

This article will record the configuration of mysql without installation in the previous project. Today, I will share my configuration method with the help house platform for you to learn.

1. Download mysql Community Server 5.6.13

2. decompress the MySQL package

Decompress the downloaded MySQL package to the custom directory. The decompressed directory is:

"D: \ Program Files \ MySQL \ mysql-5.6.13-win32"

Copy the default file my-default.ini in the unzipped directory and change it to my. ini.

Copy the following configuration information to my. ini and save it.

# If there is no my-default.ini, you can create my. ini yourself or get it from somewhere else

######################################## ############### [Client] port = 3306default-character-set = utf8 [mysqld] port = 3306character_set_server = utf8basedir = D: \ Program Files \ MySQL \ mysql-5.6.13-win32 # extract directory datadir = D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ data # extract directory data SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES [WinMySQLAdmin] D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ bin \ mysqld.exe ############################# ############################

3. Add Environment Variables

The procedure is as follows:

1) Right-click my computer-> properties-> advanced system settings (advanced)-> Environment Variables

Click new Under System Variables

Input variable name: MYSQL_HOME

Input variable value: D: \ Program Files \ mysql-5.6.11-winx64

# This is the custom extract directory of mysql.

2) Select the Path in the system variable

Click Edit
Add the variable value % MYSQL_HOME % \ bin to the variable value.
Note that this variable is added after the original variable value and separated by;. The original variable value cannot be deleted,

4. Register mysql as a windows system service

1) log on to the bin directory under the MySQL decompression directory from the console:

2) enter the service installation command:

mysqld install MySQL --defaults-file="D:\Program Files\MySQL\mysql-5.6.13-win32\my.ini"

# Decompress the my. ini file modified in the directory

After the installation is successful, a message is displayed, indicating that the service is successfully installed.

# Note: Put the my. ini file in the root directory after MySQL Decompression

# The command for removing a service is 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

c:>mysql –urootmysql>show databases;mysql>use mysql;mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';mysql>FLUSH PRIVILEGES;mysql>QUIT

7. Create a MySQL console shortcut:

1) Right-click the desktop and choose new> shortcut> Object Location. Enter C: \ Windows \ System32 \ cmd.exe.
The shortcut name is defined by yourself. OK. The shortcut is successfully created.

2) Right-click the created shortcut and choose Properties> modify the target column to MySQL startup parameters:
C: Windows \ System32 \ cmd.exe "D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ bin"/k mysql-uroot-p inventory
Explanation: CMD path "MySQL path bin directory"/k mysql-u username-p Password Database Name

3) Click OK to save the modification. Double-click the shortcut to connect to the MySQL database.

The above is a detailed description of the configuration method of mysql 5.6.13 without installation. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!