1.下载安装包
下载地址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads
2.上传至服务器并解压
tar -xvf mysql-5.7.36-linux-glibc2.12-x86_64.tar
3.移动并重命名
mv mysql-5.7.36-linux-glibc2.12-x86_64 /usr/local/mysql
4.创建data目录
mkdir /usr/local/mysql/data
5.创建mysql用户组和用户并修改权限
groupadd mysql
useradd -r -g mysql mysql
6.创建数据目录并赋予权限
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
7.配置my.cnf
打开配置
vi /etc.my.cnf[mysqld]
bind-address = 0.0.0.0
port = 3306
skip-name-resolve
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
explicit_defaults_for_timestamp=true
8.初始化mysql
cd /usr/local/mysql/bin/
初始化
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
记住密码记住密码!!
报错的话安装libaio1库
sudo apt-get install libaio1
9. 查看密码
实际根据自己路径
cat /data/mysql.err
10.启动mysql
cd /usr/local/mysql/support-files./mysql.server start
11.修改密码
cd /usr/local/mysql/bin
./mysql -u root -p注意:若登录报错
yum install libncurses*
,完美解决问题。
执行下面三步操作,可直接复制
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
12.远程连接
需要先登录mysql,下面命令可直接复制
use mysql
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
13.安装完成!!!