mysqlsh \c root@domain.name fails (1045) but \c --mysql root@domain.name is OK
Posted by:
Dan Cvrcek
Date: April 15, 2019 04:03AM
Hi
Mysql 8.0.15, Centos7
I had to restore an Innodb cluster inlcuding root users. It seems to be working properly (although I had a problem when the master changed).
However, when I try to connect with mysqlsh, I have to include "--mysql" flag. The log file doesn't show anything - debug/debug2/debug3 shows only this (after the password is typed in)
--------------------
2019-04-15 09:50:24: Error: MySQL Error 1045: Access denied for user 'root'@'a3.keychest.net' (using password: YES)
2019-04-15 09:50:24: Debug:
2019-04-15 09:50:24: Debug: Match '*;a3.company.net;*' vs ';;'
2019-04-15 09:50:24: Debug: Match '' vs ''
------------
Interestingly - I tried to connect to a2.company.net - (a3 is where I had an active connection).
The list of users contains
| root | a2.company.net |
| root | a3.company.net |
as well as an entry for the VLAN
| root | 10.% |
I'm at my wit ends.
Dan
Subject
Views
Written By
Posted
mysqlsh \c root@domain.name fails (1045) but \c --mysql root@domain.name is OK
957
April 15, 2019 04:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.