Neverside

MySQL control panel?

Hi

I'm new to this whole PHP "open-source" thing... as many of you know, I prefer to stay in the relm of .Net (Long Live Bill Gates!!!</sarcasm>)

Anyway.....

one of my clients uses PHP and a MySQL database

Now, whilst I know the basics of PHP, I'm kinda confuzzled about MySQL

I'm used to MDBs... just upload in FTP and write a connection string, and you're done

But with MySQL, you don't really have physical access to the database

....So how do you edit the database properly?

I read *somewhere* that there's some PHP-based application you can get to administer MySQL databases, I checked on MySQL's website, but I couldn't find anything

Yes, I know I could write it myself... but I don't really want to write a load of SQL INSERT statements, blegh

Ciao

___________________

http://www.phpmyadmin.net/home_page/

if you find phpMyAdmin too daunting, ive created a similar script thats waay easier to use..

___________________

Graphic and Web Design services at flowtone.com

Thanks, this is just what I was looking for

And just aamoc, why arn't MySQL databases accessable to the user anyway?

....and they say PHP is easier to use! *goes off to code some more .Net (in Satan's presence) accompanied by an evil laugh* muwahahaha ::angry::

___________________

http://www.aesthetic-theory.com/showtut.php?page=tutorials&t=server1

That will help you install PHPMyAdmin in case you come into some problems.

___________________

"Hey, **** YOU!"

If you know how, I would recommend password-protecting your PHPMyAdmin if not already.

They are accessable to the user... There are lots of actual programs that you can run to access them, or you can use the cmd line to do things to it as well.

___________________

Neverside Development Director
PHP Snippets
BigToach.com - IT WORKS, TOACHY!

MySQL databases are accessible. To my knowledge you can edit MySQL databases somewhat in the Windows version of MySQL. As Scott said, there are client-side programs that you can run, but phpMyAdmin works on anything and is very powerful.

I was referring to the fact that many webhosts running Apache/Linux don't actually allow customers to access the MySQL database via FTP, whereas IIS/Windows hosts do (to M$-SQL and MDB)

___________________

Quote:

Originally posted by W3bdevil
I was referring to the fact that many webhosts running Apache/Linux don't actually allow customers to access the MySQL database via FTP, whereas IIS/Windows hosts do (to M$-SQL and MDB)

That's because you can't read a MySQL file by itself.

Microsoft databases can be used anywhere (any folder, you just have to point there).

MySQL databases have to be stored in a certain folder in the MySQL directory (usually data) and the database name (depending on the server) may be something like username-databaseName with the .frm .MYD and .MYI files. There would still have to be a program to interpret those files, because you can't edit them with a normal text editor. So being allowed to edit them remotely is better than going through the trouble of downloading them, editing them with a $200+ program, and uploading the updated database.