Installing mySQL under Linux

mySQL is a robust Relational Database Management System. Currently it runs under Linux, Windows, OS2, and several other operating systems. Aside from the fact that it is free (yes, you heard right), mySQL has become the database management system of choice for many small and large solutions (Yahoo has been known to use mySQL).
This tutorial teaches how to install mySQL under Linux.

Installing mySQL under Linux

For those of you not yet familiar with mySQL, it is a robust Relational Database Management System. Currently it runs under Linux, Windows, OS2, and several other operating systems. Aside from the fact that it is free (yes, you heard right), mySQL has become the database management system of choice for many small and large solutions (Yahoo has been known to use mySQL).

Oh, one more thing. If the Linux box you have access to is not your own, do not attempt to follow this tutorial. You will need to have root access to the machine in order to install mySQL. Be forewarned trying to install mySQL on a machine that you do not have permission to do so on MAY get you in to some trouble with some administrators. I doubt you want to do that.

Otherwise, have fun. If you want just the down and dirty install commands, without all of my witty comments and explanations, scroll to the bottom.

Steps:

  1. Ingredients
  2. Unpacking
  3. Adding a User for mySQL
  4. Configuring mySQL for your machine
  5. Compiling mySQL
  6. Installing Default Databases (Grant Tables)
  7. mySQL Owns Itself
  8. Starting up mySQL
  9. Adding mySQL to the System Startup
  10. Lazy People Look Here

(you can also see this entire tutorial on one page)

So let's start with the beginning. Ingedients >>>

Comments

How about Winn2000 users?

December 19, 2001 by Helle M

I really don't know much about MySQL, but would like to also read about how you do this using Win2000 ?

Helle:-)

RE: How about Winn2000 users?

March 18, 2002 by Plamen Jelezov

Well, actually you will have no problems with the MySQL itself, but there are few bugs in the W2K OS. It took me about 2 weeks to make it work. Now it's perfect. Works very well with the OS and the PWS. I hate heavy things and that'a why removed the IIS. If you decide to start working with it, just mail me back and I'll send you full dscription, how to do it!

pj - pj@buldata.com

RE: RE: How about Winn2000 users?

March 20, 2002 by Stefan Gomez

I am extremely new to php and mysql. I am used to plain old access databases. My web host only accepts mysql databases. After going through the endless pages of setting up mysql, I have yet to find information on how to create mysql databases. If I got pass this, I'm sure I'd be using php with a mysql database in no time. I've managed to create a database on my host, and I've downloaded something to edit it. But I'm still lost on how to create the database. And, it'd be much easier for me to just convert my access databases to mysql. How would I do this, and how would I transfer it to the server? the only thing I can see so far is that I would have to re enter everything into the mysql server? Can't it just be as easy as uploading my database, I wish it could be. If anyone would be willing to help, I'd be very grateful,

Thanks,

Stefan

RE: How about Winn2000 users?

April 17, 2002 by Cheryl Floyed

I only read this last night but it may help... I read that you can export to MySQL from Access. I also read that you can use a free utility called DataTools... Again, don't hold me to this because I've only read it but it is a starting place.

See all 7 Comments

You must me logged in to write a comment.