MySQL Curses interface
Tony Baechler
tony at baechler.net
Wed Apr 9 08:48:53 UTC 2008
Thanks, this helps. I assume you put the statements in a .htaccess
file? I don't remember what security features PHPMyAdmin offers. I
only looked at it briefly and found it confusing, but I guess if it's
that or nothing, I'll learn it. It would be nice to just have the same
basic functionality in a curses interface that would run on the local
server and avoid the issue but I guess there is no such thing. I should
add that the MySQL Monitor has readline support and works fine from a
shell but requires knowledge of the SQL syntax. The reference manual is
huge as I found out when I was looking at it.
John G. Heim wrote:
> Yeah, you probably don't want your phpMyAdmin installation accessible
> from just anywhere. Making it accessible only from localhost was just
> an idea I had predicated on the assumption that you weren't already
> running a web server.
>
> Volumes can and have been written on securing apache. I haven't putzed
> with phpMyAdmin for a while and I don't recall what security features
> it offers. But some of the things you could do via apache are:
>
> 1. Make the phpMyAdmin site accessible only to certain IP addresses
> 2. Require a user ID and password to connect
>
> Point #1 above would include making it accessible only from the
> localhost. Or you could tell apache to allow access only from the
> localhost and some static IP address like that of your workstation.
> Here is how I restrict access to server status reports on an apache
> server to computers at the University of Wisconsin Math Department and
> to my machine at home:
>
>
> <Location /server-status>
> Order deny,allow
> Deny from all
> Allow from .math.wisc.edu lambeau.johnheim.com
> </Location>#
More information about the Blinux-list
mailing list