MySQL Forums
Forum List  »  InnoDB clusters

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlsh \c root@domain.name fails (1045) but \c --mysql root@domain.name is OK
644
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.