Mysql commands

• GetInto from Shell

$ mysql -u $usr -p -h $host $db

• GetDump

$ mysqldump -u $usr -p -h $host $db >$outfile 

• RestoreDump

$ mysql -u $usr -p -h $host $db <$outfile


* Create a soft Link
ln -s /home/copperhills/copperhills /var/www/copperhills

First Time

> apt install mysql-server
> mysql_secure_installation
> CREATE USER 'USER'@'localhost' identified by 'PWD';
>  GRANT ALL PRIVILEGES ON  *.* TO 'USER'@'localhsot';