Centos 7 binary installation and configuration MariaDB database

Since each company’s database server version is different, I still recommend everyone to use the Mariadb database. At least for now, the community and products are very stable. As for any new features, it is recommended to go to its official website to learn more about the features.

View system version command

$ cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core) x64

Install MariaDB (MySQL)

Download the MariaDB binary installation package:

https://downloads.mariadb.org
解压并安装 Mariadb-devel 静态库：

$ yum install mariadb-devel numactl -y
$ mkdir /renwole
$ cd /renwole
$ tar zxvf mariadb-10.2.8-linux-glibc_214-x86_64.tar.gz
移动目录并创建软连接：

$ mv mariadb-10.2.8-linux-glibc_214-x86_64 /usr/local
$ cd /usr/local
$ ln -s mariadb-10.2.8-linux-glibc_214-x86_64 mysql
创建 MariaDB（MySQL）用户和组

$ groupadd mysql
$ useradd -g mysql mysql
赋予 MariaDB（MySQL）目录权限：

$ cd /usr/local/mysql
$ chown -R root .
$ chown -R mysql data

Configuring MariaDB (MySQL)

Delete the built-in my.cnf configuration file and create a new configuration file:

$ rm -rf /etc/my.cnf
$ cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf

Note: There are 5 configuration files under /usr/local/mysql/support-files. Please select the configuration file according to the memory size of the server (you can also customize and optimize the my.cnf configuration file. If you have it before, as long as it is the same The version can be used normally, so there is no need to create it again. When MariaDB (MySQL) starts, it will automatically look for the my.cnf file in /etc).

The files are:

my-small.ini （内存 
<pre class="brush:php;toolbar:false">
$ vim /etc/my.cnf

datadir = /usr/local/mysql/data

Note: This path is used to initialize the database. In the future, your database will exist in this directory. This storage path can be changed to other paths to avoid unnecessary losses caused by future system downtime, so please change it according to your own needs. For relative paths, don’t forget to give permissions.

Initialize database

$ cd /usr/local/mysql/scripts
$ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

$ cd /usr/local/mysql/support-files
$ cp mysql.server /etc/init.d/mysql
$ chmod +x /etc/init.d/mysql
$ systemctl enable mysql

添加系统变量，例如直接输入：mysql -uroot -p 会提示无此命令：

$ vim /etc/profile
在文件末端添加以下内容：

PATH=$PATH:/usr/local/mysql/bin
export PATH
使变量立即生效并启动Mysql数据库：

$ source /etc/profile
$ systemctl restart mysql
$ ss -antp

Initialize MariaDB (MySQL) security account

$ /usr/local/mysql/bin/mysql_secure_installation

Note: Press Enter to prompt you to enter the MariaDB (MySQL) password. The newly installed mysql password is empty by default, so just press Enter, then enter Y to set the MySQL password. Enter twice and press Enter. Then press Y all the way ( The general meaning is to delete the test database, anonymous account, and finally the Y configuration takes effect

.

The above is the detailed content of Centos 7 binary installation and configuration MariaDB database. For more information, please follow other related articles on the PHP Chinese website!