So I decided I want to move on and I needed mySQL server, which is in the add/remove on RH9. I chose it and clicked on update. Now it's aswking for the CD but I no longer have a cd rom drive. I do have accessible cd rom drive over the network on windows based system, what's the fastest way to get this done?

I would suggest remote mount via Samba or NFS (so I hear. I'm a happy Samaba user and dno't care to explorer into NFS just yet).
But to do these, you either need access to the cd-rom (which you don't have) or to the internet where you can download the RPM package. But if you had internet access I guess you wouldn't have had this problem of having to use the installation CD...I guess you should bring the CD back into your PC...

i do have access to the net from that pc but isn't it the easiest way of installing mySQL, from the cd? Is it not autoconfigured n stuff? I tried, i believe it was binary but couldn't find any leads. Do you know where I can get RPM and instrustions on how to install it?

mysql.com : )

PS. you can get the "binary" download from that website which is already compiled for you (I guess sort of "autoconfigured n stuff" in a way).

been there, got confused and got something that i was not supposed to, perhaps if you could please point me to the file that i need?

Much appreciated.

i did install the binary, there was a config file that I ran. So i'm assuming it installed it. But what's next, how do I create a new database.

since 4.0 is "recommened" that is what I will tel you to get. The link is
http://www.mysql.com/downloads/mysql-4.0.html
GO to the "linux" section at the top of the page, pick your architecture (if you are running Intel or AMD, then "x86"), and download "Standard". Once you download it, run "md5sum <the downloaded file name>", wait for couple of seconds to couple of minutes depending on how fast your PC is, then comapre the output to the md5sum string posted under neath the download link on the URL I pastd above.

That becomes more of a "SQL tutorial" question which kind of goes beyond this web site's scope (thi been "linux" forum and not "mysql" forum). Anyhow, if you don't know the SQL query command, you should start there first. if you do know the SQl query command, then try the "Tutorial" @ MySQl.com or do a google search.
but just to give you a little head start...
a. make sure that mysql is running ("safe_mysqld" script in the "bin" dir)
b. run "mysql" to log onto MySQL
c. if you haven't set the "root" password yet, then hit <enter> when prompted for password
d. "show databases" will show you the default databases installed by MySQL.

Now, please switch over to mySQL forum before I get yelledat by someone for making the "linux forum" into a "MySQl forum".

I'm really confused, but it's not you, it's myself I'll leave this as i'm sleepy and I don't understand many things when i'm sleepy


Thanks for the help, I'll resume this tomorrow.