Can't connect laravel to managed mysql (Error 2054 (HY000) The server requested authentication method unknown to the client)
I am trying to connect my laravel app (currently on my Mac) to my managed mysql db. My IP is entered as a trusted source. I was getting a different error until I followed the tutorial and used the flags connection script to connect. Now I get
error: 2054 The server requested authentication method unknown to the client.
I am connecting as follows:
DB_CONNECTION=mysql DB_URL="mysql -u my_username -p my_password -h db-mysql-nyc1-my_database_info.db.ondigitalocean.com -P 25060 -D IHC" DB_HOST=db-mysql-nyc1-my_database_info.db.ondigitalocean.com DB_PORT=25060 DB_DATABASE=IHC DB_USERNAME=my_username DB_PASSWORD=my_password DB_SSLMODE=REQUIRED MYSQL_ATTR_SSL_CA=/Users/melaniecarr/Desktop/ca-certificate.crt
How on earth do I connect this thing?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×