Greg, thanks for the suggestion. I had not done that. I ran "FLUSH PRIVILEGES" in mysql query browser and it hung (the dolphin started swimming forever and the program crashed). After I shut the program down (with ctrl-alt-del), the database was not functioning. I had to restart the computer, and then it functioned fine again.
I have since tried adjusting permissions with "GRANT" statements as well as with mysql administrator and I get the same result each time: program crashed, database does not function and a restart starts everything back up. I did a CHECK TABLE on all tables (in my database as well as all of the grant tables) and everything turned out OK. Any thoughts as to what is wrong or how I can go about getting things to work right? Thanks for your help! Dave "Greg Donald" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Thu, 16 Sep 2004 11:24:08 -0400, Dave Shacket <[EMAIL PROTECTED]> wrote: > > I have a database up and running on my server. (Windows XP Pro, IIS, mySQL > > 4.1.1a). I have created 4 users, including root (which I had completely > > removed, then recreated with the same name). My problem is that everyone has > > global priviledges to the entire server. There are no items to add or remove > > in the Global Priviledges tab under "Users" (using mysql administrator). I > > have looked at the users table and there is an N for every entry under the 3 > > other users (there is a Y under all for root). I have searched the > > documentation and can't figure out where I have gone wrong here. > > > > In the db table, there is one entry for one user (not root). There are no > > entries in the host table. > > > > I would appreciate any help you can give me! > > Did you flush priveledges after making changes? > > > > -- > Greg Donald > http://gdconsultants.com/ > http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
