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. ------------------------------------------------------- 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
