starting mysql as root user on linux

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paul
    Junior Member
    • May 2004
    • 11

    starting mysql as root user on linux

    I have installed mysql 4.02 on redhat linux.
    I have created a user called mysql to administer the mysql installation.

    I can run mysqld_safe as the mysql user without any problems, however, when I try to run it as the root user with --user=mysql the process does not start and the following error message appears in the error log.

    040706 17:03:06 mysqld started
    Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
    040706 17:03:06 Aborting

    The user does exist, does anyone have any ideas what I am doing wrong?
  • kevin
    Love is life
    • Dec 2015
    • 83

    #2
    normally under redhat, the foillowing command should work correctly:
    % service mysql restart

    Comment

    • Paul
      Junior Member
      • May 2004
      • 11

      #3
      running service mysql restart produces a message mysql: unrecognized service.

      I came across this problem as I had copied the mysql.server script into the /etc/init.d directory to get mysql to start up and close down with the server.

      This runs as root but I believe it uses the --user=mysql parameter to start it as the mysql user. Is that correct?

      Comment

      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎