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

1. Decompress mysql zip software package

2. Configure environment variables

3. Modify the configuration file my_default.ini and add the following:

[mysqld]

Basedir=D:\ MySQL\ MySQL Server 5.6 (directory where mysql resides)

Datadir=D:\ MySQL\ MySQL Server 5.6\ data (directory where mysql resides\ data)

4. Install the mysql service

Run cmd as an administrator, enter the mysql bin directory, and execute the mysqld-install command to install the mysql service (the mysqld-remove command removes the mysql service).

5. Start the mysql service

Run in the cmd bin directory environment of step 4: net start mysql

Note: error 2 and error 1067 often occur at this time.

If "error 2 system cannot find the file", check whether the configuration file has been modified or if you have entered the bin directory. If the configuration file has been modified correctly and entered the bin folder, you need to delete mysql (enter mysqld-remove) and then reinstall (enter mysqld-install).

If error 1067 occurs, it is a configuration file modification error to verify that the configuration file is correct.

6. Log in to mysql database:

Mysql-u root-p (enter, no password for the first login)

7. Make the default user account secure

The password for the initial root account is empty, so anyone can use the root account to connect to the MySQL server without any password and have all permissions.

Mysql > select host,user,password from mysql.user

+-+

| | host | user | password | |

+-+

| | localhost | root |

| | 127.0.0.1 | root |

| | localhost |

+-+

You can delete an anonymous user if you do not want someone to log in through an anonymous user, and it is recommended to delete or set a password for it, because the anonymous user has the same permissions as the root user.

Mysql > drop user'@ 'localhost'

Use SET PASSWORD to specify the password, connect to the server with root and execute two SET PASSWORD statements. Be sure to use the PASSWORD () function to encrypt the password.

Mysql > set password for 'root'@'localhost' = password (' root')

Mysql > set password for 'root'@'127.0.0.1' = password (' root')

After setting the password, you must provide the corresponding password the next time you reconnect to the server.

D:/MySQL/bin > mysql-u root-p

Enter password: *

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.