MySQL problem 1

[sucram]

Hi,
I am trying to set up MySQL, it was working but now it won't start up. The log is giving the following error.

011118 12:23:28 mysqld started
011118 12:23:28 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/level402.pid' (Errcode: 13)
011118 12:23:28 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
011118 12:23:28 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/level402.pid' (Errcode: 13)
011118 12:23:28 mysqld ended

It creates a file /tmp/mysql.sock but the file is empty, I not really sure what should happen but it just will not work anymore.

Is there anyway I can clear a port. When I telnet to the port it disconnects immediately.

Any help would be greatly appreciated,
Marcus

 

[TheRAt]

check permissions for the user you are using to run the mysql with, and that it has the correct permissions for /usr/local/mysql/data/ AV
tnedor@yahoo.com

Did this post help? Click below to let me know.

 

[sucram]

Thanks for that,
I changed the permissions on the data directory and that error has disappeared. The last error is

011119 09:19:58 mysqld started
011119 9:19:58 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
011119 09:19:58 mysqld ended

The manual says to run mysql_install_db as root. But this does not change anything. Is it possible to automatically/manually create this file, or is reinstalling the best option at this point.

Thanks,
Marcus

 

[sucram]

You were right all the problems were permissions.
Thank you. It is amazing how often I get caught out by permissions.

Marcus

 

[TheRAt]

check out the information at

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Post-installation

There is some information there about the host.frm file and how to get the mysql installtion going, depending on the method of installation... AV
tnedor@yahoo.com

Did this post help? Click below to let me know.