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 OK.

Currently I am logged in as root at localhost. I want to changed the password for root. For it I have issued the command

/usr/bin/mysql_secure_installation

Once I issued this command, system is asked for password, I tried hit "enter". This does not work. Also, tried my linux box 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 password I am getting

Error: Access denied for user 'root'@'localhost' (using password : YES)

Other than localbox 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

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:

/usr/bin/mysql_secure_installation

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.

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 OK.

Currently I am logged in as root at localhost. I want to changed the password for root. For it I have issued the command

/usr/bin/mysql_secure_installation

Once I issued this command, system is asked for password, I tried hit "enter". This does not work. Also, tried my linux box root password that also does 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 password I am getting

Error: Access denied for user 'root'@'localhost' (using password : YES)

Other than localbox 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

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 OK.

Currently I am logged in as root at localhost. I want to changed the password for root. For it I have issued the command

/usr/bin/mysql_secure_installation

Once I issued this command, system is asked for password, I tried hit "enter". This does not work. Also, tried my linux box 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 password I am getting

Error: Access denied for user 'root'@'localhost' (using password : YES)

Other than localbox 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