mysql5.1如何提升到5.6

本篇文章为大家展示了mysql5.1怎样升级到5.6，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

卸载原有mysql版本

rpm -qa | grep -i mysql | xargs rpm -ev --nodeps

这个tar包里含有许多与MYSQL相关的安装包，需要哪个安装哪个,解压之后的包

安装mysql的服务器端和客户端

rpm -ivh mysql-server-5.6.35-1.el6.x86-64.rpm

rpm -ivh mysql-client-5.6.35-1.el6.x86_64.rpm

安装完之后，将/var/lib/myql目录下的ib*文件重命名或拷贝出来。

升级数据库

[root@msl3 ~]# mysql_upgrade --protocol=tcp -P3306 -p

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck' with connection arguments: '--protocol=tcp' '--port=3306'

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck' with connection arguments: '--protocol=tcp' '--port=3306'

Warning: Using a password on the command line interface can be insecure.

mysql.columns_priv                 

mysql.db                      

mysql.event                    

mysql.func                     

mysql.general_log               

mysql.help_category                 

mysql.help_keyword                 

mysql.help_relation                 

mysql.help_topic                  

mysql.host                     

mysql.ndb_binlog_index               

mysql.plugin                    

mysql.proc                     

mysql.procs_priv                  

mysql.servers                   

mysql.slow_log                   

mysql.tables_priv                  

mysql.time_zone                  

mysql.time_zone_leap_second             

mysql.time_zone_name                

mysql.time_zone_transition             

mysql.time_zone_transition_type          

mysql.user                     

Running 'mysql_fix_privilege_tables'...

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck' with connection arguments: '--protocol=tcp' '--port=3306'

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck' with connection arguments: '--protocol=tcp' '--port=3306'

Warning: Using a password on the command line interface can be insecure.

OK

启动mysql进程

mysqld_safe &

上述内容就是mysql5.1怎样升级到5.6，你们学到知识或技能了吗？

（编辑：银川站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!