MySQL - error #1045 cannot connect...

[Monicker]

All went well, then this occured: * Starting MySQL database server mysqld [fail]

Check /var/log/mysql.log for the cause of the error. I'm not sure what you did previously, but you may be better off starting completing over, and making sure that all the config files are purged. It looks like you reinstalled after deleting the /var/lib/mysql folder manually. If the config files were still in place the install may have assumed it did not need to create that directory. I don't know what else that may have borked.

[GCoffee]

When you say starting over what do you mean?

[Monicker]

When you say starting over what do you mean?

A fresh install, without leaving crud from an improper removal of mysql.

sudo apt-get --purge remove mysql-server
sudo rm -rf /etc/mysql
sudo rm -rf /var/lib/mysql

Then reinstall it.

[GCoffee]

I will do so tommorow, I have completely removed it,

I will reinstall tommorow.

I'm shattered..

[jimv]

Try

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

[Monicker]

Try

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

The down side to using msyql* is that it will also remove the mysql client and admin tools, which are separate from the mysql-server package.

[GCoffee]

bump

[davehimself]

I'm having the exact same issue with mysql on 8.04. I don't think there's any sort of permission issue. Mysql starts just fine with: /etc/init.d/mysql start. The run level symlinks (/etc/rc.d) *seem* to be correct, however I'm no guru in this area.

Anyone else know what's going on here?

[Monicker]

I'm having the exact same issue with mysql on 8.04. I don't think there's any sort of permission issue. Mysql starts just fine with: /etc/init.d/mysql start. The run level symlinks (/etc/rc.d) *seem* to be correct, however I'm no guru in this area.

Anyone else know what's going on here?

Did you follow the troubleshooting steps mentioned previously in this thread???

If so, what were the results?