Whenever I want to open a mysql in my windows cmd by simply typing mysql. I am facing below error :
“ERROR 1045 (28000): Access denied for user ODBC@localhost (using password: NO)”
After that by looking at similar queries I somehow got the temporary solution by using the C:> mysql -u root -p and then typing the required password, then mysql is working. But when I close and reopen it, the same problem is happening.
One more issue is that I have created the user 'admin'. but when I am trying to open the mysql using the command as below :
C:> mysql --user=admin --password=root,
The following error is showing up again :
C:\Users\alecxe>mysql --user=admin --password=root
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:NO)
Any pointers will be the great help.