CODEWITHSUNDEEP
mysqlsql
sogu
sogu

Reputation: 3076

Error Message: Cannot Connect to Database Server

I am trying to set up my SQL environment:

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

Upvotes: 2

Views: 1145

Answers (2)

Amboss3
Amboss3

Reputation: 36

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

Upvotes: 2

Turbo
Turbo

Reputation: 134

you can change the encryption of the password like this.

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

Upvotes: 1

Related Questions