mySQL

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – 2nd attempt

Leave a Comment / FreeBSD, mySQL, Open Source / By /

Yesterday, I ran my first attempt at Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – it went better than I expected. However, I spent more time with MySQL than either the data transfer or the MySQL upgrade itself. Today, that should go faster because I already know the fix and have saved the password updates. Today, I’m going to try again, and hopefully this time will be the last […]

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – 2nd attempt Read More »

ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded

Leave a Comment / FreeBSD, mySQL, Open Source / By /

Earlier today, I copied the mysq01 jail to a new mysql02. That’s all part of my migrating from 8.0 to MySQL 8.4 jail adventure. In this post: FreeBSD 14.3 MySQL 8.4.7 I hit a problem. I couldn’t log in. The password procedure has changed. [18:58 mysql02 dvl ~] % mysql -u root -p Enter password: ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded I found and used Fixing mysql_native_password is not loaded in

ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded Read More »

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail

Leave a Comment / FreeBSD, mySQL, Open Source / By /

It’s time for me to get off MySQL 8.0. It is not my database of preference, PostgreSQL is, however, I’m moving to MySQL 8.4. In this post: FreeBSD 14.3 MySQL 8.0.44 MySQL 8.4.7 The plan This is my plan, as tooted: zfs snapshot data02/jails/mysql01@mysql80 zfs clone data02/jails/mysql01@mysql80 data02/jails/mysql02 Get that mounted (it mounts automagically) modify the /etc/rc.conf entries of the new jail disable mysql_server so it doesn’t start up add a /etc/jail.conf add

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail Read More »

mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)

Leave a Comment / mySQL, Open Source / By /

This article is a copy/paste/modify of mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. See also Creating read-only PostgreSQL database users for pg_dump and pg_dumpall. I’m linking this because I use both articles on a regular basis. The error After a recent upgrade of MySQL server from 5.7.40 to 8.0.32, my database backups started encountered this error: The search Searching,

mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227) Read More »

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

Leave a Comment / Backups, FreeBSD, mySQL, Open Source / By /

See also Creating read-only PostgreSQL database users for pg_dump and pg_dumpall. I’m linking this because I use both articles on a regular basis. The error After a recent upgrade of MySQL server from 5.7.30 to 5.7.31, my database backups started encountered this error: mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces The search Searching, I found a Kanyakonil post which

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Read More »

WARNING: failed precmd routine for mysql

Leave a Comment / mySQL / By /

Last night the MySQL server instance in my dbclone jail stopped working. This is the jail into which copies of all my databases eventually go for test restores and backups. This morning I tried started it: [dan@dbclone:~] $ sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql My initial search suggested removing /var/db/mysql (this will lose all your data). Since this was a testing server, I tried it. No success. I

WARNING: failed precmd routine for mysql Read More »

InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes

2 Comments / Backups, databases, mySQL, Open Source, WordPress / By /

This blog is powered by WordPress. When I first start blogging, few had heard the term blog. I hadn’t. I recall being asked, why don’t you use blogging software for The FreeBSD Diary. The answer was simple: it didn’t exist when I started. I am making headway on converting the diary to WordPress, and that might happen before the end of the year. Today, this blog got its very own FreeBSD jail. There

InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes Read More »

Scroll to Top