MySQL with SSL

acrux · August 31st, 2004, 8:04 AM

If I have SSL installed on my server, does this also apply to the MySQL database server?

In particular, can I use the MySQL GRANT facility to require secure connections when allocating users to databases?

**Bigjohn** · August 31st, 2004, 8:07 AM

Can you give an example of why you'd need to do that?

Your "mysql" server is localhost, and the users are local too.

acrux · August 31st, 2004, 8:41 AM

Good point!

I think I'm getting to obsessed with security...!

**patrickb** · August 31st, 2004, 8:47 AM

Yes, maybe you are, but that isn't necessarily a bad thing. But to answer your original question, you don't have access to the GRANT function of mysql as it is, so it wouldn't matter in the first place.

The only way you can GRANT privileges is through Cpanel's user add feature under the Mysql section.

August 31st, 2004, 8:04 AM	#1 (permalink)
acrux Registered User Fresh Surpasser Joined in Jul 2004 5 posts Gave thanks: 0 Thanked 0 times	MySQL with SSL If I have SSL installed on my server, does this also apply to the MySQL database server? In particular, can I use the MySQL GRANT facility to require secure connections when allocating users to databases?

August 31st, 2004, 8:07 AM	#2 (permalink)
Bigjohn minor deity Super #1 Joined in Apr 2004 Lives in Georgia Hosted on XEON 7,395 posts Gave thanks: 28 Thanked 94 times	Can you give an example of why you'd need to do that? Your "mysql" server is localhost, and the users are local too. __________________ Proud to be a Surmunity Mod! XEON PASS60 PASS61 Make a fundamental difference! My Sites: Curious about Brewing Beer? Join the community! >>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax Get into an Art museum Victorian London It's your brain -*ON WEB* - mybrainhost.com (under development) What SHOULD Government do? Much Less than it Does!

August 31st, 2004, 8:47 AM	#4 (permalink)
patrickb the one who was Super #1 Joined in Jul 2003 Lives in Memphis 1,967 posts Gave thanks: 0 Thanked 3 times	Yes, maybe you are, but that isn't necessarily a bad thing. But to answer your original question, you don't have access to the GRANT function of mysql as it is, so it wouldn't matter in the first place. The only way you can GRANT privileges is through Cpanel's user add feature under the Mysql section. __________________ Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

August 31st, 2004, 8:41 AM	#3 (permalink)
acrux Registered User Fresh Surpasser Joined in Jul 2004 5 posts Gave thanks: 0 Thanked 0 times	Good point! I think I'm getting to obsessed with security...!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)