|
Home > Archive > MySQL ODBC Connector > January 2006 > Access denied after upgrade to 5.0
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access denied after upgrade to 5.0
|
|
|
| Hello,
I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
connect, I always get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
(or using password:YES)
I followed the reset password procedure. If the server is started with
--skip-grant-tables, I can see correct entries for user root:
mysql> select Host, User from user where User = 'root';
+--------------------------------------------------------------+------+
| Host | User |
+--------------------------------------------------------------+------+
| localhost | root |
| localhost.localdomain | root |
+--------------------------------------------------------------+------+
encoded passwords are there too.
Is there anything else I could miss. What should I check, where to look?
Thank you
Marek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Gleb Paharenko 2006-01-28, 11:23 am |
| Hello.
Are you able to connect to MySQL Server if you blank the root password?
Use mysql command line client from 5.0 distribution. Have you run
mysql_fix_privilege_
tables script? Please, provide the CREATE statement
for mysql.user table.See:
http://dev.mysql.com/doc/refman/5.0...ess-denied.html
M wrote:
> Hello,
>
> I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
> connect, I always get:
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
>
> (or using password:YES)
>
> I followed the reset password procedure. If the server is started with
> --skip-grant-tables, I can see correct entries for user root:
>
> mysql> select Host, User from user where User = 'root';
> +--------------------------------------------------------------+------+
> | Host | User |
> +--------------------------------------------------------------+------+
> | localhost | root |
> | localhost.localdomain | root |
> +--------------------------------------------------------------+------+
>
> encoded passwords are there too.
>
> Is there anything else I could miss. What should I check, where to look?
>
> Thank you
>
> Marek
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|