How To Web Host

A basic How To guide designed for beginning web hosts

MySQL – MariaDB

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

May 29, 2016

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 »

Sidebar