Tutorials Of Setting Up MySQL DBs On Your System ?

[silentkarma1405241502 0]

I was wondering if anyone had tutorials on how to setup MySQL databases on your own computer? This would be useful in creating your own hosting service if you had dedication to it. So does anyone have any sort of guide or tut that could be useful on seting everything up? I know that newer versions of MySQL are being released, so post the most up to date tutorials you can find. Thanks!

Edited August 8, 2005 by microscopic^earthling (see edit history)

[WeaponX 0]

Maybe you should try requesting this in the Tutorials section? It would get better exposure over in that forum.

I assume you want to do the hosting? If you just want to set one up for your own testing purposes (not for outside use), you should be ok installing the MySQL package. Or use a program like XAMPP which has Apache, PHP and MySQL.

[Houdini 0]

I would get XAMPP which is an apache webserver, with PHP, MySQL, FileZilla FTP server, Mercury mail server, mini Perl, Coccon, Tomcat, Python and more, and it installs on Windows with an install program sets everything up in minutes then to learn about MySQL just go straight to the source at MySQL Manual or the main site at MySQL home. But if you want to actually be a dedicated database server you will need more than a local machine with just a MySQL database, you'll need a server farm and a T1 connection and loads of money to get started, and a tech staff or at least some one who can arrive within no more than 1/2 hour of a hardware failure to get the system back on line or you will lose customer quickly, especially if they are losing money every minute that they are unable to use the database, you might want to do a lot of study and get with those that already do that sort of thing before you try to just start up a service that has other peoples data on it.

[rodneylay 0]

Use the link below to go to MySQL.com and you will find everything you need to know about everything MySQL. You can download tutorials in all kinds of formats, including PDF which is nice for printing, as well as the MySQL database to install on your local computer. There are versions for nearly every popular operating sytem and computer. If you need more, just go to Google and type in MySQL in the search text box and you will retrieve a sea of good info to choose from. Good luck. Also, installing MySQL is not hard to do, but expect to take some time to get everything configured right. Do not rush the job. You will be much happier by taking your time and not have to try and fix things after the fact. Here is the link ...............

http://www.mysql.com/

Enjoy!

Rodney Lay

[abhiram 0]

XAMPP sounds good. I'll give it a try sometime. If you're only planning on using PHP and MySQL, I would suggest trying out WAMP. It sets up Apache, MySQL and PHP in windows. Just like XAMPP, it's just click and install and you're ready to go. I've been using it for quite some time now. You can get it from:

 

http://www.wampserver.com/

 

The hard way to do it would be install and configure each component seperately. You could download Apache, MySQL and PHP each individually and then install and configure them on your computer. I did that once and as a novice, it took me 2 days to get it running with no problems. I used IIS instead of Apache. This can be installed from the Windows CD as an optional package. It's definitely easier to use WAMP than this. WAMP can be installed in a matter of minutes....everything configured and ready to go!

 

Hope this helps out.

[ajmal 0]

WAMP and XAMPP sound cool, but I prefer Uni-Server:

http://www.uniformserver.com/

It's much smaller (3 MB) and supports CGI/PHP/MySQL as well