Trouble starting MySQL

From: Colin J. Raven (colin_at_kenmore.kozy-kabin.nl)
Date: 01/12/05

  • Next message: Walker, Michael: "RE: Trouble starting MySQL" 
    Date: Wed, 12 Jan 2005 10:30:20 +0100
To: FreeBSD Questions <freebsd-questions@freebsd.org>

    Greetings all,
    I installed MySQL from ports (mysql-4.1.7)
    then tried to start it. Nothing doing - wo way.

    Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No
    error message is emitted, but no running instance of mysql either.

    Two other possible options appeared to present themselves:
    -----------------------------------------------------------------
    Option number one:

    /usr/local/libexec/mysqld

    Which yielded this output:

    050112 01:19:57 [ERROR] Fatal error: Please read "Security" section of
    the manual to find out how to run mysqld as root!
    050112 01:19:57 [ERROR] Aborting
    050112 01:19:57 [Note] /usr/local/libexec/mysqld: Shutdown complete

    Well, I didn't find "the manual" onboard, and looking at *a* manual at:
    http://dev.mysql.com/doc/mysql/en/mysql-config-wizard-security.html
    hasn't (thus far) unlocked the cryptic nature of the warning above.

    -----------------------------------------------------------------

    OK, option number two:

    /usr/local/bin/mysqld_safe

    Starts a mysql process but also steals the command prompt from that
    screen window, so obviously although I have a running instance of mysql
    this isn't the way to do it.
    This is the result BTW
    root 93521 0.0 0.1 1652 1260 p2 I+ 10:22AM 0:00.02 /bin/sh
    /usr/local/bin/mysqld_safe
    mysql 93538 0.0 2.6 55596 26704 p2 S+ 10:22AM 0:00.17
    /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/
    (rest of the output on the previous line is buried at the end of the
    screen which is annoying because I'd like to see what it is)

    Oh yes, there is a user and group mysql (the installer did that, not me)
    but there is no password for user mysql yet...dunno if it's necessary,
    but even if so, not done - yet.

    Guidance from those who have been there before would be greatly
    appreciated.

    Regards,
    -Colin 

    --
Colin J. Raven
FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There IS only One - OS
Wed Jan 12 10:27:00 CET 2005
10:27AM  up 2 days, 13:56, 6 users, load averages: 0.06, 0.47, 0.65
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
  • Next message: Walker, Michael: "RE: Trouble starting MySQL"

    Relevant Pages

    • RE: Trouble starting MySQL
      ... >> No error message is emitted, but no running instance of mysql either. ... Computer viruses can be transmitted by e-mail. ...
      (freebsd-questions)
    • Re: Suddenly ODBC driver does not work
      ... > Suddenly the users and I get an error message when trying to open the ... > The page stops and shows "ODBC Drivers error '80040e21' ... I just noticed that you are using MySQL. ... This email account is my spam trap so I ...
      (microsoft.public.inetserver.asp.db)
    • Re: Perl-mysql
      ... sharing the error message you get when trying to connect will ... networking for mysql may not be active ... On 8/30/06, Manne, Siva Chaitanya Prasad ... machine from my Windows machine. ...
      (perl.beginners)
    • Re: Trouble starting MySQL
      ... > Subject: Trouble starting MySQL ... > I installed MySQL from ports ... but no running instance of mysql either. ... or some such or you may need to set execute permission on ...
      (freebsd-questions)
    • Re: connection with MySQL with Python interface
      ... > When I tried to connect with MySQL database which run on XP from shell. ... Has anyone get similar error message and provide any suggestion? ... You have to know that a client needs to have a mysql-client ...
      (comp.lang.python)