I installed Percona Server on a fresh Centos 6.4 minimal. Prior to this, I have never installed MySQL (though I'm not sure if Centos 6.4 minimal came with MySQL?)
Anyway, here are the commands I used:
rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm yum install Percona-Server-client-55 Percona-Server-server-55
Everything seems installed properly. However, I'm confused...
1) How come, unlike MySQL, did it not prompt me for creation of root password? How do I set the root password then?
2) When I tried starting Percona MySQL with the command "/etc/init.d/mysql start", it gave me the error:
Starting MySQL (Percona Server). ERROR! The server quit without updating PID file (/var/lib/mysql/mail.example.com.pid)
Of course, here I used example.com in place of my real domain name.
Another thing: the "pid" file does not exist. Should it be there?
Any help would be greatly appreciated.
As per the advice I got, I did a "ls -l /var/lib" and this is the folder permission of "/var/lib/mysql"
drwxr-xr-x. 4 mysql mysql 4096 Apr 26 07:01 mysql
Not sure if this is the correct permission?