Mysql commands: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 19: | Line 19: | ||
* Create a soft Link | * Create a soft Link | ||
ln -s /home/copperhills/copperhills /var/www/copperhills | ln -s /home/copperhills/copperhills /var/www/copperhills | ||
</pre> | </pre> | ||
== First Time == | |||
> apt install mysql-server | |||
> mysql_secure_installation | |||
> CREATE USER 'USER'@'localhost' identified by 'PWD'; | |||
> GRANT ALL PRIVILEGES ON *.* TO 'USER'@'localhsot'; | |||
[[Category:Bioinformatics]] | [[Category:Bioinformatics]] | ||
Revision as of 09:50, 2 August 2021
- 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';