MySQL – MariaDB

Install LAMP on Ubuntu

Linux, Apache, MariaDB (or MySQL) and PHP These steps work with both Ubuntu 18.04 LTS and Ubuntu 20.04 LTS I’ve included steps for both MariaDB and MySQL. sudo apt update -y sudo apt upgrade -y sudo apt install apache2 -y # MariaDB sudo apt install mariadb-server -y # MySQL sudo apt install mysql-server -y sudo… read more »

Common MySQL / MariaDB Commands

Log into mysql client: General Linux # mysql -u username -p Enter password: **** mysql> _ Plesk – Linux: mysql -uadmin -p`cat /etc/psa/.psa.shadow ` Plesk – Windows: (Untested) C:\Program Files\Parallels\Plesk\admin\bin>dbclient.exe –direct-sql –sql=”select * from databaseservers where type=’mysql’ and host=’localhost'” WHM / cPanel mysql -uroot If this does not work, you might try using the root… read more »