一. 檢查是否已經(jīng)存在數(shù)據(jù)庫(kù)rpm -qa |grep mariadb
#如果已經(jīng)安裝，需要卸載mariadb數(shù)據(jù)庫(kù)
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_642
二.檢查是否安裝了 libaio
rpm -qa | grep libaio
三.初始化
mysqld? /usr/local/mysql/bin/mysqld --user=mysql
--basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
此時(shí)會(huì)生成臨時(shí)密鑰：
A temporary password is generated for root@localhost: 2KTfuVxith.h
四.配置 mysql
用mysql --help | grep 'my.cnf'命令即可查看MySQL啟動(dòng)時(shí)讀取配置文件的默認(rèn)目錄
vim? /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/tmp/mysql.sockuser=mysqlport=3306
character-set-server=utf8
riskssymbolic-links=0
log-error=/var/log/mysqld.
logpid-file=/var/run/mysqld/mysqld.pid
五讨盒、啟動(dòng)mysql
service mysql start
可能報(bào)錯(cuò)：
【MySQL】出現(xiàn)Failed to start mysql.service: Unit not found
原因
/etc/init.d中沒(méi)有mysql啟動(dòng)項(xiàng)find / -name mysql.server
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqlservice mysql start
6.登錄mysql /usr/local/mysql/bin/mysql -u root -p
修改用戶的密碼
>>use mysql （使用mysql庫(kù)）
>>update mysql.user set authentication_string=password('123456') where user='root';
>>flush privileges;
