mysql - ERROR 1046 (3D000): No database selected while creating user -


when create admin user with:

grant on * my_name@localhost identified 'my_passwd' grant option  

i received error message "error 1046 (3d000): no database selected".

you should saying below qualifying database name. check mysql documentation more information.

 grant on db_name.* 

so case,

grant on db1.* my_name@localhost identified 'my_passwd'  grant option; 

Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -