In-depth exploration of mysql (1)-Introduction to database and mysql installation, from simple to deep mysql

In-depth exploration of mysql (1)-Introduction to database and mysql installation, from simple to deep mysql

Mysql installation: Since you only have a Linux computer, Let's explain how to install mysql in Linux! In fact, I suggest you directly use the apt command for installation, which is convenient and easy to use! In addition, the company will basically integrate these basic software. Install the command sudo apt install mysql-server. As follows:

During installation, a window is displayed, prompting you to enter the root password.

After entering the information, you can complete mysql installation! However, you cannot connect to mysql directly. The error type Can't connect to local MySQL server through socket '/var/run/mysqld is displayed. sock '(2), and we can use the ps command to find that mysql is not started at all.

Since the service control files of the software installed through apt are all in the/etc/init. d folder, we can start it by running the sudo/etc/init. d/mysql start command.

At this end, we have completed the basics of learning. The user operations and authorization information in mysql will be learned in the following sections.