MySQL Forums
Forum List  »  MySQL Workbench

Connect to MySQL 8 from Workbench
Posted by: C D
Date: March 17, 2020 09:03PM

mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)
MySQL Workbench CE (GPL) 6.3.8 CE build 1228


Attempting to connect to MySQL within Workbench as root (as I connect traditionally) I get 'Access denied for user 'root'@'localhost''.

I've read that MySQL 5.7+ no longer allows access as root, so you need to create another account with the same privileges as such within mysql-server:


mysql> create user 'admin'@'localhost' identified by 'password';
mysql> grant all privileges on *.* to 'admin'@'localhost';
mysql> flush privileges;


This completed successfully, but again attempting to connect from within workbench I still get an error:

Failed to Connect to MySQL at localhost:3306 with user admin
Access denied for user 'admin'@'localhost' (using password: NO)

Login details below. Any guidance on how to remedy is much appreciated.

hostname: localhost
port: 3306
username: admin
password: (none)

For reference, my mysql installation sits on an external HD, though I access it without issue using the standard 'sudo mysql -u root -p' call on the command line.

Options: ReplyQuote


Subject
Views
Written By
Posted
Connect to MySQL 8 from Workbench
3178
C D
March 17, 2020 09:03PM
615
C D
March 17, 2020 09:42PM
698
C D
March 18, 2020 02:03PM


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.