Just fired up mysql 3.23.53 *
Created a d/b, and then created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION;
Yup. Well known privileges problem. The short answer is that the default MySQL install (why????) creates an anonymous user who can log on from anywhere. Until you get rid of that user, who has no privileges to read any database, you can't set up any other users who can log in from anywhere. So,
USE mysql; DELETE FROM user where User=""; FLUSH PRIVILEGES;
and all will work.
ari
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
