Ok, thanks for helping me out. This is my problem...
I'm trying to set mysql up on rh9, a binary install, not from rpm.
I've done everything the manual said. (created the sl, set permissions, made the users and the group.)
I've also had this problem before:
MySQL could not start. I've solved it by modifying the permissions and setting the group right in the
/var/lib/mysql
Now i'm getting this when i try to run mysqld with this command
./bin/mysqld (as mysql user),
because it won't let me do it as root and the
./bin/safe_mysql --user=mysql [&]
does not yeld any useful debugging info.
the output i get is this:
Code:
[root@kvazar mysql]# su mysql
bash-2.05b$ ./bin/mysqld
040420 22:04:28 InnoDB: Started
040420 22:04:28 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040420 22:04:28 Aborting
040420 22:04:28 InnoDB: Starting shutdown...
040420 22:04:30 InnoDB: Shutdown completed
040420 22:04:30 ./bin/mysqld: Shutdown Complete
bash-2.05b$
MySQL won't start "Can't open privilege tables"
