MYSQLR Stuck if we Change Root password.

[haridas]

Hi,

I'm using the MYSQLR64 in none replication mode, it will start first time with out any problem. If we change the root password of the mysql, it will stuck next time we restart..I dont know why. Please help me to find the reason ..?

[Jsmart]

Hey,

what version of MYSQLR64 and WHAT version AppLogic?

the full datasheet on the MYSQLR64 appliance can be found here.
http://doc.3tera.com/AppLogic29/CatDatabaseAppliancesMySQLR.html

Regards,
Jessie

[haridas]

Hi Jsmart,

Thanks for reply.

Applogic Version : - 2.9.1 beta

MYSQLR64 :- 1.6.13-1
CentOS 5 (64 bit)
MYSQL :- 5.0.77


Let me know if there is any problem with this beta version .

[PavelGeorgiev]

Hi,

Starting MYSQLR 1.6.2 you can set/change a password for the root account. However, the MSYQLR appliance has a few root accounts with different hostnames. When setting a password, you should use the root@% account, it is what is used for connections coming on the 'in' terminal. The other root accounts are used only from local users and you should not se a password for them as this will make your appliance fail to start.
Leaving root@localhost without a password is not a security issue as whoever has access to the appliance can change the password anyway.

If you need to recover your appliance (I presume you set a password for some of the local root accounts), you can:

1) comp start --debug (or app start --debug), you dont have to wait for the appliance to time out, you should be able to login to it few seconds after you start it.
2) login to the appliance and do:

mysql -p -e "update mysql.user set Password='' where User='root'"
mysqladmin -p flush-privileges
mysql -e 'update mysql.user set password=PASSWORD("NEWPASSWORD") where User="root" and Host="%"'
mysqladmin flush-privileges

3) restart the appliance to verify that it boots and root can't use password-less login on the in terminal


Hope that helps,
Pavel

[haridas]

Hi PavelGeorgiev,

Thanks for the explanations given for the problem. The information is very helpful. I stuck with this for last few days.

I did exactly what you said, its working perfectly well.