homepage Welcome to WebmasterWorld Guest from 54.211.113.223
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
MySql and data management
A good script?
cyclic

10+ Year Member



 
Msg#: 1173 posted 7:41 pm on Sep 3, 2002 (gmt 0)

Can anyone recommend a good script for data management on a PHP/MySql site. My server has an admin function on the control panel for MySql but I find it a little clunky after using MySql Front on my local machine.

 

Robber

10+ Year Member



 
Msg#: 1173 posted 9:44 pm on Sep 3, 2002 (gmt 0)

Hi Cyclic,

I have found phpmyadmin to be pretty good. I havent used it a great deal but it does the job, looks clean and is pretty easy to use.

rcjordan

WebmasterWorld Senior Member rcjordan us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1173 posted 9:51 pm on Sep 3, 2002 (gmt 0)

Gossamer Threads released a freebie script, I have no experience with it.

[gossamer-threads.com...]

jatar_k

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1173 posted 10:00 pm on Sep 3, 2002 (gmt 0)

I also used phpmyadmin and was suitably impressed.

brotherhood of LAN

WebmasterWorld Administrator brotherhood_of_lan us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



 
Msg#: 1173 posted 10:19 pm on Sep 3, 2002 (gmt 0)

me too with phpmyadmin,

Its simple to install, and once you get into it, you can look deeper at the SQL and PHP needed to do what you want - in the fastest way possible...

I'm getting into the habit of just using basic text files to build a db and upload them with the above program.

It's maybe also worth downloading php and mySQL to run on your own computer so you can get used to it without sitting through a not so good connection.

Lisa

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1173 posted 6:50 am on Sep 5, 2002 (gmt 0)

phpmyadmin is the way to go, Very sweet features and one of the few MySQL admins that continue to just get better and better.

cyclic

10+ Year Member



 
Msg#: 1173 posted 9:02 am on Sep 5, 2002 (gmt 0)

Thanks for all the advice. I have uploaded phpmyadmin onto my server and it is working quite nicely. The only thing that concerns me is security. I have setup the auth through HTTP, is this sufficient bearing in mind that there is no sensitive data in the database?

wharsono

10+ Year Member



 
Msg#: 1173 posted 11:13 am on Sep 6, 2002 (gmt 0)

PHPmyAdmin 2.30 Is the Best

ggrot

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1173 posted 2:12 pm on Sep 6, 2002 (gmt 0)

If you set up a mysql account that can be accessed by hosts other than localhost, you can also use mysqlfront (http://www.anse.de/mysqlfront/) which can run on your local machine. There are advantages of not being forced to create the entire interface in HTML (phpMyAdmin), but, I admin phpMyAdmin is an awesome product as well.

lorax

WebmasterWorld Administrator lorax us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1173 posted 2:38 pm on Sep 6, 2002 (gmt 0)

I totally concur - PHPMyAdmin is the cat's meow for having complete access to your MySQL db with tools for everything you'll need to do to maintain one or more dbs.

andreasfriedrich

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 1173 posted 3:09 pm on Sep 6, 2002 (gmt 0)

I like
mysql -h hostname -u username -p
best. ;)
jatar_k

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1173 posted 4:35 pm on Sep 6, 2002 (gmt 0)

I agree with that andreasfriedrich, it makes a lot more sense and is a lot easier that way. It gives you full control.

cyclic

10+ Year Member



 
Msg#: 1173 posted 8:02 pm on Sep 6, 2002 (gmt 0)

Thanks again everyone! I have been using MySqlfront on my local machine but my present host will not allow "anyone" access so I can't use it for a few of my sites. I now have a new host for my new sites which has phpmyadmin already installed which saves a lot of time.

MySql front appealed as it involved no control panels etc and I could get straight on and do some work!

How many hosts allow "anyone" access to their MySql databases?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved