MySQL 5.5.56 installation-free version configuration method

The configuration method of MySQL 5.5.56 free installation version is explained in detail through text code. The specific content is as follows:

1. Download mysql-5.5.56-winx64

URL: dev.mysql.com/downloads/mysql/

2. Unzip the MySQL archive

Unzip the downloaded MySQL compressed package to a custom directory. My unzip directory is:
  "D:\Program Files\mysql-5.5.56-winx64"
  Copy the default file my-default.ini in the decompressed directory and rename 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 a new my.ini or get it from other places#################################################################
  [client]
  port=3306
  default-character-set=utf8
  [mysqld]
  port=3306
  character_set_server=utf8
  basedir=D:\Program Files\mysql-5.5.56-winx64
  #Unzip directory datadir=D:\Program Files\mysql-5.5.56-winx64\data
  #Unzip the data directory in the directory sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  [WinMySQLAdmin]
  D:\Program Files\mysql-5.5.56-winx64\bin\mysqld.exe
#########################################################

3. Add environment variables

The operation is as follows:

1) Right-click My Computer -> Properties -> Advanced System Settings (Advanced) -> Environment Variables

Click the New button under System Variables
Enter the variable name: MYSQL_HOME
Enter the variable value: D:\Program Files\mysql-5.5.56-winx64
# is the custom decompression directory of mysql.

2) Select Path in the system variables

Click the Edit button
Add the variable value in the variable value: %MYSQL_HOME%\bin
Note that you should add this variable after the original variable value, separated by ;. You cannot delete the original variable value.

4. Register MySQL as a Windows system service

1) From the console, go to the bin directory under the MySQL decompression directory:

2) Enter the service installation command:

mysqld install MySQL --defaults-file="D:\Program Files\mysql-5.5.56-winx64\my.ini"
#Unzip the modified my.ini file in the directory
After the installation is successful, a message will pop up saying that the service has been successfully installed.
#Note: The my.ini file is placed in the root directory after MySQL is unzipped
#Remove service command: mysqld remove

5. Start MySQL service

Method 1:

The command to start the service is: net start mysql

Method 2:

Open the management tool service and find the MySQL service.

Start the service by right-clicking and selecting Start or directly clicking Start on the left.

6. Change the root account password

When the installation is just completed, the default password of the root account is empty. At this time, you can change the password to the specified password. For example: 123456. (Note: mysql commands end 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. MySQL console shortcut creation:

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

Define the shortcut name yourself, confirm, and the shortcut is created 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 username -p password database name

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

Summarize

The above is the configuration method of MySQL 5.5.56 free installation version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!