[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: MySQL won't start....



Oliver Jato wrote:

I actually changed the password while using phpmyadmin.


did you select password in the function drop down box when editing the
entries? passwords are not stored in clear text. but please, like tat said, check your ports and the bind-address in my.cnf. if you really messed up your root password and you have no write access
to the mysql database, there comes no way of rescuing to my mind than
back up the database files, install again and copy them over to the new
installation, except the old mysql database. but there are probably
better ways to fix this.


I checked the my.cnf file and it had bind-address = 127.0.0.1 commented out. Instead it had 'skip-networking'. So I commented 'skip-networking' and uncommented 'bind-addres' and tried '/etc/init.d/mysql restart' and I still received the error.

Does /var/run/mysqld/mysqld.sock get created when mysql starts? Because /var/run/mysqld is empty. I really don't have any problem with reinstalling mysql. I was just wondering if there's supposed to be a root account with no password for future reference.



Reply to: