MySQL won"t run on Ubuntu 10.10

MySQL List,

I'm running Ubuntu 10.10, and I have a LAMP server which is not connected to the internet, but is just used for locally creating and testing web sites.

MySQL does not seem to be running, however. Check out the output from these commands:

~$ sudo service mysql start
mysql start/running
~$ ps -ef | grep mysql
dave 23043 22341 0 23:57 pts/0 00:00:00 grep mysql

If I understand these outputs, it says MySQL is running when I start it up, but, after that, if I look for the process, it doesn't show up as
running.

When I run any of my local web sites that rely on MySQL, they don't work, so I guess the final verdict is that MySQL isn't on.

But, without any error when I try to start it, I'm not sure how to diagnose the problem.

I tried purging then re-installing MySQL, but that didn't change anything.

Any ideas on what else I could try?

Thank you for any advice.

-- Dave M G


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

Re: MySQL won"t run on Ubuntu 10.10

Check whether mysql is running:
ps aux | grep mysqld

If MySQL is not running, check /var/log/mysql/error.log for errors.

Have you changed /etc/mysql/my.cnf and/or /etc/mysql/conf.d/*.cnf or are
are you still using the default config files from Ubuntu?


On 10/16/2010 06:30 PM, Dave M G wrote:
>
> MySQL List,
>
> I'm running Ubuntu 10.10, and I have a LAMP server which is not connected to the internet, but is just used for locally creating and testing web sites.
>
> MySQL does not seem to be running, however. Check out the output from these commands:
>
> ~$ sudo service mysql start
> mysql start/running
> ~$ ps -ef | grep mysql
> dave 23043 22341 0 23:57 pts/0 00:00:00 grep mysql
>
> If I understand these outputs, it says MySQL is running when I start it up, but, after that, if I look for the process, it doesn't show up as
> running.
>
> When I run any of my local web sites that rely on MySQL, they don't work, so I guess the final verdict is that MySQL isn't on.
>
> But, without any error when I try to start it, I'm not sure how to diagnose the problem.
>
> I tried purging then re-installing MySQL, but that didn't change anything.
>
> Any ideas on what else I could try?
>
> Thank you for any advice.
>
> -- Dave M G
>
>
>

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

Re: MySQL won"t run on Ubuntu 10.10 [SOLVED]

Bruijne,

Thank you for responding.

The my.cnf file was fine, but when you mentioned it, it sparked a long
forgotten memory that there was something specific to Ubuntu that
affects who has access to files like my.cnf.

After a little web searching, I realized it is a security thing called
"Apparmour".

Long story short, when I upgraded Ubuntu, I kept the my.cnf file that
had served me well for years, but had overwritten
/etc/apparmor.d/usr.sbin.mysqld with new default settings. Some of the
directories in that file did not match my system.

Editing the Apparmour file and restarting both Apparmour and MySQL
solved the problem.

Thank you for setting me in the right direction.

--
Dave M G

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