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:   MANAGE POSTGRES   PhpPGadmin : Install No se puede logear: Usuario […]


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 ( 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, […]