// 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).

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.

Follow

Get every new post delivered to your Inbox.

Join 285 other followers

%d bloggers like this: