> The ANSI-SQL syntax is to just use GRANT to create users. You will > still need to use GRANT twice for both users: joe@'%' and joe@'localhost'. > > But I find the MySql syntax for creating user with CREATE USER and then > GRANT easier to follow: > > CREATE USER joe@'%' IDENTIFIED BY 'whateverpassword'; > CREATE USER joe@'localhost' IDENTIFIED BY 'whateverpassword'; > > GRANT ALL ON db1.* TO joe@'%'; > GRANT ALL ON db1.* TO joe@'localhost'; > > If you see what I mean... > > Just remember that a user always has a host, and you should always use > the two together. > > Ben
Thanks Ben, OK Got it, One more thing, I have already created these users and don't want to mess their passwords up or break their associated php scripts access. So how do I grant users, who already have a password, localhost access? _________________________________________________________________ Going green? See the top 12 foods to eat organic. http://green.msn.com/galleries/photos/photos.aspx?gid=164&ocid=T003MSN51N1653A
