Sagewire Logo

[SOLARIS - MySQL 3.23.58] Fatal error: can not change to run as user 'mysql' ;

2 Message(s) by 2 Author(s) originally posted in mysql java


From: chitrapandian Date:   Wednesday, January 21, 2004
We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8
platform and exception is thrown 'Fatal error: can not change to run as
user 'mysql' ; Please check that the user exists!'.

I've tried using using either root or specific user.

If I check MySQL logs by viewing
/opt/mysql/data/<hostname>.err040119 09:34:32 mysqld started
Fatal error: can not change to run as user 'mysql' ; Please check that
the
user exists!
040119 9:34:32 Aborting
040119 9:34:32 /opt/mysql/bin/mysqld: Shutdown Complete
040119 09:34:32 mysqld endedI have tried several times to install it, but still get the same error.
Any
clue on that problem ?Any help to solve this problem is really appreciated.

Regards,
Chithuu ..!


From: David Harper Date:   Sunday, January 25, 2004
wrote in message:
We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8
platform and exception is thrown 'Fatal error: can not change to run as
user 'mysql' ; Please check that the user exists!'.
I've tried using using either root or specific user.
If I check MySQL logs by viewing
/opt/mysql/data/<hostname>.err
040119 09:34:32 mysqld started
Fatal error: can not change to run as user 'mysql' ; Please check that
the
user exists!
040119 9:34:32 Aborting
040119 9:34:32 /opt/mysql/bin/mysqld: Shutdown Complete
040119 09:34:32 mysqld ended
I have tried several times to install it, but still get the same error.
Any
clue on that problem ?
Any help to solve this problem is really appreciated.



It looks like your MySQL server process is hitting a problem when
it tries to change its user id to that of the user 'mysql'.

There are two possible reasons for this:

1. You're starting the server process as a user who is not 'root',
so the user does not have the necessary privilege to change
the UID of the server process.

-- OR --

2. You *are* starting the server process as 'root', but your
system does not have a user called 'mysql', so the process
is trying, and failing, change its UID to a user that
does not exist.

Try "finger mysql" to see whether you actually have a user named
'mysql'.

Thinking about it, there are other possibilities, assuming that
you *do* have a user named 'mysql'.

3. The 'mysql' user does not have a home directory, or for some
reason that user does not have write-access to its home directory.

4. The 'mysql' user does not have the necessary access privileges
to /opt/mysql and all of its sub-directories.

However, my money is on reason 2.

David Harper
Cambridge, England



Next Message: case sensitive comparison ?



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional