Update MySQL 5.7 to MySQL 8.0
NickName:fgtr Ask DateTime:2019-03-05T19:30:59

Update MySQL 5.7 to MySQL 8.0

I just updated my MySQL 5.7 database to MySQL 8.0

The MySQL documentation says :

The MySQL server always restarts after an update by APT. Prior to MySQL 8.0.16, run mysql_upgrade after the server restarts to check and possibly resolve any incompatibilities between the old data and the upgraded software. mysql_upgrade also performs other functions; see mysql_upgrade — Check and Upgrade MySQL Tables for details. As of MySQL 8.0.16, this step is not required, as the server performs all tasks previously handled by mysql_upgrade.

https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html

If I connect to MySQL and type the command :

mysql_upgrade

It displays :

->

Nothing happens, why ?

enter image description here

Copyright Notice:Content Author:「fgtr」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/55001813/update-mysql-5-7-to-mysql-8-0

More about “Update MySQL 5.7 to MySQL 8.0” related questions

Update MySQL 5.7 to MySQL 8.0

I just updated my MySQL 5.7 database to MySQL 8.0 The MySQL documentation says : The MySQL server always restarts after an update by APT. Prior to MySQL 8.0.16, run mysql_upgrade after the se...

Show Detail

How do I update MySQL 5.7 to the new MySQL 8.0?

How do I update to MySQL 8.0 from the default version (5.7)? It's important for me for it to make an update and not re-install MySQL so all my data won't be corrupt. There is not a lot of info

Show Detail

Different behavior with MySQL 5.7 and 8.0

I'm trying to use MySQL 8.0 but I'm having some problems. I have installed MySQL 5.7 and 8.0, and have different behavior with CHAR columns. For MySQL 5.7: mysql> create table test (id integer...

Show Detail

MySQL Upgrade 5.7 to 8.0 Failing to Start Service

I am trying to upgrade MySQL 5.7 to 8.0 . The process me following is I am taking Backup of Data Directory of MySQL 5.7 and then using same Data Directory of MySQL 5.7 for Upgrading to 8.0 , while ...

Show Detail

Cannot import Mysql 5.7 dump with Chinese varchar(128) in Mysql 8.0

My Mysql5.7 database contains a restaurant menu with Chinese characters. I want to update to a newer Linux with a new database. This year I tried several times to update for Ubuntu 20 and MySQL 8.0...

Show Detail

How to switch from mysql 5.7 to 8.0 in Ubuntu 20.04?

I have mysql 5.7 and 8.0 installed. When I run dpkg -i mysql-apt-config_0.8.23-1_all.deb It shows me mysql 8.0 (SS below). This seems to indicate that I am on mysql 8.0. But, When I login to my lo...

Show Detail

Upgrade thousand for mysql 5.7 databases to latest 8.0 version

We are having thousands of mysql databases (v 5.7) and want to upgrade to latest v8.0. We have configured new mysql on same sarver with diff port (say 3307). we tried multiple steps Replacing mysq...

Show Detail

How can I convert mysql 8.0 to 5.7?

I have a WordPress project using MySql 8.0 and tried this project in localhost. Now when I try to throw it to server it gives mysql version error. Is this a database made with 8.0 or how can I conv...

Show Detail

How do I import data from a mysql 5.7 docker container into a mysql 8.0 docker container?

Currently my database is stored on a Mysql 5.7 docker container, now I have created a new Mysql 8.0 container, I want to export the contents of the database in the Mysql 5.7 docker container and im...

Show Detail

mySQL compatible string crypting between mySQL 5.7 and 8.0

I have an old php project written to save data on dbase with mySQL 5.7 and to save the password it use DES_ENCRYPT (). CREATE TABLE IF NOT EXISTS `t` ( `q` varchar(257) NOT NULL ) ENGINE=MyISAM D...

Show Detail