CentOSにMysqlをインストールのメモ

Aug 19, 2008

AD:

CentOSにMysqlをインストール
yumでMysqlをインストール

[root@localhost ~]# yum -y install mysql-server

1	[root@localhost ~]# yum -y install mysql-server

MySQL設定ファイル編集

[root@localhost ~]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#aracter-set = utf8<span>&larr;&#12467;&#12513;&#12531;&#12488;&#12450;&#12454;&#12488;</span>+
default-character-set=utf8<span>&larr;&#36861;&#21152;</span>

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


default-character-set=utf8<span>&larr;&#36861;&#21152;</span>

[root@localhost ~]# vi /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

#aracter-set = utf8←コメントアウト+

default-character-set=utf8←追加

[mysql.server]

user=mysql

basedir=/var/lib

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

default-character-set=utf8←追加

Mysqlを立ち上げてみる

[root@localhost ~]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
MySQL &#12434;&#36215;&#21205;&#20013;:                             [&#22833;&#25943;]

[root@localhost ~]# /etc/rc.d/init.d/mysqld start

Timeout error occurred trying to start MySQL Daemon.

MySQL を起動中: [失敗]

失敗したので原因をさぐるためログを確認

[root@localhost ~]# vi /var/log/mysqld.log
InnoDB: Apply batch completed
080819 18:05:21  InnoDB: Started; log sequence number 0 43655
080819 18:05:21 <span>[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist</span>
080819 18:05:21  mysqld ended

[root@localhost ~]# vi /var/log/mysqld.log

InnoDB: Apply batch completed

080819 18:05:21 InnoDB: Started; log sequence number 0 43655

080819 18:05:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

080819 18:05:21 mysqld ended

MySQL データを初期化し、システムテーブルを作成さしてみる

[root@localhost ~]# mysql_install_db

1	[root@localhost ~]# mysql_install_db

もう一度起動してみる

[root@localhost ~]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
MySQL &#12434;&#36215;&#21205;&#20013;:                             [&#22833;&#25943;]

[root@localhost ~]# /etc/rc.d/init.d/mysqld start

Timeout error occurred trying to start MySQL Daemon.

MySQL を起動中: [失敗]

またまた失敗したのでログを確認
エラーが変わる。

[root@localhost ~]# vi /var/log/mysqld.log
080819 18:25:48 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080819 18:25:48 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080819 18:25:48 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

[root@localhost ~]# vi /var/log/mysqld.log

080819 18:25:48 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

080819 18:25:48 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

調べると”/var/lib/mysql”のアクセス権が正しくないらしい
ぼくはすべてがrootユーザの権限になっていた。
mysqlに権限を与える

[root@localhost ~]# chown -R mysql:mysql /var/lib/mysql

1	[root@localhost ~]# chown -R mysql:mysql /var/lib/mysql

見事に機動・・・時間かかった。

[root@localhost ~]# /etc/rc.d/init.d/mysqld start
MySQL &#12434;&#36215;&#21205;&#20013;:                             [  OK  ]

1 2	[root@localhost ~]# /etc/rc.d/init.d/mysqld start MySQL を起動中: [ OK ]

AD:

Cloud Nine

One Comment, Comment or Ping

oba1

大変参考になりました。(_。_;)

Oct 12th, 2011

Reply to “CentOSにMysqlをインストールのメモ”

Warning: Undefined variable $user_ID in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/themes/grid_focus_public_mizo/comments.php on line 66

You must be logged in to post a comment.