cat<<END>> /etc/my.cnf
[mysqld]
server-id=1
port=3306
basedir=/usr/local/mysql
datadir=/data/mysql
END
mkdir -p /data/mysql
mkdir /etc/my.cnf.d
echo 'export PATH=$PATH:/usr/local/mysql/bin'>>/etc/profile
source /etc/profile
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /data/mysql
chmod 755 /usr/local/mysql -R
chmod 755 /data/mysql -R
bin/mysql_ssl_rsa_setup
bin/mysqld --initialize --user=mysql --datadir=/data/mysql/
bin/mysqld_safe --user=mysql &
mysql -uroot -p
alter user 'root'@'localhost' identified by "123456";
create user dd@'%' identified by '123456';
grant all privileges on *.* to dd@'%';
flush privileges;
mysql -udd -p
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
远程2059报错:
select user,plugin from user where user='root';
select user,plugin from user where user='dd';
加密方式都为caching_sha2_password
alter user 'dd'@'%' identified with mysql_native_password by '142857';
改加密方式为老的mysql_native_password即可远程登录
#自启
vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false
systemctl daemon-reload
systemctl start mysqld