Hi, I just installed MySQL version 4 and as usual, trying to set up users and grant permissions is a nightmare. I followed the instructions in the MySQL manual and granted permissions to a user, like below:
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY '12345678' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH GRANT OPTION; I can log in with this user, but I can't do anything (i.e. create a database). There is also no mysql database (there is though if I log in as root). So what am I doing wrong.....? TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]