文章目录
1. 安装 mysql
-
查看 mysql 是否安装,如果安装了,卸载 mysql
[dwjf321@hadoop102 mysql-libs]$ rpm -qa|grep mysql mysql-libs-5.1.73-7.el6.x86_64
-
卸载 mysql
[dwjf321@hadoop102 mysql-libs]$ rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64
-
下载 mysql 8 的 repo 源
wget http://repo.mysql.com/mysql80-community-release-sles12-7.noarch.rpm
-
安装
mysql80-community-release-sles12-7.noarch.rpm
包[dwjf321@hadoop102 mysql-libs]$ sudo rpm -ivh mysql80-community-release-sles12-7.noarch.rpm [sudo] dwjf321 的密码: 准备中... ################################# [100%] 正在升级/安装... 1:mysql-community-release-el7-5 ################################# [100%]
-
安装 mysql
[dwjf321@hadoop102 mysql-libs]$ sudo yum install mysql-server
2. 重置密码
运行如下命令进入 mysql:
[dwjf321@hadoop102 mysql-libs]$ mysql -u root
提示:ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
修改权限:
[dwjf321@hadoop102 mysql-libs]$ sudo chown -R openscanner:openscanner /var/lib/mysql
重启:
[dwjf321@hadoop102 mysql-libs]$ service mysqld restart
重新运行
[dwjf321@hadoop102 mysql-libs]$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.50 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
修改密码:
--切换 mysql 数据库
mysql > use mysql;
--修改 root 用户密码
mysql > update user set password=password("123456") where user="root";
--修改默认 localhost 访问权限为所有
mysql > update user set host='%' where host='localhost';
--刷新
mysql > flush privileges;
--退出
mysql > exit;
参考地址:https://blog.csdn.net/weixin_45190065/article/details/125999898