mariadb编译

cd /home

unzip rpm.zip

cd /home/rpm

rpm -ivh * --force

mkfs.xfs /dev/vdb

mkdir -p /home/db/

mount /dev/vdb /home/db

echo "* soft nproc 65535">>/etc/security/limits.conf

echo "* hard nproc 65535">>/etc/security/limits.conf

echo "* soft nofile 65535">>/etc/security/limits.conf

echo "* hard nofile 65536">>/etc/security/limits.conf

useradd -m mysql

mkdir -p /usr/local/mariadb-10.3.32

chown -R mysql:mysql /usr/local/mariadb-10.3.32

chown -R mysql:mysql /home/db

mkdir -p /home/db/data

mkdir -p /home/db/tmp

chmod 777 -R /home/db/tmp

chown -R mysql:mysql /home/db/data

chmod 777 /home/db/tmp

tar -zxvf mariadb-10.3.32.tar

cd /home/mariadb-10.3.32

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb-10.3.32 -DMYSQL_DATADIR=/home/db/data -DMYSQL_UNIX_ADDR=/home/db/tmp/mysql.sock -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CONNECT_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_SEQUENCE_STORAGE_ENGINE=1 -DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DEXTRA_CHARSETS=all -DENABLE_PROFILING=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_USER=mysql -DWITH_CURL=system -DWITH_DEBUG=0 -DWITH_LIBWRAP=0 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system

make -j16

make install

cd /home

cp my.cnf /etc/

cp mariadb.service /usr/lib/systemd/system/

vim /etc/profile

//在/etc/profile最后添加两行

export MARIADB_HOME=/usr/local/mariadb-10.3.32

export PATH=$PATH:$MARIADB_HOME/bin

source /etc/profile

/usr/local/mariadb-10.3.32/scripts/mysql_install_db --user=mysql --datadir=/home/db/data

service mariadb start

按如下命令进入数据库初始数据库无密码

mysql -u root -p

修改密码：

use mysql;

// 将authentication_string 置空;

update user set authentication_string='' where user='root'; 

//123456为要修改的新密码；

alter user 'root'@'localhost' identified by '123456';   

FLUSH PRIVILEGES;

//远程登录设置

rename user 'root'@'localhost' to 'root'@'%';

flush privileges;