Mysql: Difference between revisions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| 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; | ||
==Create user== | |||
CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD'; | |||
== To dump the database == | |||
<source lang="bash"> | |||
mysqldump -u FOOUSER FOO > foodump.sql | |||
gzip foodump.sql | |||
</source> | |||
Latest revision as of 16:11, 9 February 2021
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;
Create user
CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';
To dump the database
mysqldump -u FOOUSER FOO > foodump.sql
gzip foodump.sql