Jump to: navigation, search

Difference between revisions of "EMFT Build Server Setup (Archived)"

 
m (add emft category)
 
Line 59: Line 59:
 
   GRANT ALL PRIVILEGES ON *.* TO '''''newuser'''''@"localhost" IDENTIFIED BY ''''''newuser'''''' WITH GRANT OPTION;
 
   GRANT ALL PRIVILEGES ON *.* TO '''''newuser'''''@"localhost" IDENTIFIED BY ''''''newuser'''''' WITH GRANT OPTION;
 
   QUIT;
 
   QUIT;
 +
 +
 +
 +
[[Category:Modeling]] [[Category:EMFT]] [[Category:Releng]]

Latest revision as of 14:36, 23 February 2007

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;