Re: MySQL not running on fresh LAMP install

2008-09-18 Thread Dave M G
MySQL List, Thanks for your advice and help. I tried various things suggested, and in the end, this is what seems to have worked (I've abbreviated most of the output): $ sudo pkill -9 mysqld $ sudo dpkg --force-all -r mysql-server-5.0 This removed MySQL, but left the configuration files. I w

Re: MySQL not running on fresh LAMP install

2008-09-18 Thread Madan Thapa
On Thu, Sep 18, 2008 at 1:33 PM, Glyn Astill <[EMAIL PROTECTED]> wrote: > > > Part of the problem is that I can't stop the server. > > Oh, so it does start? I thought it also wasn't starting, if it's not > starting then stopping it will fail. >

Re: MySQL not running on fresh LAMP install

2008-09-18 Thread Glyn Astill
> Part of the problem is that I can't stop the server. Oh, so it does start? I thought it also wasn't starting, if it's not starting then stopping it will fail. > Is there anything else I can do to get a clean install of > MySQL running > again? > Can you list what appears in the process lis

Re: MySQL not running on fresh LAMP install

2008-09-17 Thread Dave M G
Glyn, Thank you for responding. To start with, check that the .pid file doesn't exist if the server is stopped Part of the problem is that I can't stop the server. $ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld [fail] try running it manually with "/etc/init.d/mysql

Re: MySQL not running on fresh LAMP install

2008-09-17 Thread Glyn Astill
> The mysqld.pid file is in /var/run/mysqld. > > The mysql.sock file is in /tmp > > > What symlink did you make? > None right now. I removed any that I had made before so > that I wouldn't > confuse the situation. > To start with, check that the .pid file doesn't exist if the server is stoppe

Re: MySQL not running on fresh LAMP install

2008-09-17 Thread Dave M G
Glyn, Thanks for responding. Does the .pid file exist in either /var/run/mysqld/ or /tmp/ at the moment? The mysqld.pid file is in /var/run/mysqld. The mysql.sock file is in /tmp What symlink did you make? None right now. I removed any that I had made before so that I wouldn't confuse t

Re: MySQL not running on fresh LAMP install

2008-09-17 Thread Glyn Astill
--- On Wed, 17/9/08, Dave M G <[EMAIL PROTECTED]> wrote: > From: Dave M G <[EMAIL PROTECTED]> > Subject: Re: MySQL not running on fresh LAMP install > To: mysql@lists.mysql.com > Date: Wednesday, 17 September, 2008, 12:51 PM > TLUG, > > Thanks for the helpfu

Re: MySQL not running on fresh LAMP install

2008-09-17 Thread Dave M G
TLUG, Thanks for the helpful advice. Unfortunately I've hit an error I don't know what to do about. The symlink solution worked, but Ubuntu clears the /tmp directory on every boot. So I edited the my.cnf file to use /tmp/mysql.sock. But when I tried to restart MySQL, it kept saying "[fail]".

Re: MySQL not running on fresh LAMP install

2008-09-16 Thread David Ashley
On Tue, Sep 16, 2008 at 11:02 AM, Dave M G <[EMAIL PROTECTED]> wrote: > MySQL List, > > I'm going through a post-hard-drive-crash process of reinstalling my whole > operating system, and MySQL is acting very strange. > > I installed it as I always have done, by using Ubuntu's Synaptic Package > Ma

Re: MySQL not running on fresh LAMP install

2008-09-16 Thread Josh Miller
Dave M G wrote: [EMAIL PROTECTED]:~$ ps aux | grep mysql And it said back to me: root 11171 0.0 0.0 1772 532 ?S20:36 0:00 /bin/sh /usr/bin/mysqld_safe mysql11290 0.1 0.7 126708 15424 ?Sl 20:36 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/m

MySQL not running on fresh LAMP install

2008-09-16 Thread Dave M G
MySQL List, I'm going through a post-hard-drive-crash process of reinstalling my whole operating system, and MySQL is acting very strange. I installed it as I always have done, by using Ubuntu's Synaptic Package Manager to install all the default packages for a LAMP server. Every time before