MySql Security Query

 
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions
View previous topic :: View next topic  
Author Message
mjjk91
-


Joined: 03 Feb 2004
Posts: 75
Location: Australia

PostPosted: Mon Sep 13, 2004 12:54 am    Post subject: MySql Security Query Reply with quote

G'Day All,

I am running MySQL successfully with the abyss web server. I just have a question about security. I have password protected the MySQL database server, but, i would like to know what else i could do to protect it? At the moment, my database can still be accessed via the internet "http://URL/phpmyadmin", and if someone was to have appropriate software, or just guess my password, they would have access to my database, which is obviously a lot of trouble. So, any ways i can highten the security on the MySQL database. Ideally, i would love to just have it running locally, that way it cannot make the Internet. Is this possible? How would i go about it?

Cheers all

Mick Koch
Back to top View user's profile Send private message Visit poster's website MSN Messenger
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Mon Sep 13, 2004 1:52 am    Post subject: Reply with quote

Use the beta version of Abyss and setup a IP Controle record , I do this for
my phpMyAdmin , it only allows you to access it locally. Hope That Helps!
Back to top View user's profile Send private message Visit poster's website
mjjk91
-


Joined: 03 Feb 2004
Posts: 75
Location: Australia

PostPosted: Mon Sep 13, 2004 3:45 am    Post subject: Downloaded, now the rest Reply with quote

Okies, i have downloaded the beta and have found the IP Control screen. Currently, there is only access for http://127.0.0.1. What would i need to add to protect my phpmyadmin database? Would i simply just add a deny ip record to http://URL/phpmyadmin?

Cheers

Mick Koch
Back to top View user's profile Send private message Visit poster's website MSN Messenger
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Mon Sep 13, 2004 4:15 am    Post subject: Reply with quote

No , you have to add a record for the allowed IP and set it to Allow/Deny in
the Order field , this will make sure only localhost is allowed in that path.

Virtual Path: /phpmyadmin
Order: Allow/Deny
Allowed IP's: 127.0.0.1
Back to top View user's profile Send private message Visit poster's website
mjjk91
-


Joined: 03 Feb 2004
Posts: 75
Location: Australia

PostPosted: Mon Sep 13, 2004 4:47 am    Post subject: Working!! Reply with quote

beautiful, works great. Cheers mate.

Mick Koch
Back to top View user's profile Send private message Visit poster's website MSN Messenger
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Mon Sep 13, 2004 5:36 am    Post subject: Reply with quote

Hey , any time , glad I could solve your problems.
Back to top View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group