I was planning to develop a tourism website on WordPress. As a first step, I installed LAMP on my PC in which I am using Ubuntu 16.04. Then I installed PhpMyAdmin on my computer by following this tutorial. Then started
psql command is used to connect to PostgreSQL database. To login to PostgreSQL database, run You will be asked to enter password. List all databases To list all databases use command \list or \l Connect to a database Before you
PostgreSQL default user name is postgres. This is a system user, so to login, first change to this user with command Now you can connect to PostgreSQL by simply running psql Now you have full rights to PostgreSQL installation. Create
DESCRIBE TABLE is a command used in Oracle database to show structure of a table in database. The PostgreSQL equivalent is \d+ TABLE_NAME You will need to see database structure to work with databases. Example
To restore Database in PostgreSQL, run pg_restore -h POSTGRESQL_SERVER_IP -p 5432 -U POSTGRESQL_USERNAME -d POSTGRESQL_DB_NAME -v backup.dump -p = specify port used by PostgreSQL server. -d = Connect to database and restore directly into the database. -v = Specifies verbose
We can deactivate a plugin through WP Admin Dashboard. What we can do if we can’t accessing the admin area ? Yes, The following situations may block you out from accessing the dashboard 1). Will show a blank page after
After you install PostgreSQL on Ubuntu/Debian, it will create a user “postgres”, it have full privileges. It is like “root” user in MySQL. Connect to PostgreSQL To connect to PostgreSQL, run following command. This will change current user to linux
PostgreSQL is a popular database management system that is used to handle the data of many websites and applications. If you were to run which psql and Postgres is not installed there appears to be no output. You just get
First connect to your Ubuntu server using ssh and run below command It will give you a password prompt as follow: Enter root password there and press enter key, then it will be connected successfully. It will show below output: To
After you setup Cpanel, you have to do few things to secure MySQL on Cpanel server. 1. Delete the test database This can be done with command mysqladmin drop test 2. Change MySQL root Password This can be done through
