MySQL Server Wont Start!!! (UBUNTU)

Hey all,

I'm a complete n00b when it comes to linux administration, however I've had an ubuntu distro running now for about 2 months with no probs (PHP, Apache2, MySQL). Then yesterday i tried to install and configure an MTA and MTU (Which didn't work) but since then MySQL server has stopped working and I have no idea why, I've got WebMin installed and that says "MySQL is not running on your system - database list could not be retrieved." PHPMyAdmin says "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)". Iv'e tried restarting manually with /etc/init.d/mysql start with no avail. Just completely stumped!
LVL 1
aarmstr2Asked:
Who is Participating?
 
PazHRCCommented:
try to do the most simple thing:
$ sudo apt-get remove --purge mysql
$ sudo apt-get install mysql

i'm sure who after this mysql will work
0
 
cjl7freelance for hireCommented:
When you try to start the mysql-server does the syslog report any errors?

Also when you start it with /etc/init.d/mysql start - what happens?

//jonas
0
 
aarmstr2Author Commented:
How would i check the syslog? mysql.log and mysql.err are empty. When i run /etc/init.d/mysql start nothing happens at all.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
samriCommented:
hi,

The mysql log would be in /var/log/mysqld.log (on Centos5.4)

check your /etc/my.cnf for any clue.  The default on centos is

[root@loaclhost log]# more /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=ysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@localhost log]#


I found some detailed info on this link.
http://fak3r.com/2009/02/18/howto-configure-mysqls-mycnf-fil/

cheers,
0
 
cjl7freelance for hireCommented:
does 'ps -ef |grep mysql' show anything?

how about a 'service mysql restart'

Are you running SELinux ('sestatus')

//jonas
0
 
aarmstr2Author Commented:
ps -ef |grep mysql returns '5390  4722  0 11:45 pts/0    00:00:00 grep mysql', service mysql restart did nothing. samri, cnf and log eother do not exist in that location or are empty. SE Linux is disabled.
0
 
aarmstr2Author Commented:
wont that delete my databases too?
0
 
aarmstr2Author Commented:
Tried that anyways, it says 'E: Couldn't find package mysql'
0
 
cjl7freelance for hireCommented:
mysql-server
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.