Problems with accessing mysql with/without ssl.
am 04.11.2003 14:13:48 von Arkadiusz MiskiewiczI have some db - ''somedb".
GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'%' identified by 'pass_1'
GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'1.2.3.%' identified by 'pass_2'
and now I can connect to database only from '1.2.3.%' with 'pass_2'.
Weird but logical way would be if I'm matching 1.2.3.% then check for pass_=
2=20
and if not then check for pass_1. Same applies to ,,REQUIRE SSL'' rules.
=46or example now I don't see a way to give some user permission to connect=
to=20
my database from local network without using SSL and from other networks wi=
th=20
SSL only... something like
GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'%' identified by 'pass_1' REQUI=
RE=20
SSL
GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'192.168.0.%' identified by=20
'pass_1'
Also plase look at http://lists.mysql.com/bugs/14331. The issue is still th=
ere=20
in 4.0.16.
=2D-=20
Arkadiusz Mi=B6kiewicz CS at FoE, Wroclaw University of Technology
arekm.pld-linux.org AM2-6BONE, 1024/3DB19BBD, arekm(at)ircnet, PLD/Linux
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org