MySQL Free install version configuration

1. Download the corresponding free install version from the Internet and unzip it to the specified directory 2. Configure Environment variables

Add a new variable named "Mysql_home" in the "System Variables" column, the variable value is the path extracted in the first step, and then find the variable named "Path", click Edit, add ";%mysql_home%\bin" later, so far, The environment variable is configured.

3. Registering MySQL as a MySQL service

Enter CMD in the Start menu search, locate the executable file, run as Administrator, open the cmd window, enter the root directory of MySQL, input "Mysqld install MySQL" Run, will prompt the service installation success. In the service will see a service named MySQL, click on the properties to see if the path to start with the extracted path is consistent, otherwise it will pop up "cannot find the specified file", if this error occurs, then you can open the registry to find Hkey_local_ Machine---system--currentcontrolset--services--mysql in the ImagePath, click Edit, change the value to the mysqld of the Bin folder under the root directory of the decompression path (the D disk is the class: D:/mysql /BIN/MYSQLD) value can be written as: "D:\mysql\bin\mysqld" MySQL behind the main service name. Basically MySQL can start normally with the steps above

4. Login

After entering "Mysql-u root-p" in the cmd window, you will be prompted to enter the password, this time direct carriage return, because the default login password is empty, but after the carriage return prompt (ERROR 1045 (28000): Access denied for user ' root ' LocalHost ' (using password:no), where you need to skip the appropriate permissions to log in, you can find the My.ini configuration file in the root directory of MySQL and open add skip-grant-tables under [mysqld] (don't #, some words are removed), you can log in after the change.

My.ini is mainly its own configuration file, the default configuration file is as follows:

[Client] port=3306 Default-character-set=utf8

[Mysqld] Skip-grant-tables

port=3306

Character_set_server=utf8

Basedir=d:\program Files\mysql

Datadir=d:\program Files\mysql\data Sql_mode=no_engine_substitution,strict_trans_tables

[Winmysqladmin] D:\Program Files\mysql\bin\mysqld.exe

MySQL Free install version configuration