The MySQL server crashed when I try to set remote access using 'grant' -


i type commands below:

mysql –u root -p grant privileges on *.* root@”%” identified “rootpassword” grant option; grant privileges on mysitedb.* root@localhost; 

then server crashed:

could not establish database connection. please check username, password , hostname in config file, , if necessary set appropriate mysql user , privileges.

change grand statement in below one, solved:

mysql –u root -p grant privileges on *.* root@”%” identified “rootpassword” grant option; grant privileges on mysitedb.* root@localhost identified “rootpassword” grant option; 

Comments

Popular posts from this blog

c - Bitwise operation with (signed) enum value -

xslt - Unnest parent nodes by child node -

YouTubePlayerFragment cannot be cast to android.support.v4.app.Fragment -