How to Drop a MySQL Database on Linux via Command line

We will show you how to drop a database in command line on a linux server with MySQL or MariaDB installed. First you need to log your MySQL/MariaDB mysql -u root -p List all the databases MariaDB> show databases; +——————–+ | Database | +——————–+ | information_schema | | example | | mysql | | performance_schema…

How to Create a MySQL Database on Linux via Command Line

We will show you how to create a database in command line on a linux server with MySQL or MariaDB installed. First you need to log your MySQL/MariaDB mysql -u root -p Create the database In this example, we will create the database “example” MariaDB> CREATE DATABASE example; Check if your database is created MariaDB>…

How to create a directory with mkdir in CentOS

In many cases, you will have to create a directory manually on your Dedicated Server. All those commands should be executed in command line. Create one directory mkdir directory ls directory Create many directories mkdir directory1 directory2 directory3 ls directory1 directory2 directory3 Create parent directory with flag -p mkdir -p directory1/sub1/sub2 tree directory1 |____sub1 |____sub2