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

user_11124011 0
Viewed 297

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

innodb mysql
2 Answers

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;
user_111240110

This worked for me for MySQL 5.7 on Ubuntu 18.04:

sudo mysqlsh -u root --no-password --socket /var/run/mysqld/mysqld.sock
user_12835870
Related