The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to the Server.
Not the Server root user
A common issue is confusing the Server root user with the MySQL root user. Continue reading “Reset a lost MySQL root password”
service mysqld stop
rm -rf /var/lib/mysql/XXXXX
service mysqld start
Where XXXXX is the offending database name.
To view a list of databases simply issue the following command:
SHOW DATABASES;
Pre-Flight Check
These instructions are intended for deleting a MySQL database on Linux via the command line.
I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
First we’ll login to the MySQL server from the command line with the following command:
mysql -u root -p
Continue reading “Delete a MySQL Database on Linux”