We are going to explain how to install and use Time zones with MariaDB on Ubuntu. Install on Ubuntu Convert to sql and import to MariaDB Time zone data are in /usr/share/zoneinfo and is found as binaries. To use Time zones with MariaDB we need to convert to sql. Now we have the zoneinfo.sql file […]
database
How to reset your root password in MariaDB?
1. The first thing to do is to stop MariaDB server 2. Start MariaDB without asking for a password 3. Connect from localhost to your server as root 4. Reload the grant tables 5. Change the root password for a new one So the password has been changed. 6. Stop the manual instance of the […]