PostgreSQL

PostgreSQL: Relevant Commands

Posted on

Connecting to Postgress Shell psql -U postgres -d postgres List Users select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig Change User Password   ALTER USER colin WITH PASSWORD ‘letmein’; Reference: http://www.davidpashley.com/articles/postgresql-user-administration/   MANAGE POSTGRES   PhpPGadmin : Install https://help.ubuntu.com/community/phpPgAdmin No se puede logear: http://www.unixmen.com/install-postgresql-and-phppgadmin-on-debian-7-wheezy/ Usuario […]

MySQL

MySQL: External Connection to Database Blocked

Posted on

Cannot establish an external MySQL connection to the server. Error 1.  Error 10061: connect to MySQL server failed Fixed it using the following solution (https://help.ubuntu.com/community/ApacheMySQLPHP) Solution 1. Set mysql bind address Before you can access the database from other computers in your network, you have to change its bind address. Note that this can be a security problem, […]