bookmark_borderCreate MySql Database Backup in Linux Using MariaDB

If you need to do a MySQL database backup in linux, this is the basic command structure you want to use:

# mysqldump -u [username] -p [database name] > [filename]-$(date +%F).sql

This will prompt the password when you hit enter.

Continue reading “Create MySql Database Backup in Linux Using MariaDB”

bookmark_borderMySQL – ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

If you run into this error it’s a strong indicator that the Password Validation Plugin is installed.

The quick and dirty way to fix this is to uninstall the plugin. You will need to be the root user in the database.

Continue reading “MySQL – ERROR 1819 (HY000): Your password does not satisfy the current policy requirements”

bookmark_borderSetting Root Password on MySql when it’s Empty

I was working on one of my servers when I realized that I had done a bone-head mistake. I left the root password blank in MySQl. 

It was not as easy as I thought to fix the problem. There were a couple of things I didn’t account for, specifically that when you’re initially setting up MySQL on Ubuntu and don’t provide a password to the root user, it will use the auth_socket plugin. That plugin doesn’t care and doesn’t need a password. It just checks if the user is connecting using a UNIX socket and then compares the username.

Continue reading “Setting Root Password on MySql when it’s Empty”

bookmark_borderHow do you show and update a MySQL database in a linux terminal?

This post will walk you through the process of showing and updating a MySQL database via terminal.

We’ll use a WordPress installation because it has an established database schema. The principles apply to any database.

Continue reading “How do you show and update a MySQL database in a linux terminal?”