Where do I find MySQL on my remote server?

[bordxjr]

Hello,

I am a very new to PHP and MySQL. I have PHP install with Win98/PWS on my computer. My web server is FreeBSD/Apache/PHP. How do I find MySQL on the server or do I build my MySQL database on my computer then upload it to the server. Does MySQL build in actual database like say MS Access? From then can you upload it to the server and make your connections.

Thanks

bordxjr

[greg252]

I also dev on win98 (OSX, linux and BSD).
If you have mySQL installed on win, your best bet is to use phpmyadmin (avail at sourceforge-free)

Build your databases, create sql files on your remote sys(through phpmyadmin) and upload (through phpmyadmin) to server.

That's the quickest way.

You can FTP in to the server at root level, and move files from /mysql/data to var/bin I think. Please check that out before hand.

[Kerry_Kobashi]

If you are just learning PHP and mySQL, you can put mySQL on the same machine being used as your web server. You would need to download the appropriate distributables for your O/S.

All calls to the mySQL_XXXX functions in PHP would then rely on localhost as the $host name (see mySQL_connect), else you would have to key in a DNS/IP address to get at it. I would keep it simple if your main focus is to learn mySQL/PHP quickly and forego all the administration issues.

If your question is where is mySQL, the answer is that you need to download it at www.mysql.com - it is not part of the PHP distributables.

Hope this helps!

Kerry Kobashi
Kobashi Computing