Working with MySQL / PHP

[Anon]

Originally a Perl programmer, I recently switched briefly to ASP and then (permanently?) to PHP. I have never worked with MySQL - in fact, I'm used to working with MS SQL Server 7 on an NT box.

I'm trying to get started with MySQL, as it seems to be the db of choice for PHP/Linux, and I'm having some trouble coming to grips with the lack of user-friendly interface (like SQL Server's Enterprise Manager). Do MySQL databases have to be managed completely with code? What is everyone's advice on how to create/view/manage MySQL databases?

I find it somewhat unsettling that there's no way to directly view the data in the database (that's quite a generalization, and probably sounds foolish).

Thanks for helping out a beginner.
Keegan Miller

[Anon]

Hello

There is a program you might want to try, it's called phpmyadmin.

Some clever people/person has written this for us PHPers and it allows you to administer your DB's through a browser.

I THINK that the windows version of mysql has a GUI interface but I'm not certain.

TIP: I don't know if everybody already does this but, anyway...

...usefull code like setting up a new user or setting privileges, I keep in a text file that way I can just change a few variables and paste it into telnet.

Nath

[Anon]

You might already know this, but this certainly tripped me up when I first started.

If you want to manage your databases, make sure to install both the mysql server daemon (which you probably already have) and the mysql client. Although the client is text based, it allows you to use SQL commands to view and work with your databases. You can get both from mysql.com.