Murray @ PlanetThoughtful wrote:
[EMAIL PROTECTED] wrote:
Hi Shawn,
Sorry, I'm talking about "root" the MySQL user account. The account
exists -- I can perform the following, for example:
c:>mysql --user=root ptnew -p
Once I supply the password, this will put me in to the ptnew database,
which is one that I created for one of my local development web sites.
However, I can't do:
c:>mysql --user=root mysql -p
Once I supply the password, I get an access denied error. Similarly
for when I attempt to get into the test database.
(It probably goes without saying, but I get the same access denies
error when issuing "use mysql;" or "use test;")
It seems my privileges got messed up during the upgrade from 4.1.7 to
5.0.15, and now I don't appear to have any real "administrator" login,
in that I can't create new users, or modify privileges etc.
I'll check the links out that you supplied, but if you have any other
thoughts, I'd love to hear them.
After struggling with this for some hours I finally gave in, backed up
my databases, removed MySQL 5.0.15, and re-installed it.
It seems I now have a normal 'superuser' root account again. I still
have no idea what went wrong. But at least it appears I can get in and
perform administrative tasks, which is a relief.
Thanks to all who gave this some thought.
Much warmth,
Murray @ PlanetThoughtful
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]