For a piece of SQL statement exported by PhpMyAdamin, please advise! CREATE & nbsp; DATABASE & nbsp; IF & nbsp; NOT & nbsp; EXISTS & nbsp; primavpdb001 & nbsp; GRANT & nbsp; ALL & nbsp; & nbsp; ON & nbsp; prim is an SQL statement exported by PhpMyAdamin. please advise!
Create database if not exists primavpdb001;
GRANT ALL
ON primavpdb001 .*
TO [email protected]
Identified by 'changeme ';
Flush privileges;
USE primavpdb001;
Please refer to the following statements! Better details, hey!
------ Solution --------------------
Create database if not exists primavpdb001;
Check whether the database primavpdb001 exists. if it does not exist, create
GRANT ALL
ON primavpdb001 .*
TO [email protected]
Identified by 'changeme ';
Flush privileges;
Grant primavpdb000000f global permissions on all data tables in the primavpdb001 database on localhost. set the password to changeme.
USE primavpdb001;
Open Database primavpdb001