mySQL database administration scripts?

[sun818]

Hi, I am using a popular web host that only allows shell access to mySQL. Can anyone recommend a free db admin script that will let me do basic functions that will at least let me select, update, delete, truncate, and drop?

[jatar_k]

aren't phpmyadmin and mysqlfront free?

[lorax]

... only allows shell access to mySQL

Really? Would they allow you to use PHPMyAdmin?

[sun818]

I should clarify - I don't the webhost objects to my using a script -- they don't provide one by default. I'm not familiar with mySQL so I appreciate the suggestions for phpmyadmin and mysqlfront.

[lorax]

I would highly recommend PHPMyAdmin. It's a very handy and easy to use script. Robust and offers things like table & data dumps, imports, SQL queries and table/data optimization.

[jatar_k]

I agree, I think PHPMyAdmin is the better one but I know some members prefer mysql front.

[amue1977]

They should allow you to phpmyadmin.
After all you have to acces mysql on your pages, and imho the easiest way is php.
phpmyadmin is just that . a bunch of php scripts to handle your db.

Using it really is easy: just copy to your server and edit the mysql server part in config.inc.php. It has a lot of comments that should get you there.

Easy Testing: put a php file on your server like
<?php
phpinfo();
?>

name it test.php or whatever and call it from your browser. It will give you all the environment data on Php and includes MYSQL info. If that's there, then myadmin should work.

[sun818]

Finally had my webhost install phpMyAdmin. Very cool. I have to admit, its a lot easier using a GUI to delete a row rather than having to type out the SQL. Thank you everyone for your recommendation!