Gareth, 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 Now I think root can access db without password because your update (delete root password) is reloaded. Regards, - DongInn gareth wrote: > 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 > > Database changed > mysql> update user set Password='' where User='root' and Host='localhost'; > Query OK, 1 row affected (0.04 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > mysql> flush privileges; > ERROR 1227 (HY000): Access denied; you need the RELOAD privilege for this > operation > mysql> > > > ------------------------------------------------------- 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
