鏈接:https://blog.csdn.net/kunpeng_mubao/article/details/106698987
數(shù)據(jù)庫安裝:
下載:wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
文件較大秀鞭,云服務(wù)器下行帶寬不夠度陆,可以本地下載上傳至服務(wù)器
rpm -e mariadb-libs --nodeps
mkdir mysql?
cd?mysql
tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm --nodeps --force
yum install -y numactl
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl enable mysqld
systemctl start mysqld.service
?初始隨機(jī)密碼登錄会钝,local密碼重新設(shè)置:
cat /var/log/mysqld.log | grep password 查詢初始密碼?????
mysql -uroot -p 初始隨機(jī)密碼登錄
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '本地登錄密碼'';
遠(yuǎn)程密碼登錄設(shè)置:
local的新密碼重新登錄:mysql -uroot -p?
create user 'root'@'%' identified with mysql_native_password by '遠(yuǎn)程登錄密碼';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;