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';