文章目录
基于mysql5.7的二进制安装
解压,创建帐号,创建软链接,配置环境变量
tar xvf mysql-5.7.26-el7-x86_64.tar.gz -C /usr/local
useradd -r -s /bin/false mysql
cd /usr/local/
ln -s mysql-5.7.26-el7-x86_64/ mysql
echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
. /etc/profile.d/mysql.sh
mkdir /data/mysql
chown -R mysql.mysql /data/mysql
生成数据库
-- 生成数据库
mysqld --initialize --user=mysql --datadir=/data/mysql
2020-01-28T11:24:15.118135Z 1 [Note] A temporary password is generated for root@localhost: fxqmrX<+q5Zd //密码
配置文件
vim /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/data/mysql/mysql.log
pid-file=/data/mysql//mysql.pid
[client]
socket=/data/mysql/mysql.sock
启动脚本
cp support-files/mysql.server /etc/init.d/mysqld
开机启动
chkconfig --add mysqld
修改密码
mysqladmin -uroot -p'fxqmrX<+q5Zd' password centos
密码字段
-- 密码字段为 authentication_string
mysql> select user,host,authentication_string from mysql.user;
+---------------+-----------+-------------------------------------------+
| user | host | authentication_string |
+---------------+-----------+-------------------------------------------+
| root | localhost | *128977E278358FF80A246B5046F51043A2B1FCED |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+---------------+-----------+-------------------------------------------+