When I try to add a new data source from MySQL I get this error:
Connection verification failed for data source: entry
java.sql.SQLException: Invalid authorization specification: Access denied for user 'root'@'localhost' (using password: NO)
The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user 'root'@'localhost' (using password: NO)
root has all global priveleges
when adding the data source i use the username: root and password is blank
any ideas?
but when i enter in the password for MySQL i get this error when adding the data source:
Connection verification failed for data source: entry
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?