centos安装MySQL8.0.27步骤

centos安装MySQL8.0.27步骤,第1张


[mysqld]
#skip-grant-tables
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/home/mysql/mysql8027/
datadir=/home/mysql/mysql8027/data/
character_set_server=utf8mb4


./mysqld --defaults-file=/home/mysql/mysql8027/my.cnf --basedir=/home/mysql/mysql8027/ --datadir=/home/mysql/mysql8027/data/ --user=mysql --initialize

basedir="/home/mysql/mysql8027/"
datadir="/home/mysql/mysql8027/data/"

cp /home/mysql/mysql8027/support-files/mysql.server /etc/init.d/mysql

mkdir /var/log/mariadb     
touch /var/log/mariadb/mariadb.log
 

chown -R mysql:mysql /var/log/mariadb/


ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;


firewall-cmd --zone=public --add-port=3306/tcp

update user set host = '%' where user ='root'

欢迎分享,转载请注明来源:内存溢出

原文地址:https://54852.com/langs/742256.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2022-04-28
下一篇2022-04-28

发表评论

登录后才能评论

评论列表(0条)

    保存