Cant reset the password for mysql, missing mysql_safe.

[deep1234]

Hi guys. I fresh install mysql on centos7 but I cant login with root. I am trying now to reset the password but it seems that there is a missing file (mysqld_safe).

 

-- First --

[root@arkan-clearos-lan ~]# sudo systemctl stop mysqld

 

-- Then --
[root@arkan-clearos-lan ~]# sudo mysqld_safe --skip-grant-tables &
[1] 1041
[root@arkan-clearos-lan ~]# sudo: mysqld_safe: command not found

 

Link : https://www.linode.com/docs/databases/mysql/how-to-install-mysql-on-centos-7

 

Please advise me.

 

And Thank you.

[shockz]

You probably have to run the mysql_secure_installation and go through the initial setup. There are other ways to configure sql but that's probably your best bet with the limited info you provided.

[deep1234]

I tried the mysql_secure_installation. But it is asking for the root password and it is not accepting it. 

 

I am willing to provide any extra info needed.

[pqt]

Perhaps no password is set yet? If you haven't set it up, there may just be no password at all.