Phine Solutions web work notes

mysql’s useful … sqls

Filed under: mysql — 1.618 @ 10:27 pm

Create a new user: 

grant all on mydb.* to myuser@localhost identified by 'mypass';

show grants for ‘username’@'localhost’

revoke all privileges on db_name.* from ‘username’@'localhost’

drop user ‘username’@'localhost’

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

©phinesolutions.com