Error message staring mysqld service

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

Swafnil

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

SoLost

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I have used (yum --enablerepo=remi install mysql-server mysql) to update mysql, the only reason i update mysql was because i upgraded php5.1 to php5.3, then I had to update php-mysql as well, this will require to upgrade mysql5.0 to 5.1 (do I have to update php-mysql 5.1 to 5.3, or shall i just leave it as it and will work)?

what folder shall i check for chmod permission?

mysql_upgrade give the following error:
[root@service~]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

what happen was, I removed all mysql rpm packages, and i even deleted /var/lib/mysql/ folder and installed mysql using folloiwng command:
yum --enablerepo=remi install mysql mysql-server php-mysql

now i don't have /var/lib/mysql/mysql.sock file under my directory, I will reinstall the server and upgrade again. and will tell you what happen.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks for your grate help foxiul01, give me one minute and will give you the detail error I am facing

ASKER

service mysqld start

tail -f /var/log/mysql.log
Error:
100422 18:14:12 mysqld started
100422 18:14:12 InnoDB: Started; log sequence number 0 44233
100422 18:14:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100422 18:14:12 mysqld ended

ASKER

Ignore above messages, i have reinstalled new server and upgraded mysql 5.0 to 5.1 and php 5.1 to 5.3, lets wait until finishes, i will tell you what happened

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

this error happen due to permission of test table..

ASKER

I fixed that by reinstalling redhat linux, and installing mysql through remi, but tomorrow i will try compiling php mysql apache, if i had problem I will ask you to help me out, if you don't mine?
thanks

no problem, let me sent you an one of my tutorial.. follow it.. it will work 100% ,i always use it always

http://www.fosiul.com/index.php/2009/09/how-to-install-apache2-php-mysql-from-source/