Summary of MySQL database installation and startup in ArchLinux

This article describes how to correctly install and start MySQL Databases on ArchLinux. We all know that on ArchLinux, we can easily install MySQL (the best combination with PHP. We can use the following command to install:

Pacman-Sv MySQL (best combination with PHP)

Just such a simple command, we can install the latest MySQL (the best combination with PHP) Database on our system. Of course, we need to do the following work to enable our MySQL (the best combination with PHP) server.

First, we need to add MySQL (the best combination with PHP) users and groups. We can use the following command to do this:

Groupadd MySQL (the best combination with PHP) (add MySQL (the best combination with PHP) Group)

Useradd-g MySQL (the best combination with PHP) (add MySQL (the best combination with PHP) Users)

Then we can use the following command to install some predefined data tables of MySQL (the best combination with PHP) database:

MySQL (the best combination with PHP) _ install_db -- user = MySQL (the best combination with PHP)

At this time, if we start the MySQL (the best combination with PHP) server, there will be some prompts, we need to do the following:

Mkdir/var/lib/MySQL (Database

Touch/var/lib/MySQL (the best combination with PHP)/myhost. err

After this operation, we can start the MySQL (the best combination with PHP) server:

MySQL (the best combination with PHP) d_safe &

MySQL (best combination with PHP) server startup script

MySQL (the best combination with PHP) d_safe -- MySQL (the best combination with PHP) server startup script

MySQL (the best combination with PHP) d_safe is a recommended method for starting MySQL (the best combination with PHP) servers on Unix or NetWare systems. MySQL (the best combination with PHP) d_safe adds many security features, such as restarting the server when an error occurs and writing runtime information to the error log file.

Here, we should note that to maintain backward compatibility with the old version of MySQL (the best combination with PHP), MySQL (the best combination with PHP) the binary release version also contains safe_MySQL (the best combination with PHP) d as a link to MySQL (the best combination with PHP) d_safe. However, we should not rely on this startup program because it will be removed in future versions.

By default, if there is an executable MySQL database d-max, MySQL (the best combination with PHP) d_safe

1 in Linux, MySQL (the best combination with PHP)-Max RPM depends on MySQL (the best combination with PHP) d_safe behavior. RPM installs an executable program named MySQL (the best combination with PHP) d-max, which makes MySQL (the best combination with PHP) d_safe will automatically call this executable program from now on.

2. If you have installed a binary release version containing the d-max server named MySQL (the best combination with PHP, then, in a future period, we updated a MySQL without Max version (the best combination with PHP) and MySQL (the best combination with PHP) d_safe will still try to run the old MySQL (the best combination with PHP) d-max server. If we perform such an update, we simply remove the old MySQL (the best combination with PHP) d-max server and ensure the best combination of MySQL (and PHP) d_safe run the new MySQL (the best combination with PHP) d server.

To overwrite the default behaviors and display the servers that we want to run, we can use MySQL (the best combination with PHP) d_safe specifies a-MySQL (the best combination with PHP) d or-MySQL (the best combination with PHP) d-version option.

Most options of MySQL (the best combination with PHP) d_safe are the same as those of MySQL database d.

MySQL (best combination with PHP) d command line option

In command behavior MySQL (the best combination with PHP) All options specified by d_safe are passed to MySQL (the best combination with PHP) d. If we want to use any MySQL (the best combination with PHP) specified by d_safe and MySQL (the best combination with PHP) d is not supported, do not specify them in the command line. Instead, we can list them in an optional file [MySQL (the best combination with PHP) d_safe] group.

The above content introduces how to install and start the MySQL database on ArchLinux.