Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Cannot Reproduce
-
10.1.13
-
None
-
Debian Jessie updated
Description
The issue affects users when they try to access remotely.
The message is:
root@kvm401 [~]# mysql -u setdart_cms -p -h mysql.domain.com |
Enter password:
|
ERROR 1275 (HY000): Server is running in --secure-auth mode, but 'setdart_cms'@'kvm401.otherdomain.net' has a password in the old format; please change the password to the new format |
But the user has the password in appropriate format, in new password format
MariaDB [mysql]> select Host,User,Password from user where User like 'setdart_xxx'; |
+---------------+-------------+-------------------------------------------+
|
| Host | User | Password |
|
+---------------+-------------+-------------------------------------------+
|
| localhost | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 |
|
| dom.com | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 |
|
| 81.184.16.XXX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
| 81.184.17.XXX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
| 213.98.87.XXX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
| 80.39.222.XX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
| 81.45.170.XXX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
| 176.31.31.XXX | setdart_xxx | *88C12D1EC2E9914A3409CB4C90FA218349608425 | |
+---------------+-------------+-------------------------------------------+
|
8 rows in set (0.00 sec) |
|
If from an authorized location (office server) we try to access, no problem
But if we try to access from other authorized equipment, we skip the error message.
In another things, others were created, tests were made with the same result, and randomly one of them had the same problem suddenly started running.
Some may forget or any error in understanding the problem
