Installing MySQL, can't start the server

sketchydave · 05-10-2005, 03:12 PM

Well...this one has me stumped:

Code:

[root@127.0.0.1 MySQL_rpms]# rpm -i MySQL-server-4.1.11-0.i386.rpm
warning: MySQL-server-4.1.11-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h 127.0.0.1 password 'new-password'
See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL...................................[FAILED]

The machine is running Fedora Core 3. I've spent the better part of the day trying to figure it out, and I'm stumped. But I'm going home now...will take it back up in the morning. Any suggestions would be appreciated!

sketchydave · 05-10-2005, 03:27 PM

The SQL server just does not want to get going...

Code:

root@127.0.0.1 /]# /etc/init.d/mysql start
Starting MySQL...................................          [FAILED]

So maybe its already running? Lets try stoping it...

Code:

root@127.0.0.1 /]# /etc/init.d/mysql stop
MySQL PID file could not be found!                         [FAILED]

Hmm...reload?

Code:

root@127.0.0.1 /]# /etc/init.d/mysql reload
MySQL PID file could not be found!                         [FAILED]

Restart?

Code:

root@127.0.0.1 /]# /etc/init.d/mysql restart
MySQL PID file could not be found!                         [FAILED]

Thats about where I'm at. I've uninstalled/reinstalled MySQL and I get the same thing. Very strange.

sketchydave · 05-11-2005, 02:51 PM

Trying to start the server another way...

Code:

[root@127.0.0.1]#  mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050511 15:49:07  mysqld ended

And this is the error log I'm getting:

Code:

050510 13:16:36  mysqld started
050510 13:16:36  mysqld ended

I wonder what's causing this?

sketchydave · 05-12-2005, 10:31 AM

I found a solution that works for me. I am going to wait until June 6th when Fedora Core 4 comes out and do a fresh install

What I think happened is when I installed Fedora Core 3 I specified that I wanted MySQL. But I later tried to uninstall MySQL because it was version 3 and I wanted 4.1

Somewhere along the line I must have removed some dependencies or did an install to a nonstandard directory...etc. Since I'm new to Linux I don't have the expertise to find the error.

And I don't *need* it to work on my workstation, I have MySQL working on the Mac in my office.

I assume that Fedora Core 4 will have MySQL 4.1, so I'll just sit tight for a few more weeks.

betelgeise · 05-30-2005, 01:50 PM

This is an easy problem to solve. First, you need to know to look in /var/log/msyqld.log to see what errors you are getting (if you continue to have problems after following the steps below). This problem is caused by the absence of the mysql user account.

1. Make sure mysql isn't running:

ps ax | grep mysql

Kill the processes if so.

2. Create the mysql account:

useradd -M mysql

3. Verify the location of your basedir in /etc/my.cnf, then set the permissions:

chown -R mysql:mysql /var/lib/mysql
chown mysql:mysql /var/run/mysqld

I might have missed something, but this worked for me on Redhat FC3.

sketchydave · 05-30-2005, 09:09 PM

Thanks, I fixed it a while back actually. The problem was that Fedora Core 3 comes with MySQL 3.3 and I wanted to upgrade to MySQL 4.1 and I botched the upgrade/uninstall. I reinstalled Fedora Core and it worked like a charm after that.

I really have to remember that. Doing a fresh Fedora install is so easy now and since I really don't run many programs other than what comes with Fedora I don't have much to reinstall. The updating takes a while, but that just runs overnight.