Operation flow of MySQL database service software

The following content mainly brings you the operation flow of MySQL database service software, the knowledge mentioned here is slightly different from books, it is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing, hoping to bring help to the majority of readers.

Database service software is divided into the following two types

1. Relational database service software RDBMS

Oracle (cross-platform, not open source) MySQL (cross-platform, open source) DB2 (cross-platform.) SQL Server (charge)

two。 Non-relational database software NoSQL

The source of the bag? There are downloads on the Internet, and there are plenty of system installation CDs.

What is the type of packet? Rpm source code package

What I'm going to introduce to you today is mysql database.

Port number: 3306

Required software package: MySQL

Verification: rpm-qa | grep-I mysql

Default master profile: / etc/my.cnf

Database directory: / var/lib/mysql

It is usually basic to start service: systemctl start mysqld

If the computer was previously loaded with MySQL, enter this command if you need to upgrade a higher version of MySQL

Rpm-Uvh MySQL package upgrade installation

Check the database password. GREP password / var/log/mysqld.log

# since the initial password of the database is randomly generated, it is recommended to add a colon ""

Then log in with the initial password and reset the login password

Mysql-hlocalhost-uroot-p "password"

Connect to your own database

Mysql-hlocalhost-uroot

Landing

Example: mysql-uroot-hlocalhost-p "Popg%wflo1k2"

User name and password

Reset password login

Enter set global validate_password_length=6; # to change the password length after login

Set global validate_password_policy=0; # change the default value

Alter user root@ "localhost" identified by "self-configured password"

The above three items are performed in the database and belong to temporary configuration. If you need to take effect permanently, exit after entering on the command line and add two commands to change the default value and password length in the main configuration file, and then restart the service. The password can be permanently valid.

For the above MySQL database service software operation process, if you need to know more, you can continue to pay attention to the innovation of our industry, if you need professional answers, you can contact the pre-sale and after-sale on the official website. I hope this article can bring you some knowledge updates.