phpMyAdmin v3.x needs to have PHP 5.2 and later version. But CentOS 5.x has still PHP 5.1.x.
This is one of methods on PHP & MySQL upgrade processes for CentOS 5.x.
1. Check your software versions in terms of PHP & MySQL
| # php -v # yum list installed php* # mysql -V |
2. Install third party repository
If you have a message like :
| $ mysql -u root -p<password> -h myserver
ERROR 2003 (HY000): Can't connect to MySQL server on 'myserver' (10061) |
Please Check the following things to slove the problem.
1. Check if mysqld is running or not in the server.
|
# ps -ef | grep mysqld |
Error 1130 is a networking error. The server cannot resolve the hostname of the client. Or the host is not allowed to connect to the MySQL server.
First you should check a user in the remort server in order to login, If not there, You have to create a user for remote login.
| mysql> use mysql; mysql> select host, user from user; |
There is no your host name, the following command can create user.
To install drupal application, you have to create MySQL Database.
Before installation, make sure your package management tools are up-to-date. Also make sure you install all
the latest software available.
|
# sudo apt-get update # sudo apt-get dist-upgrade |
After a few minutes (depending on the state of your system), you’re ready to install MySQL on ubuntu.