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: