// Internet Duct Tape

Installing/Using MySQL on RedHat Linux – very high level tutorial

Posted in Links, Linux and Unix, Technology by engtech on April 20, 2006

Installing/Using MySQL on RedHat Linux

This is a very high level tutorial about how to install MySQL on RedHat Linux. Author assumes that user is completely unfamiliar with databases/SQL.

In a nutshell:

  • download the RPMs from http://www.mysql.com
  • install using 'rpm –install'
  • set root password for mysql

What is of interest is the section on how to secure the MySQL server:

  • When you create an account, give it a password.
  • Create a separate account for each function for each database and restrict rights appropriately.
  • Only allow database access from "localhost."
  • Do not enter the password on the command line (-p[password]) if you are on a multi-user system because other people could see it if they use the `w` or similar commands.
  • Remove any unused or seldom used databases (like the "test" database which is installed by default).
1 comment

One Response

Subscribe to comments with RSS.

  1. jeff said, on September 19, 2006 at 4:59 pm

    hello there,
    i am trying to reproduce a data server that a company uses to present information to its customers via the web. No problem. What they are using right now is Microsoft Access, connecting via ODBC to a server on line. The cool thing that they can do is have several tables linked together. Like if a certain field is updated in one table, it updates the same info automatically in another table. So, i want to reproduce this in MySQL, but i can’t seem to find out how. Is there a way to pull this off on the server side ? or does that have to be done on the client side ?
    thanks for any tips.


Comments are closed.