score:3
Accepted answer
Which version of the MySQL C connector are you using? MySql changed the default authentication protocol in MySQL 8, so I would suggest using the older C connector (any version older than 8). If you want to use the MySQL 8 connector then you will need to pass along default-auth=mysql_native_password in some fashion.
The same issue exists using the MySQL 8 C connector and connecting to an older version of MySQL (see https://bugs.mysql.com/bug.php?id=90994).
More questions
- Error connecting to memsql with mysql C connector
- Error connecting to memsql with mysql J connector
- SSL Connection Error while using MySQL Connector with Python
- password error connecting to mysql database with python 3.3.1
- Error building program with MySQL Connector C++
- Connecting with remote mysql database, getting the error "Unable to connect to any of the specified MySQL hosts"
- Why I get this error 'CommunicationsĀ linkĀ failure TheĀ lastĀ packetĀ sent...' when connecting to MySQL with Java (Netbeans)?
- Error Building Program with mysql connector
- Getting a mysql 2002 error only when using localhost (rather than 127.0.0.1) when connecting to mysql with php
- VS Express 2013 C++ with MySQL Connector stmt->executeQuery() error
- Error in Connecting with MySql with Asp.net
- Add MySQL Table with python connector fails to add table without throwing error with multi=True
- Error while connecting MYSQL with logstash
- Print cursor.statement with parameters at error mysql connector
- Error getting connection with MySQL connector
- Installing MySQL in Docker fails with error message "Can't connect to local MySQL server through socket"
- ERROR 1148: The used command is not allowed with this MySQL version
- Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
- error connecting to database with mysqldriver
- Can't connect to remote MySQL server with error 61
- MySQL error 1436: Thread stack overrun, with simple query
- MYSQL update with WHERE SELECT subquery error
- Stuck in error 2 with mysql using XAMPP
- MySQL Error 1064 when adding foreign key with MySQL Workbench
- MySQL connector error "The server time zone value Central European Time"
- MySQL fulltext search with @ symbol produces error "syntax error, unexpected '@', expecting $end"
- Foreign Key add fails in MySQL with Error Code 1005, number 150
- Connecting to MySQL from Android with JDBC
- Freak MySql error with MAMP
- MySQL Replication fails with error "Could not parse relay log event entry."
More questions with similar tag
- Storing value from SELECT to a variable
- How to insert new (only changed) lines from a csv file into a mysql table
- Mysql: Not more than 10 but at least 3 results
- How to get rid of duplicated values in LEFT JOIN SQL Query
- Create demo of admin control panel
- How to generate DDL for all tables in a database in MySQL
- MySQL Creating temporary table syntax error
- Add text to a field with sql query
- Allowing user to manipulate images rendered in browser - API recommendation?
- Distinct pairs MySQL
- Error while generating views with with Mysql and EF6
- Count of rows in Doctrine 2
- How to obtain parent child relationship in EXPRESSJS/MYSQL?
- Are LEFT JOIN subquery table arguments evaluated more than once?
- SQL Table Split-Is it necessary
- Insert into free id MYSQL
- Search for text between delimiters in MySQL
- How does an incoming request to a nodejs server get handled when the event loop is waiting for a DB operation
- How can I login to all parts of my website using all login forms?
- How do I output the result from an sql query onto the screen in php
- ERROR: org.hibernate.util.JDBCExceptionReporter - Cannot load JDBC driver class 'com.mysql.jdbcDriver'
- How to DELETE in mysql without dropping primary and foreign constraints
- MySQL Order By Slows down Joins
- MySQL localhost access denied, until flush
- C# MySQL claims a field is too long
- How to query the inverse of a self-referential "has_many :through" relationship in Rails?
- MySQL:putting constraint on each character of a Column entry of char(n) type
- External MySQL database in Kotlin
- mysql: get distinct value of TEXT
- MySQL (InnoDB) Select from 2 tables and always get empty result set
Source:
stackoverflow.com