“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.
If you lose the password for the MySQL/MariaDB root user, you can reset it by restarting MySQL/MariaDB in Safe Mode, which does not require a password.
First, shut down the database with the command:
- Ubuntu/Debian: MySQLsudo service mysql stop
- Ubuntu/Debian: MariaDBsudo service mariadb stop
- CentOS/Red Hat: MySQLsudo systemctl stop mysql
- CentOS/Red Hat: MariaDBsudo systemctl stop mariadb
SSL certificates from IONOS
Protect your domain and gain visitors' trust with an SSL-encrypted website!
Start MySQL/MariaDB in Safe Mode with the command:
mysqld_safe --skip-grant-tables &
You can now log in to MySQL/MariaDB as root without having to enter a password:
mysql -u root mysql
Reset the MySQL/MariaDB password with the following command. Change my-new-password to a secure password.
UPDATE user SET password=PASSWORD("my-new-password") WHERE user='root';
Reload the privilege tables:
Exit the MySQL/MariaDB client:
Shut down MySQL/MariaDB:
mysqladmin -u root -p shutdown
You will need to enter the password for root which you set in the previous step.
Finally, restart the database in normal mode:
- Ubuntu/Debian: MySQLsudo service mysql start
- Ubuntu/Debian: MariaDBsudo service mariadb start
- CentOS/Red Hat: MySQLsudo systemctl start mysql
- CentOS/Red Hat: MariaDBsudo systemctl start mariadb
Buy one .com, get one .us free!
Register a .com now and get a free first-year .us domain.
Don't miss out — sale ends on July 31st.