redhat6.5mysql升级5.5.48经mysql5.6.32至mysql5.7.16实行概略
发布时间：2022-04-09 02:16:39 所属栏目：MySql教程 来源：互联网
导读：redhat6.5mysql升级5.5.48经mysql5.6.32至mysql5.7.16实施概略： 1,os version redhat 6.5 2,旧版本mysql 5.5.48创建测试数据库及测试表 mysql create database zxy; Query OK, 1 row affected (0.00 sec) 3，查询旧版本MYSQL 5.5.48 DATA DIR及相关SOCKET文
|
redhat6.5mysql升级5.5.48经mysql5.6.32至mysql5.7.16实施概略： 1,os version redhat 6.5 2,旧版本mysql 5.5.48创建测试数据库及测试表 mysql> create database zxy; Query OK, 1 row affected (0.00 sec) 3，查询旧版本MYSQL 5.5.48 DATA DIR及相关SOCKET文件及PID mysql> show variables like 'datadir'; +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | datadir | /var/lib/mysql/ | +---------------+-----------------+ 1 row in set (0.00 sec) mysql> show variables like 'socket'; +---------------+---------------------------+ | Variable_name | Value | +---------------+---------------------------+ | socket | /var/lib/mysql/mysql.sock | +---------------+---------------------------+ 1 row in set (0.00 sec) 4,旧版本MYSQL 5.5.48没有使用配置文件my.cnf [root@mysqlupgrade mysql_5548_dir]# ps -ef|grep -i mysql root 6563 5378 0 16:52 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --user=root root 6643 6563 0 16:52 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=root --log-error=/var/lib/mysql/mysqlupgrade.err --pid-file=/var/lib/mysql/mysqlupgrade.pid root 6712 5378 0 17:02 pts/0 00:00:00 grep -i mysql 5, 移除旧版本mysql 5.5.48 [root@mysqlupgrade mysql_5548_dir]# rpm -qa|grep -i mysql MySQL-devel-5.5.48-1.el6.x86_64 MySQL-server-5.5.48-1.el6.x86_64 MySQL-client-5.5.48-1.el6.x86_64 [root@mysqlupgrade mysql_5548_dir]# （编辑：拼字网 - 核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐