Centos – Installing MySQL on CentOS

centosMySQLyum

I have set up a nginx server running php-fpm and everything is working great. PHP is compiled with the mysql and mysqli extensions, but I'm having trouble installing MySQL. I did this command:

yum install mysql-server mysql-client

and it only installed mysql-server. it throws this error about mysql-client:

No package mysql-client available.

Now, I think MySQL is installed properly (since it mananged to install mysql-server), but when I type mysql in the SSH terminal in order to create databases etc I get this:

-bash: mysql: command not found

Which leads me to believe I need the mysql-client package installed in order to do run commands from the terminal.

Under /etc/yum.respos.d/ I have:

CentOS-Base.repo  CentOS-Debuginfo.repo  CentOS-Media.repo

Best Answer

Check out yum provides "*/mysql" to find out which package provides a file in future, but the package is just called mysql in CentOS, so yum install mysql.

Related Solutions

Centos – How to install APC and Memcache on CentOS WITHOUT installing the PHP package

Your custom-compiled PHP should have installed pecl, and configured it properly.

Have you tried running "pecl install apc"?

If your system is not finding pecl, it's probable that you used some funny --prefix when you ./configure'd PHP.

For instance, if you compiled php like this:

$ ./configure --prefix=/foo
$ make
# make install

then you'll either want to get /foo/bin into $PATH, or you could just run

$ /foo/bin/pecl install apc

EDIT: Now I remember: try pecl install apc-beta. Something is screwy with 5.3.3 and non-beta APC. My experience is apc-beta works fine.

CentOS 5.5 – configuring thesql with php, missing thesql.so

Odd. On my RHEL box, mysql.so is provided by php-mysql. What does rpm -ql php-mysql | grep mysql.so give you?

It's possible you're running into versioning issues? The RHEL/CentOS repository is on version 5.1.6 of PHP. But you've compiled php5.3 from source, and it appears you've used the php-mysql package. I'm not sure if the latter will play nice with the former. You might be better off from an ease of administration standpoint just installing the php package from the repository. If you don't need any of the features provided solely in 5.3, it'll probably be a ton easier for you.

Also, did you compile PHP with the proper flags for mysql? (--with-mysql ?)

--Christopher Karel

Best Answer

Related Solutions

Centos – How to install APC and Memcache on CentOS WITHOUT installing the PHP package

CentOS 5.5 – configuring thesql with php, missing thesql.so

Related Topic