Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.