The correct way to run mysql on CentOS is to first use `yum install mysql-server` then set the server up with a root password. Doing this will have it set to start up automatically at boot anyway. ... [by TrevorH]
I'm working on a fresh CentOS 6.5 install and trying to get a MySQL 5.6 server daemon running. The server is a fresh droplet on DigitalOcean's infrastructure. 512 MB size. I used the MySQL version from the MySQL Yum repository. When I try to start it, it mysteriously crashes without any indication of what went wrong.
I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.
So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.
I knew the question I am asking is somewhat alike with other guys, but my case is a little different:
I did not install mysql-server using yum, nor did I install it with rpm or compile-makeinstall.
I simply downloaded the compressed precompiled binary from the official website:
Running CentOS 6.5 and mysql 5.5
I had Mysql 5.1 on my server and it started to crash, had Database was not shut down normally!, to start mysql again I had to remove mysql.sock file and than start in in ssh. I asked for help my hosting support but they told me this
The bug is not very common and we do not have a fixed solution for