Broken MySQL Authentication

[tupson]

Greetings,

I am running the Turnkey Linux Appliance v14 that has OTRS v3.3.9 embed. When trying to resolve my ongoing issue with the OTRS Scheduler not running, I went into MySQL (by default was configured with root and configured password on build process) and I changed the binding IP Address from 127.0.0.1 to the custom Appliance IP Address (assuming this wouldn't break anything). After I hit SAVE, it indicated that the permissions bound to 127.0.0.1 were lost and that I had to re-authenticate credentials to MySQL to proceed with the changes.

Clearly, none of the passwords I set during the initial appliance install are taking.

Error:

The full MySQL error message was : DBI connect failed : Access denied for user 'root'@'localhost' (using password: YES)

I have tried the following:

host: /etc/init.d/mysql stop
host: mysqld --skip-grant-tables &
host: mysql -u root mysql
host: UPDATE user SET Password=PASSWORD('MYNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

I have even tried the following:

Webmin -> Servers -> MySQL -> Module Config, and in the field "Administration password", tried resetting the password that I originally set up.

How do I resolve this?

I could have sworn it asked me to create a Root password for the OS and MySQL; which I did, so why isnt this password working?

I went into the /etc/mysql/my.cnf file to change the IP Address Binding back to 127.0.0.1, saved and reset the server, but the credentials are still borked.


Help... this has ruined my connection to my OTRS Ticketing System as well.

[jojo]

please read the mysql manual. MySQL user always are bound to hosts (might even be a wildcard like %)