On Fri 2006-05-05 (17:09), DongInn Kim wrote:
> [EMAIL PROTECTED] ~]$ mysql --version
> mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
>
> So, what version of mysql do you use? What distro do you use?
# mysql --version
mysql Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (x86_64) using readline 4.3
# cat /etc/redhat-release
Scientific Linux SL release 4.2 (Beryllium)
> But probably you'd better set "Y" on all the *_priv columns except for
> "Grant_priv" for the first query (for localhost access).
> INSERT INTO db VALUES
> ('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
> For % host and oscar user, you'd better set "Y" on
> {Select,Insert,Update,Delete}_priv
> INSERT INTO db VALUES
> ('%','oscar','oscar','Y','Y','Y','Y','N','N','N','N','N','N');
> For anonymous user, you should set "Y" on only "Select_priv".
> INSERT INTO db VALUES
> ('%','oscar','anonymous','Y','N','N','N','N','N','N','N','N','N');
ok thx, i've done that, and end up with:
mysql> SELECT * FROM mysql.db;
+-----------+-------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
+-----------+-------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
| localhost | oscar | oscar | Y | Y | Y | Y
| Y | Y | N | Y | Y |
Y | Y | Y |
| % | oscar | oscar | Y | Y | Y | Y
| N | N | N | N | N |
N | Y | Y |
| % | oscar | anonymous | Y | N | N | N
| N | N | N | N | N |
N | N | N |
+-----------+-------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+
3 rows in set (0.00 sec)
but still left with the problem that the root user has a password, which's what
install_cluster moans about:
Creating the OSCAR database ...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO)
/opt/oscar/scripts/package_config_xmls_to_database: cannot create the OSCAR
database at /opt/oscar/scripts/package_config_xmls_to_database line 228.
-------------------------------------------------------
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
