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 ?
Copyright License：
Author:「fgtr」,Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.
Link to：https://stackoverflow.com/questions/55001813/update-mysql-5-7-to-mysql-8-0
About “Update MySQL 5.7 to MySQL 8.0” questions
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...
|
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
|
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...
|
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 ...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
|
|