Topic: Managing MySQL

[Robert Heaton]

Anyone know a MySQL manager, for creating/viewing current SQL databases??
Is there an RPM that slots into the e-smith manager???

Thanks is advance,
Rob.

[Bill Scobie]

PHPMyAdmin is what you are looking for, I think. And, look for it at http://www.e-smith.org/contrib/rpm-index/RPM-e-smith-phpmyadmin-0.2-3.noarch.html

[Robert Heaton]

Thanks Bill

Rob

[Sidney]

Hello,
  how do you manage Mysql outside of the network?

[Craig Bursey]

You install PhpMyAdmin in an IBAY with a password for the internet.  Works for me

Craig

[Noah]

Sidney wrote:
>
> Hello,
>   how do you manage Mysql outside of the network?

Install phpMyAdmin on your server (the easiest way is to put it in an i-bay) and enable Advance Authetication (the phpMyAdmin distribution has info on this).  When you use Advance Authentication, phpMyAdmin prompts you for a username and password that it then uses to connect to your MySQL server.  In other words, phpMyAdmin only runs with the permissions granted to the user who logs on.  This is particularly useful if you have multiple users accessing MySQL.

The one dis-advantage of Advance Authentication is that you can not install it in a password protected i-bay (well, if you can, I haven't figured out how).

Noah