chown: `mysql:mysql': invalid user

[goude]

Hello everyone

I am trying to start mysqld service and I get the error

chown: `mysql:mysql': invalid user
chown: `mysql:mysql': invalid user
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

So I tried to create a user account and group under the name mysql but the system tells me
that the account already exists.

I can confirm that there is no account under the name mysql in etc/passwd but there is one in the NIS database.

[root@max /]# ypcat group | grep mysql
mysql:*:453:

The service mysqld requires a mysql account to start but there isn't one in my local computer and when I attempt to create one it tells me that it is already there.
Does anyone have any suggestions please?

Many thanks

[Irithori]

Does your /etc/nsswitch include nis for passwd/group?

But even if it does, I am not so sure if it is a good idea to make a database dependent on the availability of nis, even at the cost of different uids/gids for mysql user/group throughout the network.

[goude]

Hi Irithori

Yes it does. Here it is:

passwd:     files nis
shadow:     files nis
group:      files nis

#hosts:     db files nisplus nis dns
hosts:      files nis dns

bootparams: nisplus [NOTFOUND=return] files

ethers:     files
netmasks:   files
networks:   files
protocols:  files
rpc:        files
services:   files

netgroup:   files nis

publickey:  nisplus

automount:  files nis
aliases:    files nisplus

It might sound silly but is there a way to tell mysql to stop looking at NIS for user/group information?

[coopstah13]

just create a different user to run mysql as is another option

[goude]

OK!

I stopped ypbind and then added the user mysql locally. Now when I try to start the mysqld service I no longer get the chown error but the service
fails to start.

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

Here is mysqld.log

110217 15:29:47  InnoDB: Started; log sequence number 0 43655
110217 15:29:47 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
110217 15:29:47 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
110217 15:29:47 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
110217 15:29:47  mysqld ended

SQL is sooo fun.

[goude]

It's working now thanks to:

http://www.linuxforums.org/forum/ser...ql-server.html

Thanks everyone.