Error Message: Cannot Connect to Database Server

Question

I am trying to set up my SQL environment:

MacOS Sierra 10.12.6
MySQL Community Server 8.0.16 - macOS 10.14 (x86, 64-bit), DMG Archive (I have't found lower version)
MySQL Workbench 8.0.16 mysql-workbench-community-6.3.10-macos-x86_64.dmg

I am following this guide: https://youtu.be/7S_tz1z_5bA?t=836 For me when I click on "Test Connection" it gives the following error message:

Cannot Connect to Database Server

Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

I have found UNANSWERED questions similar to mine for PC and Linux.

Someone recommended Authentication plugin 'caching_sha2_password' cannot be loaded that it solves my question. It is not even the same error message because it asks about and error

Authentication plugin 'caching_sha2_password' cannot be loaded: 
dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

Possible duplicate of Authentication plugin 'caching_sha2_password' cannot be loaded — Matt
– Matt, Commented May 18, 2019 at 9:07
@nacho I am new to programing. I just know how to follow that video. I used the same password when it has asked for it. I have created that advanced password as well as in the video youtu.be/7S_tz1z_5bA?t=386 — sogu
– sogu, Commented May 18, 2019 at 9:08
@Matt I have read stackoverflow.com/questions/49194719/… but it have nothing to do with my post, not even the same error message. — sogu
– sogu, Commented May 18, 2019 at 9:10
@filt: Are you sure? It seems like the exact same error, word for word. Could you expand on why it isn't the same e.g. Additional information? — Matt
– Matt, Commented May 18, 2019 at 9:23

Amboss3 · Accepted Answer · 2020-04-29 00:05:17Z

2

You can just use PostgreSQL it is much more simple than MySQL

Their main website: https://www.postgresql.org/

From here you can download the version you want for macOS: https://www.postgresql.org/download/macosx/

I recommend the postures app because it has a GUI: https://postgresapp.com/

For client I recommend pgAdmin 4: https://www.pgadmin.org/download/pgadmin-4-macos/

There is a tutorial video as well: https://www.youtube.com/watch?v=wCMXbM5J0X8

answered Apr 29, 2020 at 0:05

Amboss3

364 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Turbo · Accepted Answer · 2019-05-18 09:09:23Z

1

you can change the encryption of the password like this.

ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

answered May 18, 2019 at 9:09

Turbo

13411 bronze badges

2 Comments

sogu Over a year ago

Is this a terminal command? Because I cant get in to start programing SQL at all at this point.

Turbo Over a year ago

@filt run this in ur terminal :netstat -apv TCP tell me what u see

Collectives™ on Stack Overflow

Error Message: Cannot Connect to Database Server

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related