Mysql: Difference between revisions
No edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
NB: localhost means *really* localhost -- it means that only logins are allowed from the same machine and is a *good idea* for most uses. | NB: localhost means *really* localhost -- it means that only logins are allowed from the same machine and is a *good idea* for most uses. | ||
This creates a database named FOO with user FOOUSER and password FOOPASS; | This creates a database named FOO with user FOOUSER and password FOOPASS; | ||
== To dump the database == | |||
<source lang="bash"> | |||
mysqldump -u FOOUSER > foodump.sql | |||
gzip foodump.sql | |||
</source> | |||
Revision as of 17:08, 26 June 2019
Create a database + user for a project
sudo su
mysql -u root
create database FOO;
grant all on FOO.* to FOOUSER@'localhost' identified by 'FOOPASS';
NB: localhost means *really* localhost -- it means that only logins are allowed from the same machine and is a *good idea* for most uses. This creates a database named FOO with user FOOUSER and password FOOPASS;
To dump the database
mysqldump -u FOOUSER > foodump.sql
gzip foodump.sql