Results 1 to 7 of 7

Thread: MySQL problems...

  1. #1
    Join Date
    Dec 2010
    Location
    California, USA
    Posts
    50

    Default MySQL problems...

    I think this goes here, but I'm not sure.

    I decided that XAMPP had been troublesome enough. MySQL never worked.
    So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong.

    So I try to start mysql, and here's what I get:
    Code:
    the-matrix:~ # mysql start
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
    or
    Code:
    the-matrix:~ # rcmysql start
    Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
    chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
                                                                         failed
    I have searched and searched, both on this forum and elsewhere. I have looked in /var/mysql/ and found no mysql.sock.
    Or anywhere else.
    And the command rpm -qal mysql yields nothing, so I can't use that.

    Thanks!

  2. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,683
    Blog Entries
    4

    Default Re: MySQL problems...

    The first one doesn't work because mysql is the client, not the server.

    Go into YaST and see if mysql is offered as a service. Try to start it from there.

    Also not sure what you did to install the LAMP stack. Did you install the LAMP pattern, or the components separately? Perhaps you missed installing the server?

  3. #3
    Join Date
    Dec 2010
    Location
    California, USA
    Posts
    50

    Default Re: MySQL problems...

    Quote Originally Posted by ken_yap View Post
    Go into YaST and see if mysql is offered as a service. Try to start it from there.
    I get a window that says:
    /etc/init.d/mysql start returned 1 (unspecified exit):(translated from Dutch).

    Quote Originally Posted by ken_yap View Post
    Also not sure what you did to install the LAMP stack. Did you install the LAMP pattern, or the components separately? Perhaps you missed installing the server?
    The pattern. See this:

  4. #4

    Default Re: MySQL problems...

    thomas23272 wrote:
    > ken_yap;2350460 Wrote:
    >> Go into YaST and see if mysql is offered as a service. Try to start it
    >> from there.

    > I get a window that says:
    > -/etc/init.d/mysql start returned 1 (unspecified exit):-(translated
    > from Dutch).


    and the logs say ....?

  5. #5
    Join Date
    Dec 2010
    Location
    California, USA
    Posts
    50

    Default Re: MySQL problems...

    Quote Originally Posted by djh-novell View Post
    thomas23272 wrote:
    > ken_yap;2350460 Wrote:
    >> Go into YaST and see if mysql is offered as a service. Try to start it
    >> from there.

    > I get a window that says:
    > -/etc/init.d/mysql start returned 1 (unspecified exit):-(translated
    > from Dutch).


    and the logs say ....?
    Which logs?

    I am a newbie a setting up webservers. Previously I have used XAMPP, and that worked fine(until now). All of the logs there were in /opt/lampp/logs. Where are they with the openSuSE server?

    Thanks,
    Thomas

  6. #6

    Default Re: MySQL problems...

    thomas23272 wrote:
    > djh-novell;2350653 Wrote:
    >> thomas23272 wrote:
    >>> ken_yap;2350460 Wrote:
    >>>> Go into YaST and see if mysql is offered as a service. Try to start

    >> it
    >>>> from there.
    >>> I get a window that says:
    >>> -/etc/init.d/mysql start returned 1 (unspecified exit):-(translated
    >>> from Dutch).

    >> and the logs say ....?

    > Which logs?
    >
    > I am a newbie a setting up webservers. Previously I have used XAMPP,
    > and that worked fine(until now). All of the logs there were in
    > /opt/lampp/logs. Where are they with the openSuSE server?


    Well being a newbie doesn't excuse you from reading documentation when
    people give you a hint. Or indeed from reading documentation when things
    go wrong before they give you a hint, or even before trying to do new
    things on a system...

    Logs on Linux systems live in /var/log

    There are system logs, mysql logs and yast logs in there. See what
    messages you can find.

  7. #7
    Join Date
    Dec 2010
    Location
    California, USA
    Posts
    50

    Default Re: MySQL problems...

    I looked in /var/logs/apache2/error_log, and I couldn't find anything having to with MySQL; just the usual 404 messages.

    Is there anywhere else I should look? I read the Apache Error Log Documentation, and I didn't find anything about other logs that may be useful.

    Perhaps it has something to do with my.cnf? I didn't find a my.cnf in /etc, just my.cnf.rpmsave and my.cnf.rpmnew. In addition, /var/log/mysql is empty.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •