http://wiki.hackerzhou.me/ 2026-04-28T06:46:05+00:00 http://wiki.hackerzhou.me/ http://wiki.hackerzhou.me/_media/wiki/dokuwiki.svg text/html 2020-06-06T23:32:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://wiki.hackerzhou.me/dev/kb/database/mysql?rev=1591486367&do=diff MySQL Update MySQL root password sudo mysqladmin -u root -p password '<new_password>' Allow MySQL root remote access update mysql.user set host = '%' where user = 'root'; Create backup account create user backupuser@localhost identified by 'backuppassword'; grant lock tables, select on *.* to backupuser@localhost identified by 'backuppassword'; text/html 2020-06-06T23:32:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://wiki.hackerzhou.me/dev/kb/database/oracle?rev=1591486367&do=diff Oracle Command line lsnrctl start text/html 2020-06-06T23:32:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://wiki.hackerzhou.me/dev/kb/database/postgresql?rev=1591486367&do=diff PostgreSQL Enable PostgreSQL 8+ remote access without password cat >> $PGSQL_DATA/pg_hba.conf <<EOF host all all 0/0 trust EOF sed -i "s|.*listen_addresses.*|listen_addresses = '*'|" $PGSQL_DATA/postgresql.conf # Add following rule to iptables if needed. iptables -A INPUT -p tcp --dport 5432 -j ACCEPT