groupadd mysql #添加MariaDB数据库安装用户组mysql
useradd -g mysql mysql -s /bin/false #创建用户mysql并加入到mysql组,不允许mysql用户直接登录系统
mkdir -p /data/mysql #创建MariaDB数据库存放目录
chown -R mysql:mysql /data/mysql #设置MariaDB数据库目录权限
mkdir -p /usr/local/mysql #创建MariaDB安装目录
cd /usr/local/src
tar -zxvf /home/hb/Desktop/mariadb-10.3.31-linux-x86_64.tar.gz
ln -sv /usr/local/mariadb-10.3.31-linux-x86_64/ /usr/local/mysql
cd /usr/local/mysql
cp ./support-files/my-huge.cnf /etc/my.cnf #拷贝配置文件(注意:如果/etc目录下面默认有一个my.cnf,直接覆盖即可)
vi /etc/my.cnf #编辑配置文件,在 [mysqld] 部分增加
datadir = /data/mysql #添加MariaDB数据库路径
socket = /data/mysql/mysql.sock
echo ‘修改配置文件:’
sed -ri ‘s@(^datadir=).@\1/data/mysql@’ /etc/my.cnf
sed -ri 's@(^socket=).@\1/data/mysql/mysql.sock@’ /etc/my.cnf
sed -ri ‘/datadir/a skip_name_resolve=on’ /etc/my.cnf
sed -ri ‘/datadir/a innodb_file_per_table=on’ /etc/my.cnf
echo ‘配置文件修改成功!’
chown -R root:mysql /usr/local/mysql/
cp /usr/local/mysql/support-files/mysql.server /usr/lib/systemd/system
mkdir /var/log/mariadb && echo ‘/var/log/mariadb 创建成功!’
mkdir /var/run/mariadb && echo ‘/var/run/mariadb 创建成功!’
chown mysql:mysql /var/log/mariadb
chown mysql:mysql /var/run/mariadb
echo ‘PATH=/usr/local/mysql/bin:$PATH’ > /etc/profile.d/mysql.sh && echo ‘环境变量设置成功!’
ln -s /data/mysql/mysql.sock /tmp/mysql.sock && echo ‘mysql.sock 软链接创建成功!’
./scripts/mysql_install_db --user=mysql
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #把MariaDB加入系统启动
chmod 755 /etc/init.d/mysqld #增加执行权限
chkconfig mysqld on #加入开机启动
vi /etc/rc.d/init.d/mysqld #编辑
basedir = /usr/local/mysql #MariaDB程序安装路径
datadir = /data/mysql #MariaDB数据库存放目录
service mysqld start #启动
vi /etc/profile #把MariaDB服务加入系统环境变量:在最后添加下面这一行
export PATH=$PATH:/usr/local/mysql/bin
下面这两行把MariaDB的库文件链接到系统默认的位置,这样你在编译类似PHP等软件时可以不用指定MariaDB的库文件地址。
ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
ln -s /usr/local/mysql/include/mysql /usr/include/mysql
ln -s /usr/lib64/libncurses.so.6.1 /usr/lib64/libncurses.so.5
ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
shutdown -r now
service mysqld start
更改root密码
/usr/bin/mysqladmin -u root password ‘new-password’
执行mysql,如果出现下列错误
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
执行下列语句进行解决
/usr/local/mysql/bin/mysqld_safe &