linux mysql 5.7.28 安装
1.官网下载5.7.28 tar包
2.上传到服务器并tar命令解压(我本人linux的目录为/usr/local/mysql,两个文件夹mysql-5.7.28和data)
tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
3.把解压后的mysql目录重命名简短一点
mv mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz mysql-5.7.28
4.添加系统mysql组和mysql用户
groupadd mysql useradd -r -g mysql mysql
5.修改解压后的mysql目录权限
chown -R mysql:mysql /usr/local/mysql/mysql-5.7.28
6.创建mysql数据仓库目录:
mkdir /usr/local/mysql/data
7.修改data的权限
chown -R root:root chown -R mysql:mysql
8.修改mysql的数据库数据默认位置vi /etc/my.cnf,修改后内容如下(注意修改datadir跟socket的值)
[mysqld] datadir=/usr/local/mysql/data basedir=/usr/local/mysql/mysql-5.7.28 socket=/usr/local/mysql/data/mysql.sock user=mysql port=3306 character-set-server=utf8 symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket = /usr/local/mysql/data/mysql.sock
9.初始化数据库
/usr/local/mysql/mysql-5.7.28/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-5.7.28 --datadir=/usr/local/mysql/data
##以上命令输入后,控制台会打印如下:其中uvq:#Beqq2*<为密码 2019-12-04T14:59:39.267988Z 1 [Note] A temporary password is generated for root@localhost: uvq:#Beqq2*<
10.添加启动服务
cp /usr/local/mysql/mysql-5.7.28/support-files/mysql.server /etc/init.d/mysql
11.启动/关闭服务
##启动
service mysql start
##停止
service mysql stop
##查看状态
service mysql status
12.修改root密码
bin/mysqladmin -uroot -p'uvq:#Beqq2*<' password