Problem starting mysql server

am 29.05.2003 12:40:35 von Rehaz Golamnobee

Hi

I have just upgraded my MySQL from version 3.23 to 4.0.13.

However I cannot start the server. When I type mysqld_safe & I get the =
following :

[1] 1730
Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql=20
030529 11:10:51 mysqld ended
[1]+ Done mysqld_safe

When I type mysql at the Linux:/# prompt, I get the following :
Error 2002 : Can't connect to local MYSQL server through socket '/var/lib/m=
ysql/mysql.sock' (2).

I looked for the file mysql.sock in /var/lib/mysql/ but it was not there.

I used "Find File" in Linux and it could not find mysql.sock anywhere on =
the system.

I remember that the file mysql.sock was found at /var/lib/mysql/ in =
version 3.23.

Can you please help ?

These are the details of my system :
SuSe Linux O.S version 8.1 Professional
Kernel version 2.4.19
Machine - Pentium 4 2.00 GHz (Dell optiplex GX260)

Thank you

Rehaz.

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: Problem starting mysql server

am 29.05.2003 13:52:54 von Sinisa Milivojevic

Rehaz Golamnobee writes:
> Hi
>
> I have just upgraded my MySQL from version 3.23 to 4.0.13.
>
> However I cannot start the server. When I type mysqld_safe & I get the following :
>
> [1] 1730
> Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql
> 030529 11:10:51 mysqld ended
> [1]+ Done mysqld_safe
>
> When I type mysql at the Linux:/# prompt, I get the following :
> Error 2002 : Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock' (2).
>
> I looked for the file mysql.sock in /var/lib/mysql/ but it was not there.
>
> I used "Find File" in Linux and it could not find mysql.sock anywhere on the system.
>
> I remember that the file mysql.sock was found at /var/lib/mysql/ in version 3.23.
>
> Can you please help ?
>
> These are the details of my system :
> SuSe Linux O.S version 8.1 Professional
> Kernel version 2.4.19
> Machine - Pentium 4 2.00 GHz (Dell optiplex GX260)
>
> Thank you
>
> Rehaz.

This list, bugs@lists.mysql.com, is dedicated to repeatable test case,
and this is not the one.

You can not connect as the server is not running, and all possible
causes for problems in starting MySQL server are fully explained in
our manual.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Problem starting mysql server

am 29.05.2003 13:52:54 von Sinisa Milivojevic

RE: Problem starting mysql server

am 29.05.2003 15:54:27 von Nick Arnett

> -----Original Message-----
> From: Rehaz Golamnobee [mailto:rgolamnobee@uclan.ac.uk]
> Sent: Thursday, May 29, 2003 3:41 AM

....

> I have just upgraded my MySQL from version 3.23 to 4.0.13.
>
> However I cannot start the server. When I type mysqld_safe & I
> get the following :
>
> [1] 1730
> Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql
> 030529 11:10:51 mysqld ended
> [1]+ Done mysqld_safe

Sounds like it's never starting up at all, which explains why you can't
connect to it. First thing I'd do is check your config file. Are you
using the same config file as you did with 3.23? If so, you almost surely
need to update it to suit 4.x, working from the examples that came with it.
I don't recall details, but I'm quite sure that there are variable settings
that will cause this behavior.

You might first try one of the generic sample config files that came with
your new version, just to see if it'll start up properly. Then try
modifying one variable at a time, restarting after each.

Nick

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Problem starting mysql server

am 29.05.2003 18:36:41 von Chris Tucker

You should probably also take a look at your error log (dbmaster.err)...it'll
tell you in much more detail why mysqld ended rather than continued running as
expected. Often this will be something as simple as your directory permissions
not being set right on your data dir...

Chris

Nick Arnett wrote:
>>-----Original Message-----
>>From: Rehaz Golamnobee [mailto:rgolamnobee@uclan.ac.uk]
>>Sent: Thursday, May 29, 2003 3:41 AM
>
>
> ...
>
>
>>I have just upgraded my MySQL from version 3.23 to 4.0.13.
>>
>>However I cannot start the server. When I type mysqld_safe & I
>>get the following :
>>
>>[1] 1730
>>Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql
>>030529 11:10:51 mysqld ended
>>[1]+ Done mysqld_safe
>
>
> Sounds like it's never starting up at all, which explains why you can't
> connect to it. First thing I'd do is check your config file. Are you
> using the same config file as you did with 3.23? If so, you almost surely
> need to update it to suit 4.x, working from the examples that came with it.
> I don't recall details, but I'm quite sure that there are variable settings
> that will cause this behavior.
>
> You might first try one of the generic sample config files that came with
> your new version, just to see if it'll start up properly. Then try
> modifying one variable at a time, restarting after each.
>
> Nick
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org