database

Switch user to root:

$ su -u root -p

Run codes to add user and grant all privileges

$ CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';

$ CREATE USER 'user'@'%' IDENTIFIED BY 'pass';

$ GRANT ALL ON *.* TO 'user'@'localhost';

$ GRANT ALL ON *.* TO 'user'@'%';

edit file sources.list

$ sudo nano /etc/apt/sources.list

add

deb http://packages.dotdeb.org wheezy all
deb-src http://packages.dotdeb.org wheezy all
deb http://packages.dotdeb.org wheezy-php56-zts all
deb-src http://packages.dotdeb.org wheezy-php56-zts all

Then run

$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install php5

To reset MYSQL root password:

$ sudo dpkg-reconfigure mysql-server-5.5

Grant all privileges to a user

$ GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

Drupal 6 and 7

$ drush cc

$ drush sql-dump > ~/my-sql-dump-file-name.sql

Drupal 8

$ drush cr

$ drush sql-dump > ~/my-sql-dump-file-name.sql

Download Database from the server

$ scp username@example.com:~/my-sql-dump-file-name.sql ~/projects

Import Database

$ drush sql-drop

$ drush sql-cli < ~/my-sql-dump-file-name.sql