List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:September 17 1999 6:25pm
Subject:Re: Help adding users
View as plain text  
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
> database.
> 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?
> Thanks
> 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?
> Thanks,
> --
> Douglas Brantz

Hi Douglas

Just remove the empty user with host 'localhost' and no password from mysql.user table.


Help adding usersDouglas Brantz17 Sep
  • Re: Help adding usersDouglas Brantz17 Sep
  • Re: Help adding usersChristian Mack17 Sep