EMFT Build Server Setup (Archived)

This page contains old instructions that are no longer accurate.

Install & configure mysql server 4.1

Install via yum

 yum update
 yum install mysql

This installed 4.1.20-1.FC4.1.

Set mysql root user password

Per instructions posted here http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html:

• Stop running daemon

 /etc/init.d/mysqld stop

• Start mysqld server

 /usr/bin/mysqld_safe --skip-grant-tables --user=root &

 mysql -u root

• In mysql, run the following commands:

 UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
 FLUSH PRIVILEGES;
 QUIT;

• Stop server

 kill `cat /var/run/mysqld/host_name.pid`;

• Wait until process is actually killed

 ps ax | grep mysqld

• Start mysqld daemon

 /etc/init.d/mysqld start

• To verify password set correctly:

 mysql -u root -p

• Enter new assigned root password when prompted

Add a user

• Start up mysql if not already connected.

 mysql -u root -p

• In mysql, run the following commands:

 GRANT ALL PRIVILEGES ON *.* TO newuser@"%" IDENTIFIED BY 'newuser' WITH GRANT OPTION;
 GRANT ALL PRIVILEGES ON *.* TO newuser@"localhost" IDENTIFIED BY 'newuser' WITH GRANT OPTION;
 QUIT;