[SOLVED] Unable to change MySQL root password

[fossxplorer]

Just intalled a new Kloxo, but can't change root password for MySQL:
[root@odcp01 ~]# sh /script/reset-mysql-root-password mypassword
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)
[root@odcp01 ~]#

Solved my mysqld --skip-grant-tables

[MRatWork]

Always infom 'sh /script/sysinfo' for asking.

[fossxplorer]

In CentOS7, you can't FIRST change the MySQL root password from the web UI.
I had to change it manually using mysql --skip-grant-tables, then when password was working ok, i could change it from Kloxo-MR with same password to get the "SQL Manager" login without password for admin.

[MRatWork]

Yes, reset mysql root password from panel still trouble under CentOS 7.

BTW, what's you mean 'using mysql --skip-grant-tables'?.

[fossxplorer]

I mean to reset lost mysql password from command line in Linux:
https://help.ubuntu.com/community/MysqlPasswordReset

Actually, you have to use mysqld --skip-grant-tables --user=mysql, otherwise it won't work, at least in CentOS7.

[MRatWork]

Kloxo-MR using different method. Yes, I will add '--skip-grant-tables' to fix this issue. Sadly reset from panel still not work.

[fossxplorer]

Ok, good.

Yes, it doesn't work from web UI, but the workaround is to change it from command line and then use the same password from the web UI (MySQL Password Reset). Then at least the SQL Manager will work for the admin (otherwise it will work,but you must type in password manually).

[BigWeb.EU]

OK, this issue came back on CentOS 6.9

Code: [Select]

[root@data etc]# sh /script/reset-mysql-root-password pass1234
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Access denied for user 'root'@'localhost' (using password: YES)

GUI change does not work as well. Need fats solution on how to reset root password ?