----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]>
> Where are these instructions found? Got em here : http://www.analysisandsolutions.com/code/mybasic.htm#installation <snip> > > Yes, unless some other user table matches first, which may be > what is happening in your case. Cool. Ok, that's new info for me. What is the table order that MySQL uses to grant authentication? On that same note, if I understand your response, does it stop the minute it finds a suitable entry (I guess it matches the user name) or does it grab info from all tables for that username? If the latter, does it grant the privileges inclusively (i.e. does it get everything that they all grant individually (so you get different rights from different tables) or does it only grant what all of the tables allow (only those privileges that are granted on each table are granted)? <SNIP> > > Stopping and starting the service should be unnecessary. > The FLUSH PRIVILEGES statement you're using causes the > server to reload the grant tables. Excellent. Thanks for the info! > > > >Here are some of the things which I do to supposedly > >secure the MySQL install : > > > >delete from user where User=''; > >update user set User='NewRootName', > >Password=password('NewPassword') where User='root'; > >update user set host='%' where user='NewRootName'; > >flush privileges; > > What is the output of the following statement after you issue the > preceding statements: > > SELECT Host, User, Password FROM user; I get two entries, both for the same username (I've actually already uninstalled MySQL for the umpteenth time, but I did what you asked before to be sure it was there). The first instance of the username is matched to 'localhost' and the second instance is matched to '%'. In both cases the password is the same (in this case it was 'lwtest'). Thanks a TON for your assistance...I've spent quite a bit of time working on this daggone thing (as a side, I am 100% sure that I am doing something wrong, I just can't figure out what the heck it is!) JT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
