On Tue 2006-05-09 (09:57), DongInn Kim wrote:
> There is no root password for database on OSCAR. I think if a user sets
> up a root password, we need to change the codes to use the existing root
> password for OSCAR.
> I don't think we have set it up yet. BTW, if you don't care of not
> having a root password for now, please remove the root password and try
> to run the install_cluster script again.
> 
> mysql> use mysql;
> mysql> update user set Password='' where User='root' and Host='localhost';
> mysql> flush privileges;

nope we don't care if root has a password, for now, i tried that:

# mysql -u root -ppasswd
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 350 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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

Reply via email to