华为云 linux下安装mysql

下载

MySQL :: Download MySQL Community Server

 创建目录并解压

#创建目录
mkdir /usr/local/mysql
 
#解压文件并重命名
tar -zxvf mysql-8.0.33-linux-glibc2.28-x86_64.tar.gz
mv mysql-8.0.33-linux-glibc2.28-x86_64 mysql-8.0.33

添加mysql用户及对应的组　

#添加用户组
groupadd mysql
 
#useradd -r参数表示mysql用户是系统用户，不可用于登录系统
useradd -r -g mysql mysql
 
#创建data目录
mkdir /usr/local/mysql/data
 
#将/usr/local/mysql/的所有者及所属组改为mysql
chown -R mysql.mysql /usr/local/mysql/

创建配置文件

vim /etc/my.cnf

[mysqld]
## 基础位置
basedir = /usr/local/mysql/mysql-5.7.38
## 数据存放位置
datadir = /usr/local/mysql/data
## 端口
port = 3306
 
socket = /tmp/mysql.sock
## 字符集
character-set-server=utf8
 
log-error = /usr/local/mysql/data/mysqld.log
pid-file = /usr/local/mysql/data/mysqld.pid

　进行初始化

/usr/local/mysql/mysql-8.0.33/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-8.0.33 --datadir=/usr/local/mysql/data/
 
#在日志文件中找到密码方便以后登录和改密
cat /usr/local/mysql/data/mysqld.log

 执行启动命令

/usr/local/mysql/mysql-8.0.33/support-files/mysql.server start

 添加全局mysql环境变量

echo 'export PATH="$PATH:/usr/local/mysql/mysql-8.0.33/bin"' >> /etc/profile
source /etc/profile

　　

登录并修改密码

mysql -u root -p

若：报错./mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

## 安装依赖之后重试可以登录

yum install -y ncurses-compat-libs

 

## 重置密码
mysql> alter user 'root'@'localhost' identified by '123456';
## 分配远程访问权限
mysql> grant all privileges on *.* to root@'%' identified by '123456';
## 刷新权限
mysql> flush privileges;
# 退出登录
mysql> exit;

设置机器启动时候自动启动mysql

## 复制到自启动路径下
## cp /usr/local/mysql/mysql-8.0.33/support-files/mysql.server /etc/init.d/mysqld
 
##  显示服务列表
chkconfig --list
 
## 添加服务
chkconfig --add mysqld
 
##  重新查看显示服务列表
chkconfig --list

## 如果是关闭的话，使用下面命令将其开启
chkconfig --level 345 mysqld on