MySQL "root" password

The file ~mysql/.my.cnf contains the MySQL root password:

[client]
user=root
password=XXXXX

The file should have the following permissions

gigascale:root: %C2> ls -l ~mysql/.my.cnf
-rw-------   1 mysql          37 Apr  9  2001 /home/mysql/.my.cnf

To change the password

root:> /usr/local/mysql-3.23.58/bin/mysqladmin -u root -h gigascale.EECS.Berkeley.EDU -p password "NewPassword"
Enter password: OldPassword

root:> /usr/local/mysql-3.23.58/bin/mysqladmin -u root -p password "NewPassword"
Enter password: OldPassword

MySQL "apache" password

The file /home/apache/conf.php contains the MySQL passwords used by the MySQL php interface at http://http://chess.eecs.berkeley.edu/mysql/

This file should have the following permissions

-r--------   1 apache        611 Oct 25 18:57 /home/apache/conf.php

conf.php3 is read in php/include/sql.inc.php3.

Below is an example of how to use the password:

markov:root: > /usr/local/mysql/bin/mysqladmin -h localhost -u apache -p version
Enter password: xxxxx

/usr/local/mysql/bin/mysqladmin  Ver 7.11 Distrib 3.22.22, for sun-solaris2.7 on sparc
TCX Datakonsult AB, by Monty

Server version          3.22.22
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 23 min 29 sec

Threads: 1  Questions: 107  Slow queries: 0  Opens: 11  Flush tables: 1  Open tables: 7
markov:root: >