赞
踩
https://repo.huaweicloud.com/mysql/Downloads/MySQL-8.0/
https://repo.huaweicloud.com/mysql/Downloads/MySQL-8.0/mysql-8.0.23-linux-glibc2.12-x86_64.tar
mkdir -p /usr/local/mysql
下载tar包
wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-8.0/mysql-8.0.23-linux-glibc2.12-x86_64.tar
解压tar包
# tar -xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar
解压出来
mysql-router-8.0.23-linux-glibc2.12-x86_64.tar.xz
mysql-test-8.0.23-linux-glibc2.12-x86_64.tar.xz
mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz
继续解压
# xz -d mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz
# tar -xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar
mv mysql-8.0.23-linux-glibc2.12-x86_64 mysql-8.0.23
# groupadd mysql
# useradd -r -g mysql mysql
修改密码
passwd mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin
或:
将命令加入环境变量
#vim /etc/profile
MYSQL_HOME=/usr/local/mysql
export PATH=$MYSQL_HOME/bin:$PATH
# source /etc/profile
# mkdir -p /usr/local/mysql/mysql-8.0.23/data
# mkdir -p /usr/local/mysql/mysql-8.0.23/log
# mkdir -p /usr/local/mysql/mysql-8.0.23/binlog
# mkdir -p /usr/local/mysql/mysql-8.0.23/conf
# mkdir -p /usr/local/mysql/mysql-8.0.23/tmp
# chmod -R 777 /usr/local/mysql
#chown -R mysql:mysql /usr/local/mysql
vi /etc/my.cnf (注意文件的路径)
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
skip-name-resolve
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=/usr/local/mysql/mysql-8.0.23
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql//mysql-8.0.23data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# cd /usr/local/mysql/mysql-8.0.23/bin/
#./mysqld --initialize --console
vi /etc/selinux/config
#SELINUX=enforcing
SELINUX=disabled
添加mysql服务
cp support-files/mysql.server /etc/init.d/mysql
chmod 777 /etc/init.d/mysql
启动mysql服务
service mysql start
#lsof -i:3306
关闭mysql服务
service mysql stop
重启mysql服务
service mysql restart
检查自启动项列表
sysv-rc-conf --list
添加
sysv-rc-conf --add mysql
设置开机启动
sysv-rc-conf mysql on
# mysql -u root -p 回车,使用前面随机生成的密码
重置密码
mysql> set PASSWORD = '123456a';
或
mysql>alter user root@'localhost' identified by '123456a'; 立即生效的
mysql> user mysql;
mysql> create user 'root'@'%' identified by '123456a';
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456a';
mysql> flush privileges;
mysql> select host,user,plugin,authentication_string from user;
mysql> exit
查看防火墙状态
ufw status
开启防火墙
ufw enable
添加3306端口监听
ufw allow 3306
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。