Fast and easy!
$ sudo stop mysql
$ sudo -umysql mysqld_safe --skip-grant-tables &
$ mysql
mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
$ sudo kill `cat /var/run/mysqld/mysqld.pid`
$ sudo start mysql
Enjoy your new mysql root password!
Sometimes it can be useful to completely drop all tables in a database, for example to reset a DB to a previous version from a backup. After checking that you are doing this on the right database and that you know what you are doing, you can do this: SET …
Read more...
In this post I will show you a simple method to perform a MySQL incremental backup. This method is quite effective for small and medium databases.
Read more...
Did your MySQL database got corrupted? Don't you have a recent backup? In this post I'll present three simple methods to restore your data.
Read more...
Freelance developer and sysadmin
This website uses cookies. More info in the privacy policy.