一、卸载Mysql
- 查看系统是否安装默认的mysql
#rpm -qa |grep -i mysql
- 如有,进行卸操作
#rpm -e --nodeps
- 确认是否卸载完成
#whereis mysql
#cd / ;find / -name mysql
#cat /etc/passwd | grep mysql
#cat /etc/shadow | grep mysql
#cat /etc/group | grep mysql
#userdel mysql
#groupdel mysql
二、安装MySql
2.1下载mysql
下载网址:https://dev.mysql.com/downloads/
2.2安装mysql
#tar -xvf mysql-5.7.34-1.el7.x86_64.rpm-bundle.tar
#rpm -ivh mysql*.rpm
- 安装提示报错:
- 解决方案:
#yum remove mariadb-libs
#yum -y install perl-Data-Dumper
#yum -y install perl-JSON
- 再次执行:
#rpm -ivh mysql*.rpm
2.3启动mysql数据库
#service mysqld start
2.3.1设置root密码:
- 查看随机密码:
#cat /var/log/mysqld.log |grep password
或
#grep 'temporary password' /var/log/mysqld.log
- 登录mysql数据库:
#mysql -uroot -p
使用得到的随机密码登录(复制生成的随机密码)
- 设置root密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD';
2.3.2配置工具连数据库:
错误代码是1130,ERROR 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server
解决方案:
#mysql -u root -p
mysql> use mysql;
mysql> select host from user where user='root';
mysql> update user set host = '%' where user ='root';
mysql> flush privileges;
mysql> select host from user where user='root';
三、MySql日志
/var/log/mysqld_err.log
4.1. 修改默认端口
4.1.1修改/etc/my.cnf
#vi /etc/my.cnf
增加一行:port=6379
4.1.2重新启动mysql
#service mysqld restart
4.2修改数据库存储路径
4.2.1创建要新的数据库文件目录
# mkdir -m 755 /mysqldata
#chown -R mysql:mysql /mysqldata
4.2.2复制原数据目录至新目录
#cd /var/lib/
#cp -a mysql/ /mysqldata
4.2.3修改/etc/my.cnf
将datadir=/var/lib/mysql
改成:
datadir=/mysqldata/mysql
4.2.4重新启动mysql
#service mysqld restart
五、忘记root密码
5.1设置登录无需验证密码
#service mysqld stop
#vi /etc/my.cnf
新增一行
skip-grant-tables
#service mysqld start
#mysql -u root
mysql> use mysql;
mysql> update user set authentication_string=password('password') where user='root' and host= 'localhost';
mysql> select * from user where user='root' and Host= 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
#vi /etc/my.cnf
注释掉行
#skip-grant-tables
#service mysqld restart
#mysql -uroot -p
Enter password:
5.2重置root密码
- 解决办法:
set password for 'root'@'localhost'=PASSWORD('newpassword');