A A A

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
mysql connection using old (pre-4.1.1) authentication protocol refused
July 12, 2016
8:27 am
Lo0oM
Admin
Forum Posts: 217
Member Since:
September 30, 2012
Offline

Hi

 

Description:

I created new user account in MySQL server 5.0.77 and tried to connect to it from Workbench 6.1. Got the next error:

mysql connection using old (pre-4.1.1) authentication protocol refused

 

Solution:

1. Log in to MySQL as root and update MySQL user to use password with 41 bit HASH (new).

# mysql -p

mysql> select Password from mysql.user;
+——————————————-+
| Password                                  |
+——————————————-+
| 5542fc81097b1837                          |
| 4e965b3a542c9b22                          |
| 25abf30d20199ea6                          |
| *BC389DF8478D287EFF6CEB2FBE8AADD2073FDBB4 |
| *C964ABA161508FE2C829994DA56B796F3C8EA433 |
| 09849b9d437788a6                          |
+——————————————-+

How you see I have old HASH passwords (short) and new 41 bit HASH passwords (long).

mysql> SELECT @@session.old_passwords, @@global.old_passwords;
+————————-+————————+
| @@session.old_passwords | @@global.old_passwords |
+————————-+————————+
|                       1 |                      1 |
+————————-+————————+
1 row in set (0.00 sec)

2. Now configure current session.

mysql> SET @@session.old_passwords = 0;
Query OK, 0 rows affected (0.00 sec)

 

3. Update the password:

mysql> grant select on build_retention.* TO 'auto'@'%' identified by 'C964ABA16150';
Query OK, 0 rows affected (0.00 sec)

mysql> select Password from mysql.user;
+——————————————-+
| Password                                  |
+——————————————-+
| 5542fc81097b1837                          |
| 4e965b3a542c9b22                          |
| 25abf30d20199ea6                          |
| *BC389DF8478D287EFF6CEB2FBE8AADD2073FDBB4 |
| *C964ABA161508FE2C829994DA56B796F3C8EA433 |
| *2D386315103D9499DF25E0E6BCDE6570B1E097FE |
+——————————————-+

How you see last line changed from (short) to (long). Account updated and login successful.

 

Thank you.

 

 

 

Forum Timezone: UTC 0

Most Users Ever Online: 31

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 3

Forums: 20

Topics: 214

Posts: 214

Newest Members: Lo0oM

Administrators: Lo0oM (217)