Problems with accessing mysql with/without ssl.

I 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

Re: Problems with accessing mysql with/without ssl.

Hi!

On Nov 04, Arkadiusz Miskiewicz wrote:
> I 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'.

Do you mean that you cannot connect from 4.3.2.1 with 'pass_1' ?

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org