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.
Subject
Views
Written By
Posted
Connect to MySQL 8 from Workbench
4713
March 17, 2020 09:03PM
1276
March 17, 2020 09:31PM
899
March 17, 2020 09:42PM
916
March 18, 2020 09:52AM
983
March 18, 2020 02:03PM
790
March 20, 2020 11:24AM
811
June 14, 2020 08:53PM
842
June 15, 2020 11:47AM
1391
June 19, 2020 02:23PM
614
June 19, 2020 02:26PM
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.