Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the process of installation and configuration of MySQL". In daily operation, I believe many people have doubts about the process of installation and configuration of MySQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "the process of installation and configuration of MySQL". Next, please follow the editor to study!

I. the concept of MYSQL

1. Database management system (DBMS) is a kind of software for managing and manipulating data, including sql server,access,oracle and other database management systems.

2. Database Application system (DBAS) is a system developed by programmers for users, such as student management system, book management system, online voting system and so on.

II. Installation of MYSQL

1. The placement path of the data file can be modified during installation.

2. To modify the character encoding during installation, the default character encoding is Latin1, which does not support Chinese. We need to change it to the international standard character encoding UTF-8. If we only need simplified Chinese, we can change it to gb2312 or gdk.

3. Start service errors may occur in installation

The solution is:

(1) delete the mysql in the control panel first.

(2)。 Go to the C:\ Program Files directory and delete the mysql directory.

(3) if there is a setting directory on other disks, also delete it. The empty directory should also be deleted.

(4) go to regedit to change the registry

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL

If there is, delete it all! (tip: use F3 loop to find "mysql")

(5) if the mysql content in the task manager is also deleted

(6) turn off the firewall

(7) reinstall mysql (I didn't restart the computer here)

If necessary to reinstall, restart the computer, deactivate IIS, and delete temporary files in temp.

If it really doesn't work, when configuring mysql, change the mysql service name to another service name.

4 successful installation is shown in the following figure

Note: if the password is entered incorrectly, the command box will close. If the password is correct or the command box is closed, the mysql service has not been started and the service needs to be restarted.

III. Configuration and management of MYSQL

1. Start and stop the MYSQL service

(1) start and stop in the Services project in computer Management.

(2) enter the command character (net start mysql/net stop mysql) under DOS

2. Two ways to log in to MYSQL

(1) directly log in to mysql 5.5Commad Line Client to enter the login password, and then enter the operation to the library.

(2) Log in from the DOS command prompt

Enter the DOS system and enter the installation directory where mysql is installed (if the environment variable is set, you can enter the command directly. )

Type the command mysql-uroot-p password and enter directly into the MYSQL.

3. Change the password

Enter the mysql installation directory under DOS, enter the command mysqladmin-uroot-p original password password new password, and log in directly with the new password after successful modification. You can enter the database building operation.

Forget your password

(1) stop the mysql service

(2) find the my.ini configuration file

(3) enter the command skip-grant-tables under [mysqld]

(4) you can log in with any password when you start the mysql service. After logging in, you need to change the password.

(5) the method of changing the password is as follows:

Use mysql (mysql is the library that comes with the system)

Update user set password=password ('new password') where user='root'; (be sure to add; sign)

(6) delete the skip-grant-tables after successful modification, and then restart the service

5. If you want to modify the character encoding after installing MYSQL, you can modify it from the configuration file my.ini. Be sure to restart the service after modification.

Note: (1) in mysql, every SQL statement must end with;

(2) the user name of the mysql administrator is root

At this point, the study on "the process of installation and configuration of MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.