Last tested on Ubuntu 16.04.01 LTS (xenial)
Getting into DB console.
MySQL:
$ mysql -uroot -p
PostgreSQL:
$ sudo su postgres
postgres@hydrogen:~$ psql
Creating DB
Creating a database and granting a user complete access.
MySQL:
mysql> create database mydb;
mysql> grant all on mydb.* to dbuser@localhost identified by 'mypass';
PostgreSQL:
postgres=# create user dbuser with password 'mypass';
postgres=# create database mydb;
postgres=# grant all privileges on database mydb to dbuser;
Listing DBs
You can list the DBs.
MySQL:
mysql> show databases;
PostgreSQL:
postgres=# \l
Selecting a DB
You can select a DB.
MySQL:
mysql> use mydb;
PostgreSQL:
postgres=# \connect mydb;
After selecting a DB you can go ahead and execute SQL commands.
Listing all tables
You can list tables in a DB.
MySQL:
mysql> show tables;
PostgreSQL:
postgres=# \dt
Change the password of a user
You can list tables in a DB.
MySQL:
mysql> set password for 'dbuser'@'localhost' = password('newpassword');
PostgreSQL:
postgres=# alter user "dbuser" with password 'newpassword';
Exiting from DB
Ctrl-D should exit from both.
