Re: Unable to access mysql database with root user after upgrade?
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]
Re: Unable to access mysql database with root user after upgrade?
[EMAIL PROTECTED] wrote: Murray @ PlanetThoughtful [EMAIL PROTECTED] wrote on 11/11/2005 08:44:37 PM: Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the databases I have defined. In effect, it seems as though I have no real root (or administrator level, if that's a better way of putting it) login anymore... Does anyone know how I go about granting administrator privileges to root for the mysql database? Any help appreciated! Much warmth, Murray @ PlanetThoughtful Are you talking about root the OS user or root the MySQL user account? One or more of the following sections may apply to your situation: http://dev.mysql.com/doc/refman/4.1/en/common-errors.html MySQL may have a user called root or not. It all depends on how it has been setup. http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine 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. Thanks and much warmth, Murray @ PlanetThoughtful -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to access mysql database with root user after upgrade?
Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the databases I have defined. In effect, it seems as though I have no real root (or administrator level, if that's a better way of putting it) login anymore... Does anyone know how I go about granting administrator privileges to root for the mysql database? Any help appreciated! Much warmth, Murray @ PlanetThoughtful -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]