I am in the process of setting up a Moodle server, and I have managed to screw up the installation of MySQL.
The environment is as follows:
CentOS 5.3
Apache 2.2
PHP 5.3
MySQL 5.1
For the most part everything was working, except that on one forum I had read that for security reasons I should create a new MySQL admin user with all privileges, and then drop the root user. So I did this. But then the new user didn't seem to have global privileges. I could create a new user and a database of the same name, but I would get an error saying that access to the new database was denied to the admin user. So I decided to just take MySQL back to a fresh installation. I uninstalled MySQL ($sudo yum remove mysql), and then re-installed it. And now it is royally screwed. Nothing seems to work anymore.
The installation of MySQL completes without any errors. But when I try the following command:
$sudo /etc/init.d/mysqld start
I get the following error:
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
If I simply execute:
$mysql
I get this error:
mysql: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
When I try to check the version of PHP like so:
$php -v
I get the following errors:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysq
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mysq
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pdo_
PHP 5.3.0 (cli) (built: Jul 19 2009 17:55:08)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2009 Zend Technologies
I installed phpMyAdmin, and when I try to connect to MySQL via phpMyAdmin I get this wrror:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
I am going nuts trying to figure out if the problem is with MySQL or PHP or what. I have spent many hours trawling through forums and blogs trying to find something which will lead me in the right direction, but so far I have had no success.
Please note - my Linux skills are very rudimentary; I am gradually becoming more comfortable with server admin via a terminal window, but there is much I don't know. I say this because I don't want Experts to assume I have a high level of knowledge regarding administering a Linux server.
Cheers,
Paul
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
To be clear:
I think your problem with the mysql daemon (mysqld)
"Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]"
is cause by a failure to run mysqld startup script: mysql_install_db.
Your problems with php and mysql are probably caused by a failure to install the mysql client pacakge.
You problem with phpmyadmin is caused by a combination of the other two.
Hi Mike,
I installed MySQL using the following command:
$sudo yum --enablerepo=remi install mysql mysql-server
It seemed to work - it downloaded two packages, installed them and finished by saying "Complete!"
I did also try this:
$sudo yum --enablerepo=remi install mysqlclient15 mysql-libs
But it says that the packages are already installed and the latest versions.
I don't even know where the file libmysqlclient.so.16 is meant to be so I can check if it is there.
Cheers,
Paul
You can use the command
sudo find / -name libmysqlclient.so.16
to find where (if anywhere) that file is on your system. It looks at every filename on your computer, though so it might take a while.
You can use the command
ldd /usr/lib/php/modules/mysql
To get a list of the dynamically linked files mysqli.so is expecting, and which ones have been found.
I'm not familiar with yum, but you might want to try removing all mysql packages and re-installing them.
Business Accounts
Answer for Membership
by: Mike_The_SpikePosted on 2009-09-16 at 12:46:27ID: 25349334
It looks like your mysql reinstall was not complete.
libmysqlclient.so.16
is a dynamic library that is either missing, or not where the installed code expects to find it.
It's unusual (in my experience) for a package system to neglect to install required libraries or prerequisite packages, but check to see if there are more packages associated with mysql that you might need to install. Did you forget to install the mysql client package?
If you also tried to compile from source, it's possible that you've compiled software that can't find it's libraries. If these binaries are found in your path before a binary that was installed by a package system, they could be "intercepting" your invocation.
Try typing the full path to the binary you want to run and see if you get different error messages.