Installation on Fedora 4

I've downloaded and run the rpm's for MySQL 5.019, both client and
server. Now when I type mysql start at a command prompt, I get "Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

Where do I go from here? I'm a linux newbie, btw.

Scott

"Scott" <nospam@nospam> wrote in message
news:1142961765.8266.6.camel@localhost.localdomain ...
> I've downloaded and run the rpm's for MySQL 5.019, both client and
> server. Now when I type mysql start at a command prompt, I get "Can't
> connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> Where do I go from here? I'm a linux newbie, btw.

I'd guess that you installed the MySQL-Server RPM, but you didn't start it.
The RPM should have set things up for you so that you can now use the
following command to start the MySQL server:

# /etc/init.d/mysql start

See the following web pages for more information on starting the MySQL
server:
http://dev.mysql.com/doc/refman/5.0/...ql-server.html
http://dev.mysql.com/doc/refman/5.0/en/mysqld-safe.html

Regards,
Bill K.

On Tue, 2006-03-21 at 10:04 -0800, Bill Karwin wrote:

> "Scott" <nospam@nospam> wrote in message
> news:1142961765.8266.6.camel@localhost.localdomain ...
> > I've downloaded and run the rpm's for MySQL 5.019, both client and
> > server. Now when I type mysql start at a command prompt, I get "Can't
> > connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> >
> > Where do I go from here? I'm a linux newbie, btw.
>
> I'd guess that you installed the MySQL-Server RPM, but you didn't start it.
> The RPM should have set things up for you so that you can now use the
> following command to start the MySQL server:
>
> # /etc/init.d/mysql start
>
> See the following web pages for more information on starting the MySQL
> server:
> http://dev.mysql.com/doc/refman/5.0/...ql-server.html
> http://dev.mysql.com/doc/refman/5.0/en/mysqld-safe.html
>
> Regards,
> Bill K.
>
>

Bill,

Thank you for the additional info. The command you suggested gave the
following error:
Starting MySQLCouldn't find MySQL manager or server [FAILED]

I tried using the --basedir option as well, but with no luck.

I'd be willing to remove all MySql installations and start with a clean
slate, if someone would get me started in that direction.

Scott

"Scott" <nospam@nospam> wrote in message
news:1142968573.8266.49.camel@localhost.localdomai n...
> Thank you for the additional info. The command you suggested gave the
> following error:
> Starting MySQLCouldn't find MySQL manager or server [FAILED]

First, make sure you are not running SElinux (security enhancements),
because MySQL won't run with SElinux enabled. See
http://bugs.mysql.com/bug.php?id=12676. You can turn off SElinux with this
command at a root shell prompt:

# setenforce 0

See this following bug logs:
"mysql 5.0 will not start on fedora core 4":
http://bugs.mysql.com/bug.php?id=15104
"/etc/init.d/mysql script doesn't work under fedora core 4"
http://bugs.mysql.com/bug.php?id=14457

Fedora Core 4 comes with MySQL 4.0 if I recall correctly. The RPM for MySQL
5.0 puts some files in different places than the corresponding files reside
in the FC4 installation of MySQL 4.0. So the /etc/init.d/mysql file or the
/etc/my.cnf file contain settings that direct the software to look for its
datadir in the wrong place.

Apparently the installation of MySQL 5.0 does not replace the
/etc/init.d/mysql script or the /etc/my.cnf file. That's okay -- it's
traditional not to overwrite existing config files during an installation,
because the user might have some settings they don't want to lose.

So you could remove the files /etc/init.d/mysql and /etc/my.cnf that were
left over from the previous installation of MySQL, then reinstall MySQL 5.0
to get the new copies of those files, containing the settings that are
correct for MySQL 5.0.

Regards,
Bill K.

Thanks, Bill. That seemed to do the trick.

Now, on to PHP...

On Tue, 2006-03-21 at 13:48 -0800, Bill Karwin wrote:

> "Scott" <nospam@nospam> wrote in message
> news:1142968573.8266.49.camel@localhost.localdomai n...
> > Thank you for the additional info. The command you suggested gave the
> > following error:
> > Starting MySQLCouldn't find MySQL manager or server [FAILED]
>
> First, make sure you are not running SElinux (security enhancements),
> because MySQL won't run with SElinux enabled. See
> http://bugs.mysql.com/bug.php?id=12676. You can turn off SElinux with this
> command at a root shell prompt:
>
> # setenforce 0
>
> See this following bug logs:
> "mysql 5.0 will not start on fedora core 4":
> http://bugs.mysql.com/bug.php?id=15104
> "/etc/init.d/mysql script doesn't work under fedora core 4"
> http://bugs.mysql.com/bug.php?id=14457
>
> Fedora Core 4 comes with MySQL 4.0 if I recall correctly. The RPM for MySQL
> 5.0 puts some files in different places than the corresponding files reside
> in the FC4 installation of MySQL 4.0. So the /etc/init.d/mysql file or the
> /etc/my.cnf file contain settings that direct the software to look for its
> datadir in the wrong place.
>
> Apparently the installation of MySQL 5.0 does not replace the
> /etc/init.d/mysql script or the /etc/my.cnf file. That's okay -- it's
> traditional not to overwrite existing config files during an installation,
> because the user might have some settings they don't want to lose.
>
> So you could remove the files /etc/init.d/mysql and /etc/my.cnf that were
> left over from the previous installation of MySQL, then reinstall MySQL 5.0
> to get the new copies of those files, containing the settings that are
> correct for MySQL 5.0.
>
> Regards,
> Bill K.
>
>