MYSQL

restor SQL

To check admin password:
cat /usr/local/directadmin/conf/mysql.conf

Restore mySQL:
mysql -u da_admin -p -v -D bryanlyt_wrdp2 < ./bryanlyt_wrdp2.sql




backup SQL
mysqldump -u user01 -p -Q --disable --extended-insert database01 > filename.sql

restore SQL
mysql -u username -p database_name < filename.sql



MySQL grant permission
1. login as da_admin
2. use mysql;
3. select super_priv from user where user='webmanfb_wfb'; (to check privilege)
3. update user set super_priv='y' WHERE user='webmanfb_wfb'; (grant privilege)
4. flush privileges;