CODEWITHSUNDEEP
mysqlinnodb
Ryan Gee
Ryan Gee

Reputation: 41

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

Upvotes: 3

Views: 1161

Answers (2)

Afanasii Kurakin
Afanasii Kurakin

Reputation: 3459

This worked for me for MySQL 5.7 on Ubuntu 18.04:

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

Upvotes: 0

Ryan Gee
Ryan Gee

Reputation: 41

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;

Upvotes: 1

Related Questions