Inspect TXT records of a domain

 host -t txt 

Create a database

When all the servers installed above, it’s now time to begin setting up WordPress environment. First, run the steps below to create a blank database for WordPress to use.

Logon to MariaDB database console using the commands below:

sudo mysql -u root -p

Then create a database called wpdb


Next, create a database user called wpdbuser and set password

CREATE USER 'wpdbuser'@'localhost' IDENTIFIED BY 'new_password_here';

Then grant the user full access to the database.

GRANT ALL ON wpdb.* TO 'wpdbuser'@'localhost' WITH GRANT OPTION;

Finally, save your changes and exit.


List all mysql users

login into mysql:

sudo mysql -u root -p

list all users:

SELECT User,Host FROM mysql.user;

Importing the database

From the normal command line, you can import the dump file with the following command:

mysql -u username -p new_database < data-dump.sql

Export all database to one file

mysqldump -u root -p --all-databases > alldb.sql

Import all databases

mysql -u root -p < alldb.sql

cp command syntax

Use the following syntax:
cp -a {/path/to/source} {/path/to/destination}

For example copy all files including subdirectories from /mnt/dvd/data to /home/tom/data, enter:

 cp -a /mnt/dvd/data/* /home/tom/data

 cp -av /mnt/dvd/data/* /home/tom/data

Remove a PPA from the source list in terminal

Alternatively, you can remove the PPA from sources list where these PPAs are stored. PPAs are store in the form of PPA_Name.list. Use the following command to see all the PPAs added in your system:

sudo ls /etc/apt/sources.list.d

Look for your desire PPA here and then remove the PPA using the following command:

sudo rm -i /etc/apt/sources.list.d/PPA_Name.list