How to upgrade mysql5.1 to 5.6
This article shows you how to upgrade mysql5.1 to 5.6. the content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.
Uninstall the original mysql version
Rpm-qa | grep-I mysql | xargs rpm-ev-- nodeps
Go to the official website to download the latest community version of mysql5.6
Official website address: www.mysql.com
This tar package contains many MYSQL-related installation packages, which one needs to be installed, and the unzipped package
Server-side and client-side installation of 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
After installation, rename or copy the ib* file in the / var/lib/myql directory
Upgrade the database
[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
Start the mysql process
Mysqld_safe &
The above is how to upgrade mysql5.1 to 5.6. have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.
