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 list? A

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

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-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 helpful advice. Unfortunately I've hit an error I

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

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 stopped, the

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

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

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

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 Manager to