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 new host or will be making changes to their sites, then learning to export and import these databases is a great skill to have. One good habit to keep […]
MariaDB Database
Lesson 59: How to Install and Use MariaDB Database Server
Recently I was a bit confused when I installed MariaDB an couldn’t logon to the server as root. I kept getting “ERROR 1698 (28000): Access denied for user ‘root’@’localhost’ “. I have installed MySQL and MariaDB database servers many times, so getting this even though the correct root password threw me off a bit. [alert-note]ERROR […]
WordPress Beginners – Installing MariaDB Latest on Ubuntu 17.04
Want to install MariaDB on Ubuntu 17.04 / 17.10? This brief tutorial is going to show you the steps to get it done. MariaDB is a drop-in replacement for MySQL. This means, if you rip out MySQL and install MariaDB, applications and services that depended on MySQL will still function. These application won’t know the […]
How to Change MySQL and MariaDB Root Password
This brief tutorial shows users and students an easy way to change the root user password for MySQL and MariaDB database servers. This guide will only work if you already know the current root user password and you only want to change it to something different. If you don’t already know the root user password, […]
How to Reset MySQL or MariaDB Root Password
Yesterday we showed you how to change the root password for MySQL or MariaDB. This post shows you how to reset or recover a forgotten or lost root password for these database servers. This tutorial is only necessary if you’ve forgotten or lost the root password to MySQL or MariaDB and you cannot login. Before […]
Installing MariaDB Stable and Development Versions on Ubuntu
Want to test MariaDB development versions on Ubuntu 17.04? This brief tutorial is going to show students and new users steps to install MariaDB stable and development versions on Ubuntu systems. Installing MariaDB stable version on Ubuntu is pretty easy. All one has to do is run the apt-get install mariad-server commands to install it. […]
How to Convert from MySQL to MariaDB on Ubuntu 17.04
This post is intended to help students and new users switch from MySQL database server to MariaDB database server in Ubuntu 17.04. This should probably also work with other versions of Ubuntu. As you may already know, MariaDB is rapidly becoming the default database server on Linux systems, including Ubuntu. Over the past years, MySQL […]
Download MariaDB Latest Versions on Ubuntu 17.04 / 17.10
MariaDB is a drop-in replacement for MySQL database server. It is rapidly replacing MySQL as the default database server for Linux and other opensource systems. This brief tutorial is going to show students and new users how to download and install the latest versions of it on Ubuntu 17.04 / 17.10. Installing MariaDB on Ubuntu […]
Configure Remote Access to MySQL / MariaDB Databases
This brief tutorial shows students and new users how to configure remote access to MySQL or MariaDB database servers on Ubuntu 17.04 / 17.10 systems. When configured correctly, you will be able to connect to the database servers from a remote system on the same network. If the server is connected directory to the Internet, […]
Reset MariaDB Root Password on Ubuntu 17.04 / 17.10
Lost your MariaDB root password? Well, you’re in luck because this brief tutorial is going to show students and new users how to reset MariaDB root user password. This tutorial should apply to Ubuntu and other Linux distributions. When you forget MariaDB root password you will be denied access to the database. No matter what […]