gareth wrote: > On Tue 2006-05-09 (11:47), DongInn Kim wrote: > >> Try the following SQL to see if root user has set "Y" to the >> "Reload_priv". If not, try to set it. >> mysql> select Host, User, Password, Reload_priv from mysql.user; >> +-----------+-----------+------------------+-------------+ >> | Host | User | Password | Reload_priv | >> +-----------+-----------+------------------+-------------+ >> | localhost | root | | Y | >> | oscar-fc3 | root | | Y | >> | localhost | | | N | >> | oscar-fc3 | | | N | >> | localhost | oscar | 0a085b715cbc5737 | N | >> | % | oscar | 0a085b715cbc5737 | N | >> | % | anonymous | | N | >> +-----------+-----------+------------------+-------------+ >> 7 rows in set (0.00 sec) >> >> mysql> \q >> And then restart mysqld to reload your changes forcibly. >> /etc/init.d/mysqld restart >> > > ok: > > mysql> select Host, User, Password, Reload_priv from mysql.user; > +-----------+-------+------------------+-------------+ > | Host | User | Password | Reload_priv | > +-----------+-------+------------------+-------------+ > | localhost | oscar | 2bc01e026ddecc90 | Y | > | localhost | root | | N | > +-----------+-------+------------------+-------------+ > 2 rows in set (0.00 sec) > > mysql> use mysql > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > mysql> UPDATE user SET Reload_priv ='Y' WHERE User = 'root'; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > > > mysqld restarted, and now it works, i can run install_cluster, thanx ;) > > although, as you can see from the first query, there was no > root password hash showing before i updated the Reload_priv, > though i needed a password to get in. i didn't run > "update user set Password='' where User='root' and Host='localhost';" > again after Reload_priv was updated, and it worked, doesn't make > sense to me but hey. > Gareth, Yes, it is my mistake. OSCAR does not care of whether a root account has set a password or not because OSCAR database codes can handle the both cases. I am sorry that I told that it does. The issue was that your root account did not have "Reload_priv" and this caused the access denied errors while changing the database tables (i.e., this needs root's "Reload_priv" : flush privileges). I hope this is clear now.
Regards, - DongInn ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Oscar-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oscar-users
