1.下载安装rpm包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar
tar -xf mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar
2.解压后会有如下12个rpm压缩包
3.需要先删除Red Hat内置的数据库
yum -y remove mariadb-libs.x86_64
4。因为只是安装简单版的mysql,所以安装4个压缩包
rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm --(依赖于common)
rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm --(依赖于libs)
rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm --(依赖于client、common)
5、接下来是初始化数据库.
mysqld --initialize
6.这一步不能少否则执行 systemctl start mysqld.service 会报错
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql .
chgrp -R mysql . #后面的点不能少
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service // 启动mysql数据库服务7.问题:因为mysql默认数据储存在
/var/lib/mysql 所以如果该路径下有文件,就不能初始化成功
mv /var/lib/mysql/var/lib/mysql.bak 即可
mysql-u root -p //登录mysql 第一次登录系统会随机生成一个密码 在 /var/log/mysqld.log 中可以看到
euRFq*H+(0!8
6、更改mysql数据库目录的所属用户及其所属组,然后启动mysql数据库
[root@5201351 ~]# chown mysql:mysql /var/lib/mysql -R [root@5201351 ~]# systemctl start mysqld.service //启动mysql数据库服务
修改密码:
set password=password('www.cnblogs.com/5201351');7.修改数据库,允许外部访问
mysql> create user 'root'@'%' identified by '123456'; mysql> GRANT ALL PRIVILEGES ON dbname.* to 'root'@'%'; mysql> flush privileges
最后一句不能少,不然不生效
启动的 时候可能的错误解决方法:
当执行 systemctl start mysqld.service 启动失败时
出现错误,查看 /var/log/mysqld.log 日志 出现以下错误:
2017-11-10T02:36:34.988405Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-11-10T02:36:34.988418Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-11-10T02:36:34.988425Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-11-10T02:36:35.588846Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-11-10T02:36:35.588888Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-11-10T02:36:35.588896Z 0 [ERROR] Failed to initialize plugins.
2017-11-10T02:36:35.588899Z 0 [ERROR] Aborting
是英文权限问题,执行
chmod -R 777 /var/lib/mysql
增加可执行权限即可
借鉴一下文章
http://www.cnblogs.com/5201351/p/4912614.html
http://www.echojb.com/qt/2017/09/13/465015.html
http://blog.csdn.net/liyf155/article/details/61420126