AppletTalk.com Forum Index AppletTalk.com
Java discussions newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

[SOLARIS - MySQL 3.23.58] Fatal error: Can't change to run a

 
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases
View previous topic :: View next topic  
Author Message
Chithu
Guest





PostPosted: Wed Jan 21, 2004 5:35 pm    Post subject: [SOLARIS - MySQL 3.23.58] Fatal error: Can't change to run a Reply with quote



We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8
platform and exception is thrown 'Fatal error: Can't change to run as
user 'mysql' ; Please check that the user exists!'.

I have 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't 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've 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 ..!
Back to top
David Harper
Guest





PostPosted: Sun Jan 25, 2004 12:01 pm    Post subject: Re: [SOLARIS - MySQL 3.23.58] Fatal error: Can't change to r Reply with quote



Chithu wrote:
Quote:
We are facing problem in starting mysql [MySQL 3.23.58] in Solaris 8
platform and exception is thrown 'Fatal error: Can't change to run as
user 'mysql' ; Please check that the user exists!'.

I have 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't 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've 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 isn't 'root',
so the user doesn't 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 doesn't have a user called 'mysql', so the process
is trying, and failing, change its UID to a user that
doesn't 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 doesn't have a home directory, or for some
reason that user doesn't have write-access to its home directory.

4. The 'mysql' user doesn't 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


Back to top
Display posts from previous:   
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.