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
878
C D
March 17, 2020 09:03PM
302
C D
March 17, 2020 09:42PM
377
C D
March 18, 2020 02:03PM


Sorry, only registered users may post in this forum.

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.