PostgreSQL: ERROR: permission denied to reassign objects
When reassigning all database objects to a new owner in PostgreSQL you might get this error: mydb=> REASSIGN OWNED BY admin TO new_admin; ERROR: permission denied to reassign objects This…
find location of database files
MySQL 1. Connect to the mysql console: # mysql -p 2. Look the value of 'datadir' variable to find the location of database files: mysql> SHOW VARIABLES WHERE Variable_Name =…