装MYSQL后启动错误! mysqld ended --在线急等!在线急等!在线急等!在线急等!-----
装MYSQL时(mysql-standard-5.0.22-linux-i686-glibc23)
groupadd mysql
useradd -g mysql mysql
cd /usr/local
解压到/usr/local目录下
ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
cd mysql
scripts/mysql_install_db --user=mysql
--------------------------
接着(在/usr/local/mysql下)
chown -R root .
chown -R mysql data
chgrp -R mysql .
bin/mysqld_safe --user=mysql &
启动错误!
错误提示!
-----------------------------在线急等!在线急等!在线急等!在线急等!----------------------------
071212 10:37:37 mysqld started
071212 10:37:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
071212 10:37:37 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
071212 10:37:37 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
071212 10:37:40 InnoDB: Started; log sequence number 0 43655
071212 10:37:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
071212 10:37:40 mysqld ended
--------------------------------在线急等!在线急等!在线急等!在线急等!----------------------------------
然后我有执行chmod -R 1777
还是出现一样的错误!
各位大侠:这个该如何解决,给详细步骤好吗?小小菜鸟先谢过大家!
在线急等!在线急等!在线急等!在线急等!
------解决方案--------------------一般是权限的问题,要确保mysql的数据库目录mysql用户有绝对权限,安装完成后要用chown mysql:mysql $MYSQLPATH/var/