linux 安装 mysql
1下载mysql压缩文件
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
2解压文件
创建文件夹 mkdir /usr/software 名字随便起 最好是在usr目录下面创建文件夹 在新建的文件夹里面解压
解压命令:tar -zxvf filename
重命名:mv mysql-5.7.21-linux-glibc2.12-x86_64 /usr/software/mysql
3创建mysql用户组和用户并修改权限
命令:groupadd mysql
命令:useradd -r -g mysql mysql
4创建数据目录并赋予权限
命令:mkdir -p /data/mysql 递归创建目录,即使上级目录不存在,会按目录层级自动创建目录
命令:chmod -R 777 /data/mysql 递归赋予权限
5配置my.cnf
命令: vim etc/my.cnf
没有的添加上
basedir=/usr/software/mysql 安装mysql的文件的路径
socket=/var/lib/mysql/mysql.sock 重要
# 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
# skip-grant-tables 重置密码的时候打开
port=3306
user=mysql
bind-address=0.0.0.0
[mysqld_safe]
log-error=/data/mysql/mysql.err 生成日志
pid-file=/data/mysql/mysql.pid 重要
# include all files from the config directory
!includedir /etc/my.cnf.d
6初始化数据库
命令 :cd/usr/software/mysql/bin里面
命令 :./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/software/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
我第一次出现错误:如下
下面这个是错误:意思缺少一个包
./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
如果出现这样
命令:yum install -y libaio
```java
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
base | 3.6 kB 00:00:00
epel | 4.7 kB 00:00:00
extras | 2.9 kB 00:00:00
updates | 2.9 kB 00:00:00
(1/3): epel/x86_64/updateinfo | 1.0 MB 00:00:00
(2/3