Re: Cannot connect to database server

[Barry Galbraith]

I don't normally use Workbench, but I've installed it to see if I can help.
When I start Workbench, the Welcome screen shows a MySQL Connection for Local instance MySQL 8.0 root 127.0.0.1:3306
It also shows a + (to add another connection) and a spanner to view/edit the properties of this connection.
Clicking the spanner oneps a dialog labelled "Manage Server Connections"
On the left pane, click on the "Local instance MySQL 8.0" connection, and the right pane displays the parameters for that connection.
Hostname for me is 127.0.0.1
Port is 3306
Username is root
Password has a "Store in Vault..." button. Click that button to add (and store) root's password. You should have added a password for root when you installed the server. If you didn't add a password for root, then it has no password. Click on the "Clear" button if you want to remove the password from the Vault.
Press the "Test Connection" button (bottom right).
If no password is stored, you will be asked for root's password. If root has no password set, then leave it blank.
You should get a "Successfully made the MySQL connection" dialog.
You can now connect to MySQL. If root has no password, your first task is to set one, then go back and edit the properties of the connection again to save the root password in the vault.
If you set root's password, and can't remember it, then ther is a whole other process to reset root password.

Good luck,
Barry.