YES! 4.0.8 works. Problem is fixed. I guess it was a bug.
Thanks all!
:-)
mike markovich wrote:
MySQL 4.0.8 was just released. I suggest upgrading to 4.0.8. If
that doesn't fix the problem then I would report it as a bug on the
bugs list.
Regards, Mike
-----Original Message----- From: raffi@xxxxxxxx
[mailto:raffi@xxxxxxxx] Sent: Wednesday, January 08, 2003 8:22 AM To:
mike markovich; java@xxxxxxxxxxxxxxx Subject: The problem gets deeper
still
Unfortunetly, creating the dwarves database first doesnt change the
outcome. Also, the problem is deeper. If you do what the code says
just using the mysql client, you get the same problem. Its not just a
java thing.
In other words... install a fresh mysql 4 and do this.... mysql -u
root mysql> create database dwarves; mysql> grant all privileges on
*.* to doc identified by 'doc' with grant option; mysql> grant all
privileges on *.* to doc@localhost identified by 'doc' with grant
option; mysql> exit
mysql -u doc -pdoc mysql mysql> grant all privileges on dwarves.* to
dopey identified by 'dopey'; Access denied for user: 'doc@xxxxxxxxx'
to database 'dwarves'
Here is what the mysql.user and mysql.db tables look like after the
code is run...
+-----------+------+------------------+-------------+-------------+-------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+
| Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y
| Y | | % | root | | Y | Y
| Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | |
localhost | | | Y | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | | %
| | | N | N | N | N
| N | N | N | N | N | N
| N | N | N | N | | % | doc
| 7b135fb822ad6e43 | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | | localhost | doc |
7b135fb822ad6e43 | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y |
+-----------+------+------------------+-------------+-------------+-------------+
6 rows in set (0.00 sec)
+------+-------+------+-------------+-------------+-------------+-------------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+------+-------+------+-------------+-------------+-------------+-------------+
| % | test% | | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
+------+-------+------+-------------+-------------+-------------+-------------+
1 row in set (0.01 sec)
mike markovich wrote:
Hi,
I ran your code on my box with MySQL 3.23 and it runs fine. Just
curious, but what happens if you create the "dwarves" database
before you grant access to "doc". If this works then something has
probably changed with granting super user access in MySQL 4.0.
Please let me know what you find out.
Mike
-----Original Message----- From: raffi@xxxxxxxx
[mailto:raffi@xxxxxxxx] Sent: Monday, January 06, 2003 1:10 PM To:
java@xxxxxxxxxxxxxxx Subject: mysql 4 doesnt match ip address to %
???
Hi all.
Does anyone know why the following code DOES NOT work on mysql
4.0.7-nt gamma and it DOES work on MySQL 3.23.whatever-nt.
Here is what you will get on MySQL 4... General error: Access
denied for user: 'doc@xxxxxxxxx' to database 'dwarves'
I've tested on a brand new installation as well. Same problem.
Why??? Thanks.
--------- example code ------------
public static void main(String[] args) { try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection
c =
DriverManager.getConnection("jdbc:mysql://localhost/","root","");
System.out.println("connected to database as root"); Statement stat
= c.createStatement(); stat.execute("create database dwarves");
stat.execute("GRANT ALL PRIVILEGES ON *.* TO doc IDENTIFIED BY
'doc' WITH GRANT OPTION"); stat.execute("GRANT ALL PRIVILEGES ON
*.* TO doc@localhost IDENTIFIED BY 'doc' WITH GRANT OPTION");
c.close();
Connection cc =
DriverManager.getConnection("jdbc:mysql://localhost/","doc","doc");
System.out.println("connected to database as doc"); stat =
cc.createStatement(); stat.execute("GRANT All PRIVILEGES ON
dwarves.* TO dopey IDENTIFIED BY 'dopey'"); stat.execute("GRANT All
PRIVILEGES ON dwarves.* TO dopey@localhost IDENTIFIED BY 'dopey'");
c.close(); } catch (Exception e) {
System.out.println(e.getMessage()); } }
--
Raffi Minassian
DCIT Corporation
http://www.dcit.com
============================================================
** Nothing is so embarrassing as watching someone do
something that you said couldn't be done. **
============================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <java-thread4877@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <java-unsubscribe-gcdmj-java=m.gmane.org@xxxxxxxxxxxxxxx>
| 