|
1 |
CREATE USER 'mcp'@'localhost' IDENTIFIED BY 'password'; |
|
1 |
GRANT ALL PRIVILEGES ON * . * TO 'mcp'@'localhost'; |
|
1 |
FLUSH PRIVILEGES; |
for more information
https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql
|
1 |
mysql -u root -pabc |
create database
#Export
|
1 |
mysqldump -u [uname] -p[pass] db_name > db_backup.sql |
#import
|
1 |
mysql -u username -p -h localhost DATA-BASE-NAME < data.sql |