[SOLVED] mysqld: unrecognized service

OtagoHarbour · 10-14-2012, 08:02 AM

I have installed LAMP on Ubuntu 11.04. PHP works fine but,when I try to access mysql, I get

Code:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

In the past I have fixed this problem with

Code:

sudo service mysqld restart

but now that gives me

Code:

mysqld: unrecognized service

I subsequently tried

Code:

sudo apt-get remove mysql-server
sudo apt-get install mysql-server

but it did not make any difference. I then tried

Code:

sudo /usr/bin/mysql_secure_installation

also to no avail.

Any help resolving this would be most appreciated,
Peter

jsaravana87 · 10-15-2012, 12:55 AM

Try These command

sudo apt-get purge mysql-server mysql-common
sudo apt-get purge mysql-client

sudo apt-get autoremove mysql-server mysql-client mysql-common

sudo apt-get autoclean mysql-server mysql-client mysql-common

To reinstall:
sudo apt-get install mysql-server mysql-common mysql-client

OtagoHarbour · 10-15-2012, 08:24 PM

Quote:

Originally Posted by arun5002

Try These command

sudo apt-get purge mysql-server mysql-common
sudo apt-get purge mysql-client

sudo apt-get autoremove mysql-server mysql-client mysql-common

sudo apt-get autoclean mysql-server mysql-client mysql-common

To reinstall:
sudo apt-get install mysql-server mysql-common mysql-client

Thank you very much! I think that fixed the problem but it's hard to tell since the password I set during the installation doesn't work. I tried two different passwords and tried just hitting return for the password. I always get the following message.

Code:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

when I enter

Code:

mysql --user=root --password=MyPassword

Thanks,
Peter.

elimqiu · 02-19-2014, 05:04 PM

On Ubuntu 13.10, I removed and re-installed mysql server and client, still get

mysqld: unrecognized service