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

I do not know if you have any understanding of the previous articles on how to install and deploy Mysql with a similar LNMP architecture. Today, I am here to give you a brief introduction. If you are interested, let's take a look at the body. I believe you will gain something after reading how to install and deploy Mysql of LNMP architecture.

one.

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

Second, install Mysql service

1. Install environment dependency packages (character terminal processing tools, parsers, compilers)

two。 Create an administrative user

3. Extract the mysql installation package to the / opt directory

4. Use cmake for configuration

Cmake\-DCMKAE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqk.sock\-DSYSCONFDIR=/etc\-DSYSTEMD_PID_DIR=/usr/local/mysql\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_PERFSCHEMA_STORAGE_ENGINE=1\-DMYSQL_DATADIR=/usr/local/mysql/data\-DWITH_BOOST=boost\-DWITH_SYSTEMD=1

5. Make & & make install process after compilation is completed

6. Assign permissions to create a user

7. Adjust the configuration file

8. Set environment variabl

9. Modify startup script to initialize database

10. Enable mysql to be managed by service commands

11. Open the service and check to see if the port is open

Create a database password

Log in to the mysql database again

Conclusion: there are a lot of details in the installation of the database that we need to pay attention to. We must be careful or report mistakes frequently leading to mental collapse!

After reading the article on how to install and deploy the Mysql of LNMP architecture, what do you think? If you want to know more about it, you can continue to follow our industry information section.

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.