Tag: Postgres

Creating a User / Role Mysql: mysql> GRANT ALL PRIVILEGES ON dbname.* TO ‘dbuser’@’%’ IDENTIFIED BY ‘dbpass’; (The above grants full access to the named database to the named user connecting from any host on the internet identifying using the given password. If granting privileges this way, it’s important to …

Initializing the DBMS (Note that this assumes no meta-database or anything exists at the present time.) Mysql: Just start the mysqld daemon if he mysql meta-database doesn’t exist. (see below) Postgresql: linux# su -c “initdb -D /path/to/data/dir” postgres Starting the DBMS Mysql: linux# service mysql start Postgresql: linux# service postgresql …