PostgreSQL: Create Database, User and Grant Privileges

Open terminal and invoke this command:

psql -U postgres

to create new database, invoke this command:

CREATE DATABASE mydatabase;

to create new user, invoke this command:

CREATE USER dbuser WITH PASSWORD 'mypassword';

then, you can set your desired user-related preference like this

ALTER ROLE dbuser SET client_encoding TO 'utf8';
ALTER ROLE dbuser SET default_transaction_isolation TO 'read committed';
ALTER ROLE dbuser SET timezone TO 'UTC';

to grant privileges, invoke this command:

GRANT ALL PRIVILEGES ON DATABASE mydatabase TO dbuser;

Quit from PostgreSQL console

\q

PHPMyAdmin – Run Slow When Loading List of Databases

If you have lots of databases, especially if some of your database names share certain prefixes it could take quite long time for the database list to load. Add this to config.inc.php

$cfg[‘LeftFrameDBTree’] = false;

Now PHPMyAdmin display the list faster 🙂

MySQL – Unable to connect to system bus

this error occured when invoking this command on my ubuntu server: service mysql start

solution: sudo service mysql start

conclusion: you need to be root to run this command

MySQL – Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed

• stop mysql
• delete “ib_logfile0″ and “ib_logfile1″
• start mysql

MySQL – InnoDB One File Per Table

on my.cnf:

[mysqld]
innodb_file_per_table