mySQL

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 …

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 …

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 …

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 …

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

Killing spammers

1 Comment / mySQL, WordPress / By /

I found this special idea about banning spammers: echo “select comment_author_IP from wp_comments where comment_approved = ‘spam'” | \ mysql –skip-column-names -u root wordpress_danlangilleorg | \ xargs -n 1 -J % sudo pfctl -t idiots -T add % Anyone care to explain how this works?

Scroll to Top