CentOS7.6安装MYSQL8.0的步骤详解
16lz
2021-12-20
1、一般CentOS默认安装了mariadb,所以先查看是否安装mariadb,如果安装就需要先卸载mariadb
rpm -qa|grep mariadbrpm -e mariadb-libs --nodeps
cd /cd usr/localmkdir mysql
cd mysqlwget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm --nodeps --forcerpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm --nodeps --force
mysqld --initialize; chown mysql:mysql /var/lib/mysql -R;systemctl start mysqld.service;systemctl enable mysqld;
如果执行systemctl start mysqld.service; 出现以下报错,先执行tail -f /var/log/mysqld.log查看错误日志
如果错误日志如下,执行cd /var/lib/mysql,执行rm -rf *删除所有文件,再执行systemctl start mysqld.service;
7、查看数据库初始化密码
cat /var/log/mysqld.log | grep password
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxxx';
exit; mysql -uroot -p
create user 'root'@'%' identified with mysql_native_password by 'xxxxx';grant all privileges on *.* to 'root'@'%' with grant option;flush privileges;
总结
更多相关文章
- MySQL系列多表连接查询92及99语法示例详解教程
- 发现 developer.android.com 官网的一个单词错误:
- 背部如何画好?动漫人物背部画法步骤
- Android(安卓)- Manifest 文件 详解
- Android的Handler机制详解3_Looper.looper()不会卡死主线程
- Selector、shape详解(一)
- android2.2资源文件详解4--menu文件夹下的菜单定义
- android 命令(adb shell)进入指定模拟器或设备
- Android--WebView+HTML+Javascript