How to deploy LAMP Schema and install Mysql Database

This article mainly introduces how to deploy the LAMP framework to install the Mysql database, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for you is still relatively great, the following with the author to understand how to deploy the LAMP framework to install the Mysql database.

Deploy the LAMP architecture

Install the Mysql database

1. Install the environment package

two。 Extract the source code file to the / opt/ directory

3. Install the environment package

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql# specified installation path-DDEFAULT_CHARSET=utf8# specified character set support Chinese-DDEFAULT_COLLATION=utf8_general_ci# default character set-DEXTRA_CHARSETS=all# specified extended character set-DSYSCONFIDIR=/etc# specified configuration file directory-DMYSQL_DATADIR=/home/mysql/# specified data directory file-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock# definition sock file. Connect to the database file

4. Perform the make&&make install process after the environment package installation is complete

This process takes a long time, wait patiently!

5. Locate the configuration file and startup script

Give the startup script executable permissions

Declare that the CVM has Mysql service

5. Modify environment variabl

6. Create a program user

Give the user permission

7. Configuration database

8. Modify startup script

9. Modify mysql user password

10. Enter the database to view

After reading the above about how to deploy LAMP framework and install Mysql database, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.