I have installed fresh MySQL server on CentOS, and started the MySQL server service with command.
# /sbin/service mysqld start
I checked the service and it is running.
Currently I am logged in as
root@localhost. I want to changed the password for
root. For this I have issued the command:
Once I issued this command, system is asked for password, I tried to just hit "enter". This does not work. Also, tried my Linux root password that also does not work.
When I tried to hit enter I am getting:
Error: Access denied for user 'root'@'localhost' (using password : NO)
When I tried with Linux box local root password I am getting:
Error: Access denied for user 'root'@'localhost' (using password : YES)
Other than local machine
root password, it did not ask me for any password during installation time. What I am missing here? What should I do to login from the mysql-workbench? Thanks.