"C. Reeve" <[EMAIL PROTECTED]> wrote: > > 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). >
Could you connect to the MySQL server? What exactly error messages did you get? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]