https://blog.csdn.net/wudinaniya/article/details/81094578
使用命令rpm -ivh {-file-name}进行安装操作。
按照依赖关系依次安装rpm包 依赖关系依次为common→libs→client→server
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
[root@nfs_client tools]# rpm -qa|grep mysql
[root@nfs_client tools]# yum remove mysql-libs
修改data目录和权限:
cat /etc/my.cnf
命令:
systemctl start mysqld.service 启动mysql
systemctl status mysqld.service 查看mysql状态
systemctl stop mysqld.service 关闭mysql
修改密码:
grep ‘temporary password’ /var/log/mysqld.log
mysql> alter user root@localhost identified by ‘sdbrk’;
远程:
use mysql;
GRANT ALL PRIVILEGES ON . TO’your username’@’%’ IDENTIFIED BY ‘your password’ WITH GRANT OPTION;
FLUSH PRIVILEGES ;
数据目录切换参考:
1、通过rpm -e --nodeps xxx 卸载掉server,
2>卸载后查看 /etc/my.cnf 中,修改datadir的配置情况,
3>最后通过命令rpm -ivh xxx 重新安装server,此时就能正常使用mysql了
命令代码如下:
[root@izbp1845cet96se1qmb5ekz ~]# rpm -e --nodeps mysql-community-server-5.7.22-1.el7.x86_64
[root@izbp1845cet96se1qmb5ekz ~]# cat /etc/my.cnf
xxxxxxxxxxxxx
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
xxxxxxxxxxxxxxx
[root@izbp1845cet96se1qmb5ekz ~]# cd /var/lib
[root@izbp1845cet96se1qmb5ekz lib]# rm -rf mysql
[root@izbp1845cet96se1qmb5ekz ~]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
[root@izbp1845cet96se1qmb5ekz ~]# systemctl start mysqld.service
[root@izbp1845cet96se1qmb5ekz ~]# ps -ef|grep mysql
root 3306 1068 0 14:34 pts/0 00:00:00 mysql -uroot -p
mysql 27009 1 1 15:26 ? 00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
root 27038 26239 0 15:27 pts/6 00:00:00 grep --color=auto mysql