Estoy trabajando con linux, he instalado el mysql-server, y el mysql-client.
Después he hecho una configuracion con el mysql_secure_installation, he establecido una contraseña al usuario root, y he lo configurado todo a mi gusto.He estado probando con el MySQL Workbench a conectarme a mi servidor, en mi caso es localhost, pero me da este error:
Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at localhost:3306:
Access denied for user 'root'@'localhost'
1 Check that mysql is running on server localhost
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 localhost 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 localhost connecting from the host address you're connecting from
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.