Mysql – phptheadmin error #2002 cannot connect to thesql server

You can kill the mysql process manually.

$ ps ax | grep mysql

Note the process id. Then,

$ kill __pid__

Next thing you should do is edit your my.cnf file, and check to make sure that the socket location is /tmp/mysql.sock. For example, this is what my [client] section looks like:

[client]
user=mysql
port=3306
socket=/tmp/mysql.sock

Let's say $MYSQL is your MySQL folder (in the case of the tutorial you provided, it's probably in /usr/local/mysql/bin). If you haven't already done so, you have to set up your databases and give your superuser a password.

$ useradd mysql
$ cd $MYSQL
$ ./mysql_install_db

Start MySQL here. Then:

$ ./mysqladmin -u root password '<your_password>'
$ chown -R mysql:mysql /usr/local/mysql/var

Then run sudo ./mysqld_safe --user=mysql & and you should be set.

Building on the previous answers, all you should need to do is:

yum install mysql-server
service mysqld start

The first time the service is started, it should prompt you to set the root password.