MYSQL server 8.0.13 and workbench 8.0.13 was working fine till suddenly the password was not accepted.
And so I can't log in and use the database.
I then decided to go to the re-configure available in the MYSQL Installer for Windows 10 but when it comes to the keying in password, the check button just gave me a red x and I can't continue the re-configuration.
So, I re-set my password again.
I am stumped and tired from trying all ways to revive MYSQL server and make MYSQL server to accept the password.
I have also granted all level of permissions to all users in accessing MYSQL server etc in Windows 10.
Please let me know how to make MYSQL server accept the password.
My latest attempt shows that it seems Windows allow me to log in already but I am not sure. cos it shows an id there.
C:\Program Files (x86)\MySQL\mysql-8.0.13-winx64\bin>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.13 MySQL Community Server - GPL
There's nothing wrong with your second post. It's opening a mysql shell session for the userid "root". Although root is not the userid you should use except for administrative tasks.
Your first post failed because you attempted to connecto to the MySQL server using userid "ODBC". MySQL is quite serious about security and will only allow authorized users to connect to it, and further, it restricts what machines the connections may be done from and what database the connection is allowed for. You may need to adjust your GRANT rights for the database you wish to talk to.
Also note that MySQL is a program originally designed for a Unix-like environment, so user IDs and passwords are case-sensitive!
Bjoke: A "Bully Joke". A Statement or action made with malicious intent - unless challenged. At which point it magically transforms into "I was just funnin'" or "What's the matter, can't take a joke?"