jerm@ocmd

helpful commands:

from command line:

mysqldump mysqldump -u jerm -p ocmdhotels > ~/.dump/backupname.sql

stop/start/restart sudo /etc/init.d/mysqld stop sudo /etc/init.d/mysqld start sudo /etc/init.d/mysqld restart

login mysql -u jerm -p

from ‘mysql’ command line:

show databases; show databases

problems

problem

• restarted mysql
• plesk wouldnt grant access

solution

• https://kb.odin.com/en/112492

user jerm stopped being able to run mysqldump 160126

• using ‘root’ for now