post install mysql problems

[dale10]

I'm brand new to mysql and I'm having post installation problems. I ran mysql_install_db.
It said to run mysqladmin to set the password for the root user, but when I ran that it
couldn't connect to the server. So I try starting safe_mysqld & and it didn't work.

This is what's in the mysqld.log file:
011004 11:38:16 mysqld started
011004 11:38:16 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
011004 11:38:16 mysqld ended


However I do have that file in /var/lib/mysql/mysql/host.frm. I tried running it from
/var/lib/mysql in hopes that hosts.frm would be found but no luck. I get the same error.
Any ideas?

[dale10]

bump, anybody?

[dvdnut]

im sure you need to ask it to connect to localhost in order for you to administer it

not sure of the syntax for this but this is what you need to do

[bdg1983]

From what I gather from the Google search results (http://www.google.com/linux?site=search&restrict=linux&hl=en&q=Can%27t+find+file%3A+%27.%2Fmysql%2Fhost.frm&btnG=Google+Search), you need to run 'install MySQL'. Another mentioned 'manual.txt'. Is that file included with mysql and if so, have you searched through it?

[FroggySwamp]

Also, make sure that your permissions are correct. I can remember a very frustrating experience where I kept getting "Mysql Started.....Mysql ended" until I did the proper chown of files and directories. :D

[dale10]

I was able to figure out the problem thanks to everyone's help. Here's what it was incase anyone ever looks this topic up. It
was an annoying permission problem.
Make sure you have a mysql user and mysql group.
If you don't they can be added with:

useradd mysql
groupadd mysql

while logged in as root.

For Redhat 7.1 (not sure if it mysql's data directoy is the same in other distros) type in these commands:

cd /var/lib/mysql/mysql
chown -R mysql:mysql .
chmod -R go-rwx .

Then you should finally be able to start up the MySQL server.