一、准备
1、官网下载MySQL安装包:https://dev.mysql.com/downloads/mysql/
2、创建mysql用户组,用户
#进入目录
cd /usr/local/
#创建mysql文件夹
mkdir mysql
#创建data文件架
cd mysql
mkdir data
3、创建用户和用户组
#创建用户组
groupadd mysql
#创建用户
useradd -g mysql -d /usr/local/mysql mysql
二、解压缩
1、解压
tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

2、将解压完的文件移动到/usr/local/mysql
中
cd mysql-5.7.30-linux-glibc2.12-x86_64
mv * /usr/local/mysql/
三、安装配置
1、初始化数据库
./bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize
执行该命令可能会报错:
./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
如果报错就执行下面这行:
yum install -y libaio
重新执行初始化命令完成安装

2、修改配置文件和启动文件的mysql路径
- 修改my.cnf文件如下,
vi /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
port=3306
max_connections = 10000
log-bin=mysql_bin
lower_case_table_names=1
server-id=31
user=mysql
character-set-server= utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
default-character-set=utf8
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
- 修改msyql.server文件如下
vi /usr/local/mysql/support-files/msyql.server
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
3、测试是否启动成功

4、启动成功后先暂时停止

5、创建软链接
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
6、修改mysql登录密码
修改密码时需要在“Enter password”输入默认密码

7、给mysql授权
GRANT all privileges ON *.* TO 'root'@'%' identified by '123456'
flush privileges;
完成
参考:
安装:https://www.jianshu.com/p/2b63edab7f44
修改初始密码:https://blog.csdn.net/zhangyu4863/article/details/82188555
忘记密码:https://blog.csdn.net/lzb348110175/article/details/103055606
网友评论