CREATE USER <dbname>@localhost;
SET PASSWORD FOR <dbuser>@localhost= PASSWORD(“<db_password>”);
GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY ‘<db_password>’;
FLUSH PRIVILEGES;
source <data_file>.sql;
Online home of Mansoor Lakhani
CREATE USER <dbname>@localhost;
SET PASSWORD FOR <dbuser>@localhost= PASSWORD(“<db_password>”);
GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY ‘<db_password>’;
FLUSH PRIVILEGES;
source <data_file>.sql;