How to Reset MySQL or MariaDB Root Password
This post shows students and new users steps to reset or change MySQL or MariaDB passwords when using Ubuntu Linux. One can create and reset the...
MySQL
How to Install MySQL or MariaDB on Ubuntu Linux
This post shows students and new users the steps to install MySQL or MariaDB on Ubuntu Linux. MariaDB and MySQL are twins. Both MySQL and MariaDB...
How to Check MySQL Version in Ubuntu Linux
This brief tutorial shows students and new users how to check MySQL | MariaDB server versions in Ubuntu Linux. How do you know which versions of...
How to Setup Self Signed SSL/TLS on MySQL
This brief tutorial shows students and new users how to enable self-signed SSL/TLS certificates and connect to MySQL Server via SSL connection on Ubuntu Linux 20.04...
How to Allow Remote Access to MySQL Database on Ubuntu Linux
This brief tutorial shows students and new users how to configure remote access connections to Oracle MySQL database servers on Ubuntu 18.04 systems. Our previous tutorial...
How to Change MySQL or MariaDB User Passwords on Ubuntu Linux
There may be a time when you want to change a database user password. Some reasons for changing MySQL or MariaDB database user passwords might be...
How to Delete MySQL Database and User on Ubuntu Linux
Sometimes you may want to drop or delete old databases and user accounts on MySQL (MariaDB) server. When running a website powered by WordPress or another...
How to Switch from MySQL to MariaDB Database Server on Ubuntu Linux
As you may well know, the MariaDB database server is rapidly gaining traction and has become the default server on the majority of Linux systems, including...
How to Backup MySQL Databases with AutoMySQLBackup on Ubuntu
AutoMySQLBackup is a free open-source tool that automatically backs up all the databases hosted on a MySQL server at varying intervals. It’s a great tool that...
How to Convert from MySQL to MariaDB on Ubuntu 17.04
This post is intended to help students and new users switch from the MySQL database server to the MariaDB database server in Ubuntu 17.04. This should...
How to Import and Export MySQL Databases
Students and new webmasters should learn how to export and import MySQL or MariaDB databases. For those managing a WordPress website and thinking of migrating to a...
How to Optimize and Repair MySQL Databases
MySQL check is a tool that gets installed along with installing MySQL database servers. It’s there to help analyze and fix common errors as well as...