CREATE USER 'username'@'%' IDENTIFIED BY 'the_password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;This creates a new user with full root-like permissions and access from any host.
SHOW DATABASES;
CREATE DATABASE <database>;SELECT user, host FROM mysql.user;
CREATE USER '<user>'@'<hostname>' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database>.* TO '<user>';
FLUSH PRIVILEGES;This is done outside mysql from cli with the mysqldump command:
mysqldump -u <user> -p --databases your_database > /path/to/your_database.sqlIf you want to exclude stored procedures and triggers, use:
mysqldump -u <user> -p --databases your_database --skip-triggers > /path/to/your_database.sqlIf you only want schema (no data):
mysqldump -u <user> -p --no-data your_database > /path/to/schema.sqlIf you only want data (no schema):
mysqldump -u <user> -p --no-create-info your_database > /path/to/data.sqllogon to mysql, delete and recreate database grant privileges, then logout
mysql -h 10.0.1.3 -u adolar -p
DROP DATABASE <database>;
CREATE DATABASE <database>;
GRANT ALL PRIVILEGES ON <database>.* TO '<user>';
exitImport the sql dump:
mysql -u <user> -p your_database < /path/to/destination/your_database.sql