Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
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.
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;