XOOPS を使用する環境を整える

# rpm -qa | grep httpd
redhat-config-httpd-1.1.0-5
httpd-manual-2.0.47-10
httpd-2.0.47-10
# rpm -qa | grep php
php-4.3.3-6
php-ldap-4.3.3-6
php-imap-4.3.3-6
# rpm -qa | grep mysql
mysql-3.23.58-4
mysql-server-3.23.58-4

AddDefaultCharset UTF-8

AddDefaultCharset Off

# service httpd graceful

# chkconfig --level 3 httpd on

# service mysqld start
MySQLデータベースを初期化中:                               [  OK  ]
MySQLを起動中:                                             [  OK  ]
# ls /var/lib/mysql/
mysql  mysql.sock  test

# diff /etc/init.d/mysqld.org /etc/init.d/mysqld
42c42
<     if [ -n "`/usr/bin/mysqladmin ping 2> /dev/null`" ]; then
---
>     if [ -n "`/usr/bin/mysqladmin -u mysqld ping 2> /dev/null`" ]; then
48c48
<     if !([ -n "`/usr/bin/mysqladmin ping 2> /dev/null`" ]); then
---
>     if !([ -n "`/usr/bin/mysqladmin -u mysqld ping 2> /dev/null`" ]); then

# chkconfig --level 3 mysqld on

# mysqladmin -u root password 'hogehoge'
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.58

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

mysql>CREATE DATABASE xoops;
Query OK, 1 row affected (0.01 sec)

mysql>grant CREATE,DROP,UPDATE,INSERT,SELECT,DELETE on xoops.*
 to xoops@localhost IDENTIFIED BY 'fugafuga';
Query OK, 0 rows affected (0.04 sec)

mysql>commit;
Query OK, 0 rows affected (0.02 sec)

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 user='';
Query OK, 2 rows affected (0.02 sec)

mysql>exit