Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / January 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Chithu - 21 Jan 2004 17:35 GMT
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 ..!
David Harper - 25 Jan 2004 12:01 GMT
> 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
[quoted text clipped - 18 lines]
>
> 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


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.