Search code examples
mysqlinnodb

I can't use MySQL shell to connect root@localhost

I meet some problems in mysql,

OS:centos7

MySQL：mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)

MySQL Shell：mysql-shell-8.0.23-1.el7.x86_64

I can use ( mysql -uroot -p ) to connect mysql,but I can't use mysql shell to connect mysql.

My root password is right, How to solve this?

enter image description here

enter image description here

Solution

  • I solved this problem ,I don't have the Permission in root, so I use

    create user root@"%" identified by '***';  
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;