Go to Home Page GuidesHow to ArticlesReviewsForumsFrequently Asked QuestionsNewsLinksPotpourri

Site Search

 

Red Hat Linux 9.0 Clean Install - The Whole Enchilada
Last updated: 5/21/03

MYSQL

(version 3.23.54a)

Set the password for the MySQL root user.

/usr/bin/mysqladmin -u root password 'new-password’
(You won’t be able to create databases with phpMyAdmin, etc. if you don’t do this.)

Opened a terminal window and entered the following at the prompt.

mysql -uroot -p

Entered the above password when prompted.

Went to /etc, duplicated the MySQL configuration file my.cnf file.

Added the following line the [mysqld] section:

skip-innodb

If this isn't done and you are not using innodb, mysql will repeatedly add entries to its log suggesting that it be done. If you can't edit the file, the MySQL server may already be running.  Stop it in the Service Configuration.

Started the MYSQL server in the Service Configuration.

Opened a terminal window and entered the following at the prompt.

mysql -uroot -p

Entered the above password when prompted.

MySQL is up.

MySQL Notes:

If you want to play with/optimize the MySQL variable, etc. settings, example my.cnf files (my-small-cnf, my-medium-cnf, my-large-cnf, and my-huge-cnf) are located in /usr/share/doc/mysql-server-3.23.54a.

To import the database dumped into a text file as a collection of SQL queries (MySQL Dump command, etc.) into an empty mysql database, do the following in the Terminal :

mysql -uUsername -p dbname < dbname.sql

Or use a MySQL utility program to do it, such as those described in  Open Source/Free Graphical Management Utilities for the MySQL Database Server.

< Previous | Contents | Top | Next - PHP >

Copyright, Disclaimer, and Trademark Information Copyright © 1996-2006 Larry F. Byard.  All rights reserved. This material or parts thereof may not be copied, published, put on the Internet, rewritten, or redistributed without explicit, written permission from the author.