Thursday, August 16, 2012

mysql list server users


select user,host from mysql.user;

mysql grant access syntax

Sample:
grant all on *.* to 'root'@'123.233.423.34' identified by 'passw'