View previous topic :: View next topic |
Author |
Message |
mjjk91 -
Joined: 03 Feb 2004 Posts: 75 Location: Australia
|
Posted: Mon Sep 13, 2004 12:54 am Post subject: MySql Security Query |
|
|
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 |
|
 |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Mon Sep 13, 2004 1:52 am Post subject: |
|
|
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 |
|
 |
mjjk91 -
Joined: 03 Feb 2004 Posts: 75 Location: Australia
|
Posted: Mon Sep 13, 2004 3:45 am Post subject: Downloaded, now the rest |
|
|
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 |
|
 |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Mon Sep 13, 2004 4:15 am Post subject: |
|
|
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 |
|
 |
mjjk91 -
Joined: 03 Feb 2004 Posts: 75 Location: Australia
|
Posted: Mon Sep 13, 2004 4:47 am Post subject: Working!! |
|
|
beautiful, works great. Cheers mate.
Mick Koch |
|
Back to top |
|
 |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Mon Sep 13, 2004 5:36 am Post subject: |
|
|
Hey , any time , glad I could solve your problems. |
|
Back to top |
|
 |
|