ｔｂｓせんせい

1．mysqlの初期設定

(1)ルートパスワードの設定

[root@eds html]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.25-Max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for root=password('xxxxxxxxl');
Query OK, 0 rows affected (0.10 sec)

mysql> quit
Bye

(2)パスワード設定のないユーザを削除

[root@eds html]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.25-Max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> delete from user where password="";
Query OK, 3 rows affected (0.02 sec)

2.PhpMyAdminのインストール

(1)ダウンロードしたファイルを展開し，ディレクトリ名を変更

[root@eds html]# tar -xzvf phpMyAdmin-2.8.2.tar.gz
[root@eds html]# mv phpMyAdmin-2.8.2 phpmyadmin

(2).htpasswdoの設定(ユーザ名:sqladmin)

[root@eds html]# htpasswd -c /home/httpd/.htpasswd sqladmin
New password:
Re-type new password:
Adding password for user sqladmin

(3)httpd.confの編集(None -> All)

# This controls which options the .htaccess files in directories can
# override. Can also be "All", or any combination of "Options", "FileInfo",
# "AuthConfig", and "Limit"
#
AllowOverride All

(4).htaccessの設定

[root@eds phpmyadmin]# cat /home/httpd/html/phpmyadmin/.htaccess
AuthUserFile /etc/httpd/conf/.htpasswd
AuthGroupFile /dev/null
AuthName "Please enter username and passwd"
AuthType Basic
Require valid-user

(5)httpdの再起動
[root@eds conf]# /etc/rc.d/init.d/httpd restart
httpdを停止中: [ OK ]
httpdを起動中: [ OK ]

(6)/home/httpd/html/mysqladmin/libraries/config.default.phpの設定

[root@eds libraries]# diff config.default.php config.default.php.org |grep '^<'
< $cfg['PmaAbsoluteUri'] = 'http://cess.info.yuge.ac.jp/phpmyadmin';
< $cfg['Servers'][$i]['host'] = 'cess'; // MySQL hostname or IP address
< $cfg['Servers'][$i]['password'] = 'xxxxxxxx'; // MySQL password (only needed
< $cfg['Export']['charset'] = 'ja-euc';

ブラウザから起動すると次のエラーが表示
#1130 - Host 'cess.info.yuge.ac.jp' is not allowed to connect to this
MySQL server

ルートユーザでmysqlへログインし，自由にサーバへつなぐことができて何で
もできるユーザを作成

mysql> GRANT ALL PRIVILEGES ON *.* TO sadmin@localhost IDENTIFIED BY 'yuge-sql' WITH GRANT OPTION;
Query OK, 0 rows affected (0.33 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO sadmin@"%" IDENTIFIED BY 'yuge-sql' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.17 sec)

(7)再度/home/httpd/html/mysqladmin/libraries/config.default.phpの設定

[root@eds libraries]# diff config.default.php config.default.php.org |grep '^<'
< $cfg['PmaAbsoluteUri'] = 'http://cess.info.yuge.ac.jp/phpmyadmin';
< $cfg['Servers'][$i]['host'] = 'cess'; // MySQL hostname or IP address
< $cfg['Servers'][$i]['user'] = 'sadmin'; // MySQL user
< $cfg['Servers'][$i]['password'] = 'xxxxxxx'; // MySQL password (only needed
< $cfg['Export']['charset'] = 'ja-euc';