> A user in MySql is not just a username, but a username and a host. > > The host of '%' denotes all hosts accept 'localhost'. > > Therefore you usually require two entries for each user: > > CREATE USER ben@'%' INDENTIFIED BY 'ben'; > CREATE USER ben@'localhost' INDENTIFIED BY 'ben'; > > Does this help?
Makes sense, BUT, isn't the info between the last set of tickmarks '' the password for the user? When I created the users, I ran the command: grant usage on db1.* to joe identified by 'whateverpassword'; Then I ran a second grant command: grant select, drop, etc, on db1.* to joe; I should probally say that my 5.0.22 MySQL database is on a centos 5.1 box. _________________________________________________________________ Pack up or back up–use SkyDrive to transfer files or keep extra copies. Learn how. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_packup_042008
