
[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'
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)