At 12:58 AM -0500 2000-04-06, Jason D. Runyan wrote:
>I am having serious problems adding new users on a system with a fresh
>install of MySQL. I have used the grant commands and tried to add users to
>the system using SQL with no luck. If I don't create a user with a password
>I can access the client, but cannot connect to any databases, even if I have
>added them to the db table. I am at a loss of what to do. I have the
>ability to create databases using root, but that isn't smart for production.
>I am working on a non-production machine so I can lose any info that is in
>the databases that are on it.. Could anyone help me with this, I have
>already gone to the documentation, and read their bit on this as well as
>read the sections the O'Rielly book on MySQL.
You haven't shown us your GRANT statements, so it's difficult to
comment on why they didn't work. Did you grant the CREATE privilege?
Paul DuBois, paul@stripped