Problems with accessing mysql with/without ssl.
Arkadiusz Miskiewicz <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Organization | SelfOrganizing |
| Message-ID | <[email protected]> |
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 and if not then check for pass_1. Same applies to ,,REQUIRE SSL'' rules. For example now I don't see a way to give some user permission to connect to my database from local network without using SSL and from other networks with SSL only... something like GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'%' identified by 'pass_1' REQUIRE SSL GRANT ALL PRIVILEGES ON somedb.* TO 'user'@'192.168.0.%' identified by 'pass_1' Also plase look at http://lists.mysql.com/bugs/14331. The issue is still there in 4.0.16. -- Arkadiusz Miśkiewicz 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/[email protected]