Showing entries 1 to 2
Displaying posts with tag: MySQL 5.7 upgrade (reset)
Webinar: Upgrade your MySQL 5.7 and older Galera Clusters to MySQL 8.0 with no downtime

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has been hardened for over three years, so it is truly time to get ready to migrate.

In our first session of the series, we are going to cover:
* the new features of Galera Cluster with MySQL 8 that you might benefit from, including what is available in Galera Cluster Enterprise Edition (EE)
* how to plan a migration from MySQL 5.7 or older to 8.0
* things to test for, before migrating
* common pitfalls of said migration
* how to ensure your Galera Cluster keeps humming along with no downtime

We also offer migration support to help you before and during your migration, after-which our regular support plan will cover …

[Read more]
5.7 Upgrade and Resolving ERROR 1130 Host ‘localhost’ is Not Allowed to Connect

I recently upgraded an instance to 5.7.3 the other day, and ran into an error, so I wanted to share the resolution for it here.

In my case, I was upgrading 5.7.1 to 5.7.3. However, this will apply to anyone wanting to upgrade from pre-5.7.2 (including 5.6/5.5) to 5.7.2+.

I performed the upgrade, in-place, and restarted mysqld. This was fine. However, then I attempted to connect via the command-line, and received the following error:

shell> mysql -uroot -ppass -P3310
ERROR 1130 (HY000): Host 'localhost' is not allowed
to connect to this MySQL server

Searching the net, you’ll mostly find RTM replies, which were all accurate as far as I could tell. In all of those prior reported cases, the issues were expected behavior and the issues were ultimately user error.

Of course I double-checked my config and data files. I knew I didn’t change anything in the user table, or any system table, for that matter. …

[Read more]
Showing entries 1 to 2