Error 1251 - Client does not support authentication protocol requested by server. Navicat ( HELP )

Status
Not open for further replies.
Solution
TesoMayn
For anyone else experiencing this issue, it's an easy fix
SQL: 
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='username';
FLUSH PRIVILEGES;

And if you are unable to login to run that command
Code: 
mysqld_safe --skip-grant-tables --old-passwords
mysql -u root
Sort by date Sort by votes
TesoMayn

TesoMayn

Boredom, it vexes me.
Oct 30, 2011
1,482
1,482
For anyone else experiencing this issue, it's an easy fix
SQL: 
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='username';
FLUSH PRIVILEGES;

And if you are unable to login to run that command
Code: 
mysqld_safe --skip-grant-tables --old-passwords
mysql -u root
 
Upvote 1 Downvote
Solution
Status
Not open for further replies.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top