How to install mysql database on the server

Server installation mysql database

With the continuous development of Internet technology, the database has become an indispensable part of enterprise information construction. As an excellent relational database management system, MySQL has the advantages of stability, efficiency, and ease of use in Web application development, data backup, etc., so it has become the first choice of many enterprises. This article will start from the perspective of installing the mysql database and introduce how to install the mysql database on the Linux server.

1. Environment preparation

Before installing MySQL, please make sure you have installed the SSH client tool. If it is not installed, please install an SSH client first. You can use common SSH clients such as XShell and Putty.

And prepare the server IP address, username and password needed to access the MySQL database.

2. Download and install

1. Download MySQL

Go to the official website (http://www.mysql.com/) to download the MySQL installation package, or use the command line Download:

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.21.tar.gz

2. Unzip the installation package

tar xvf mysql-8.0.21.tar.gz

3. Enter the decompression directory

cd mysql-8.0.21

4. Create a user

Create system users and user groups used by MySQL. It should be noted here that the users and user groups used by MySQL must be the users and user groups specified when adding the MySQL service.

groupadd mysql
useradd -r -g mysql mysql

5. Install dependency packages

yum install gcc gcc-c ncurses-devel cmake make perl bison-devel openssl-devel

6. Generate Makefile

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
- DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_HEAP_STORAGE_ENGINE=1 \
-D WITH_MYISAM_STORAGE_ENGINE= 1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=complex \
-DWITH_READLINE=1 \
-DWITH_ZLIB=system \
-DWITH_SSL=system \
-DWITH_LIBWRAP=0 \
-DMYSQL_TCP_PORT=3306 \
-DCOMPILATION_COMMENT="MySQL Server 8.0.21" \
-DENABLED_LOCAL_INFILE=1 \
-DBUILD_CONFIG=mysql_release \
- DCMAKE_EXPORT_COMPILE_COMMANDS=1 \
-DENABLE_DTRACE=0 \
-DWITH_DEBUG=0 \
-DDOWNLOAD_BOOST=1 \
-DDOWNLOAD_BOOST_TIMEOUT=3000 \
-DDOWNLOAD_DTRACE=1 \
-DDOWNLOAD_LIBEVENT= 1 \
-DDOWNLOAD_LIBUV=1 \
-DDOWNLOAD_CURL=1 \
-DDOWNLOAD_ICU=1 \
-DDOWNLOAD_GOOGLETEST=1 \
-DDOWNLOAD_YASSL=0

7. Compile And install

make && make install

8.Initialization

Enter the MySQL installation directory and perform initialization operations.

cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

The execution result will prompt you for the initialization password of the root user. Please be sure to change this password after formal deployment.

9. Start MySQL

Start the MySQL service.

bin/mysqld_safe --user=mysql &

The MySQL service has been installed and started at this time.

3. Set up MySQL

1. Set the root password

Change the root initial password to a safe and reliable password.

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';

2. Set remote connection permissions

The default configuration of MySQL is to only allow local connections. If remote access is required, the MySQL configuration file needs to be modified.

mysql -u root -p
grant all privileges on . to 'root'@'%' identified by 'your_password' with grant option;
flush privileges;

3. Enable remote access

Modify the configuration file /etc/my.cnf and add the following content under the [mysqld] section:

skip-networking=false
bind-address=0.0.0.0
port=3306

At this point, we have completed the installation and setup of MySQL.

4. Summary

Through the introduction of this article, I believe that everyone has been able to master how to install the MySQL database on the Linux server, and perform basic settings on it to enable remote access. MySQL is powerful and is one of the most commonly used databases in web development. Mastering the installation and use of MySQL will bring great convenience to everyone in future development work.

The above is the detailed content of How to install mysql database on the server. For more information, please follow other related articles on the PHP Chinese website!