EMFT Build Server Setup (Archived)

From Eclipsepedia

Revision as of 18:13, 25 August 2006 by Codeslave.ca.ibm.com (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This page contains old instructions that are no longer accurate.

Contents

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;