Douglas Brantz wrote:
> Thanks for the response.
> I have a root user and root user password. Then I created a user with
> all the rights to mysql mysql so that I didn't ahve to login as root all
> the time. The new user has a password as well. Ok, so then I login as
> the new user and not as root. Then as the new user with all the rights
> to mysql mysql I had some new users with passwords etc. Then I add them
> to use the one of the databases. I do all this through the mysql mysql
> Then I do a mysqladmin reload. It seems that all the new users can only
> access the database I added them to without using their password. If
> they use the passwords I gave them then I get access denied?
> Should I just add new users as root and not the user I created that has
> all privledges?
> PS: Has anyone created forms for adding users and changing privledges?
> I know if the book it mentions several graphic user interface programs
> and scripts. It seems that these should already exist?
> Douglas Brantz
Just remove the empty user with host 'localhost' and no password from mysql.user table.