Page History

...

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');

You may want to set this for other domain names and addresses as well.

SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');

The root account is like the Unix "superuser" with complete privileges on all databases, so take care as to how this account is configured for security.  In general, you should prefer to use other accounts for your local work, but root can be used for operations such as creating new databases.

...

From the root account, you should create the (initially empty) database for the conditions system from the console after the initial installation.

mysql> create database hps_conditions;

Now an account needs to be granted privileges for this databaseYou should also create a read-only account that will be used to run jobs.

GRANT ALL ON hps_conditions.* TO 'hpsadminCREATE USER 'hpsuser'@'localhost' IDENTIFIED BY ';

This hpsadmin account will be used to load the data from the JLAB database into your local installation.

You should also create a read-only account.

mypassword';
GRANT SELECT ON hps_conditions.* TO 'hpsuser'@'localhost';

The restricted hpsuser account will be used to run local reconstruction or analysis jobs, but it will not have any privileges to change the database.

Creating a Database Dump

...

mysql -D hps_conditions -h localhost -P 3306 -u hpsadminroot -pXXXXXXXX < jlab_conditions_db.backup.sql

...