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”
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”
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”
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?”