MySQL problems...

English Network/Internet
#1

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:


**the-matrix:~ # mysql start**
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

or


**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

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

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

The pattern. See this:
http://www.raversrevolution.nl/Softwarebeheer.png

#4

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

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

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

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.