MySQL 安装步骤
1. 下载与操作系统对应的安装包, 以RHEL6.5系统为例,选择RedHat 6 x86,64bit操作系统---下载第一个RPM Bundle即可--mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar。
2. 创建mysql用户:useradd mysql passwd mysql
3. 解压bundle.tar解压后有如下7个文件:
tar -xvf mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar
-rw-r--r-- 1 root root 28987588 Apr 9 01:06 mysql-community-client-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 672184 Apr 9 01:06 mysql-community-common-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 4443296 Apr 9 01:06 mysql-community-devel-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 2579460 Apr 9 01:06 mysql-community-libs-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 1902676 Apr 9 01:06 mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 395918848 Apr 9 01:07 mysql-community-server-8.0.11-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 49092596 Apr 9 01:07 mysql-community-test-8.0.11-1.el6.x86_64.rpm
3. 安装顺序为:(强烈建议装之前先把之前的或自带的mysql相关包全部卸载,rpm -e --nodeps <包名>即可)
rpm -ivh mysql-community-common-8.0.11-1.el6.x86_64.rpm \
rpm -ivh mysql-community-libs-8.0.11-1.el6.x86_64.rpm \
rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm \
rpm -ivh mysql-community-client-8.0.11-1.el6.x86_64.rpm \
rpm -ivh mysql-community-server-8.0.11-1.el6.x86_64.rpm \
rpm -ivh mysql-community-devel-8.0.11-1.el6.x86_64.rpm
4. 我安装时在安装devel包时报错:
pkgconfig(openssl) is needed by mysql-community-devel-8.0.17-1.el7.x86_64
需要先安装openssl: yum install openssl-devel, 然后再安装devel
5. 检查是否安装完成:
> mysql -V
mysql Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
> ll /etc/init.d/mysqld
-rwxr-xr-x 1 root root 7649 Sep 20 18:10 /etc/init.d/mysqld
> ll /etc/my.cnf
-rw-r--r-- 1 root root 1243 Sep 20 18:10 /etc/my.cnf
6. 在初始化时 在初始化时,设置 lower-case-table-names=1 表名大小写不敏感
> mysqld --initialize --user=mysql --lower-case-table-names=1
> mysqladmin -uroot -pzxLpqPeG+8<B password='oky@8833!db'
7. 启动service mysqld start
root的初始密码可在log-error=/var/log/mysqld.log中找到
在初始化时,设置 lower-case-table-names=1 表名大小写不敏感
卸载MySQL
1. 查看安装的MySQL包:
> rpm -qa|grep -i mysql
mysql-community-client-8.0.18-1.el6.x86_64
mysql-community-common-8.0.18-1.el6.x86_64
mysql-community-libs-compat-8.0.18-1.el6.x86_64
mysql-community-server-8.0.18-1.el6.x86_64
mysql-community-devel-8.0.18-1.el6.x86_64
mysql-community-libs-8.0.18-1.el6.x86_64
2. 卸载安装包:
> rpm -ev --nodeps mysql-community-libs-8.0.18-1.el6.x86_64
3. 删除mysql相关目录:
> find / -name mysql
4. 删除my.conf配置文件:
> rm -rf /etc/my.cnf
修改密码
1. 在my.cnf的 mysqld下添加 skip-grant-tables 重启服务,开启无密码验证模式
2. 登录系统, 进入use mysql数据库,
3. 修改密码(Mysql8的密码要求大小写特殊字符混合不少于8位长度):
> FLUSH PRIVILEGES;
> ALTER user 'root'@'localhost' IDENTIFIED BY 'AAA@888!db';
4. 关闭无密码验证模式