linux安装mysql(rpm安装方式)
文章目录
mysql安装包下载地址
https://dev.mysql.com/downloa...

- centos默认会安装mariadb所以要先卸载一下,防止出现冲突
rpm -qa | grep mariadb
卸载:rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
2.在usr/local下创建mysql目录
cd /usr/local&mkdir&&mysql
3.解压文件
tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar - 安装
rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm --nodeps --force
5.初始化
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
6.查看数据库密码
cat /var/log/mysqld.log | grep password
7.登录
mysql -uroot -p
然后输入密码
8.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'
9.远程访问授权
create user 'root'@'%'identified with mysql_native_password by '123456';
grant all privileges on . to 'root'@'%' with grant option;
(.显示有问题所以再贴个图片)
flush privileges;
10.重启mysql服务
service mysqld restart
11.开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论