Shulou(Shulou.com)06/01 Report--

Mysql 5.5.56 installation-free configuration method, which is explained in detail by text code, as shown below:

1. Download mysql-5.5.56-winx64

Web site: dev.mysql.com/downloads/mysql/

two。 Decompress the MySQL package

Unzip the downloaded MySQL package to a custom directory. My directory is: "D:\ Program Files\ mysql-5.5.56-winx64" will extract a copy of the default file my-default.ini under the directory. Rename my.ini copy the following configuration information to my.ini to save # if there is no my-default.ini You can create a new my.ini or obtain # [client] port=3306 default-character-set=utf8 [mysqld] port=3306 character_set_server=utf8 basedir=D:\ Program Files\ mysql-5.5.56-winx64 # decompress the directory datadir=D from somewhere else. :\ Program Files\ mysql-5.5.56-winx64\ data # decompress the data directory sql_mode=NO_ENGINE_SUBSTITUTION under the directory STRICT_TRANS_TABLES [WinMySQLAdmin] D:\ Program Files\ mysql-5.5.56-winx64\ bin\ mysqld.exe###

3. Add environment variabl

Do the following:

1) right-click my computer-> Properties-> Advanced system Settings (Advanced)-> Environment variables

Click the New button under the system variable

Enter variable name: MYSQL_HOME

Enter the variable value: d:\ Program Files\ mysql-5.5.56-winx64

# is the custom decompressed directory of mysql.

2) Select Path in the system variable

Click the edit button

Add a variable value to the variable value:% MYSQL_HOME%\ bin

Note that the original variable value cannot be deleted by adding this variable to the value of the original variable.

4. Register mysql as a windows system service

1) go to the bin directory under the directory of MySQL decompression from the console:

2) enter the service installation command:

Mysqld install MySQL-- defaults-file= "D:\ Program Files\ mysql-5.5.56-winx64\ my.ini"

# decompress the modified my.ini file in the directory

When the installation is successful, you will be prompted that the service installation is successful.

# Note: the my.ini file is placed in the root directory after MySQL is decompressed

# remove service command: mysqld remove

5. Start the MySQL service

Method 1:

The start service command is: net start mysql

Method 2:

Open the Administrative tools service and locate the MySQL service.

Start the service by right-clicking Startup or clicking Startup on the left.

6. Change the password of the root account

The default password for the root account is empty when the installation is completed. At this time, you can change the password to the specified password. Such as 123456. (note: the mysql command ends with;)

C: > mysql-uroot mysql > show databases; mysql > use mysql; mysql > UPDATE user SET password=PASSWORD ("123456") WHERE user='root'; mysql > FLUSH PRIVILEGES; mysql > QUIT

7. Create the MySQL console shortcut:

1) right-click on the desktop-> New-> Shortcut-> object location input: C:\ Windows\ System32\ cmd.exe

The shortcut name is defined by itself, and the shortcut is established successfully.

2) right-click the shortcut you just created-> Properties-> change 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 user name-p password database name

3) Click OK to save after the modification is completed, and double-click the shortcut to connect to the MySQL database

Summary

The above is the mysql 5.5.56 installation-free configuration method introduced to you by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.