Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

mysql shell can't connect to local Percona Server 5.7

jiez98jiez98 EntrantCurrent User Role Novice
Hello,

I am doing preparation for upgrade Percona MySQL 5.7 to Percona MySQL 8.0. I notice that MySQL shell provides a convenient way to check any upgrade issues. I downloaded and installed mysql-shell-8.0.9 on my local mysql server. However, I couldn't connect to Percona mysql. I tried two different ways, below are errors:

OS:
$ cat /etc/redhat-release
CentOS Linux release 7.7.1908 (Core)

MySQL:
Server version: 5.7.24-26-log Percona Server (GPL), Release 26, Revision c8fe767

1. yum install -y mysql-shell-8.0.19-1.el7.x86_64.rpm as root
$ mysqlsh [email protected]:3306
Please provide the password for '[email protected]:3306': **************
MySQL Shell 8.0.19

Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a session to '[email protected]:3306'
MySQL Error 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: Incompatible client plugin interface


2. Untar mysql-shell-8.0.19-linux-glibc2.12-x86-64bit.tar.gz
cd mysql-shell-8.0.19-linux-glibc2.12-x86-64bit/bin
$ ./mysqlsh [email protected]:3306
Please provide the password for '[email protected]:3306': **************
MySQL Shell 8.0.19

Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a session to '[email protected]:3306'
MySQL Error 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: /usr/local/mysql/lib/plugin/dialog.so: cannot open shared object file: No such file or directory

I know the login-dir is not correct, but I don't know how to tell mysqlsh where to look for (doesn't seem like there is an option).

Does anyone have similar errors? Is that because mysql shell is not compatible with Percona server (one article says it should work on Percona server)? If anyone knows how to use mysql shell on Percona server, I'd really appreciate if you can share with me.

Thanks,
Jie

Comments

  • jiez98jiez98 Entrant Current User Role Novice
    I meant to say plugin-dir, not login-dir in my previous post.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.