Hello,

I am having trouble with MySQL on a newly installed Fedora 14. I have found that there are several issues with MySQL on Fedora but none of the issues I have found have exactly fit my situation. To start off, when I installed Fedora, I chose the Web Server addition. I was under the impression that this would install Apache, MySQL, and PHP. Apache was fine, I was able to get that up and running no problem. PHP is supposedly installed my php files do not run. I have not started looking into that yet. For now, I am focusing on MySQL.

I get the following when trying to run mysql:

bash: mysql: command not found...

So I tried running yum -y install mysql. I get the following after that:

Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.52-1.fc14 set to be installed
--> Processing Dependency: mysql-libs = 5.1.52-1.fc14 for package: mysql-5.1.52-1.fc14.x86_64
--> Running transaction check
---> Package mysql-libs.i686 0:5.1.52-1.fc14 set to be installed
--> Processing Dependency: libc.so.6(GLIBC_2.3.4) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.4) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libm.so.6 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libssl.so.10 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libz.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libcrypto.so.10 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libcrypt.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libnsl.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Running transaction check
---> Package glibc.i686 0:2.12.90-21 set to be installed
--> Processing Dependency: libfreebl3.so for package: glibc-2.12.90-21.i686
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12.90-21.i686
---> Package openssl.i686 0:1.0.0c-1.fc14 set to be installed
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.0c-1.fc14.i686
---> Package zlib.i686 0:1.2.5-2.fc14 set to be installed
--> Running transaction check
---> Package krb5-libs.i686 0:1.8.2-7.fc14 set to be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.8.2-7.fc14.i686
--> Processing Dependency: libselinux.so.1 for package: krb5-libs-1.8.2-7.fc14.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.8.2-7.fc14.i686
---> Package libcom_err.i686 0:1.41.12-6.fc14 set to be installed
---> Package nss-softokn-freebl.i686 0:3.12.8-1.fc14 set to be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.2-6.fc12 set to be installed
---> Package libselinux.i686 0:2.0.96-6.fc14.1 set to be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================================================
 Package                                     Arch                            Version                                     Repository                        Size
================================================================================================================================================================
Installing:
 mysql                                       x86_64                          5.1.52-1.fc14                               updates                          889 k
Installing for dependencies:
 glibc                                       i686                            2.12.90-21                                  updates                          4.3 M
 keyutils-libs                               i686                            1.2-6.fc12                                  fedora                            18 k
 krb5-libs                                   i686                            1.8.2-7.fc14                                updates                          693 k
 libcom_err                                  i686                            1.41.12-6.fc14                              updates                           34 k
 libselinux                                  i686                            2.0.96-6.fc14.1                             updates                          107 k
 mysql-libs                                  i686                            5.1.52-1.fc14                               updates                          1.2 M
 nss-softokn-freebl                          i686                            3.12.8-1.fc14                               updates                          112 k
 openssl                                     i686                            1.0.0c-1.fc14                               updates                          1.4 M
 zlib                                        i686                            1.2.5-2.fc14                                fedora                            82 k

Transaction Summary
================================================================================================================================================================
Install      10 Package(s)

Total size: 8.8 M
Installed size: 26 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  package mysql-libs-5.1.52-2.fc14.x86_64 (which is newer than mysql-libs-5.1.52-1.fc14.i686) is already installed

Error Summary

service mysqld start results in:

mysqld: unrecognized service

chkconfig mysqld on

error reading information on service mysqld: Bad file descriptor

So I also tried, yum remove mysql which results in:

Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Setting up Remove Process
No Match for argument: mysql
Package(s) mysql available, but not installed.
No Packages marked for removal

I am kind of stuck. I am not an expert at Linux systems but I did set up a LAMP server using Debian GNU and Ubuntu. This is the first time I chose webserver in the initial install though. When I trying doing this through Add/Remove programs through the GUI, it shows MySQL is not installed.

Any help would be appreciated.

Thanks!

If you run:

-bash-3.00$ rpm -qa | grep mysql
mysql-server-4.1.22-2.el4_8.4
php-mysql-4.3.9-3.31
mysql-devel-4.1.22-2.el4_8.4
mysql-4.1.22-2.el4_8.4

you will see what packages with mysql in their name are installed.

What you are looking for is mysql-server, which is the package that contains the server.

The mysql package is for the mysql client.

If you have no mysql-server package then try:

yum install mysql-server

The reason you are getting the error when you try to install mysql is that the version of mysql-libs on your system is newer than that in the repository.

Have you added other repositories or maybe installed an rpm directly rather than using yum?

Thanks for the reply Moncky.

My server is off line right now but I will try that when I get home and update with the results.

The only things I have done around mysql are the commands listed above. I did try clearing the cache of yum update packages but that did not work. I am assuming nothing installed through yum since I received the newer version error.

The only thing I did different this time then with my other servers was choose the easy path of selecting web server in the initial install of the Fedora OS. I am sure this installed mysql or at least downloaded the packages. I just dont know how to complete the install without using yum install. I am guessing the resolution of this issue is basically the same steps I will need to take to complete the install of PHP.

Thanks again.

So when I do rpm -qa | grep mysql I get:

php-mysql-5.3.4-1.fc14.1.x86_64
mysql-libs-5.1.52-2.fc14.x86_64

I tried running yum -y mysql-server and got the same error I did with yum -y install mysql.

Any other thoughts?

As I mentioned the version of mysql-libs is newer than that in the repo you are using.

I would install the library package and then install the server and client packages from there.

There is a yum command that I can't remember off the top of my head that checks to see what packages depend on others. I think its yum depends package.

Check to make sure your not going to break anything you have installed already first.

Ok...I was able to get it installed. I used your:

rpm -qa | grep mysql

I then did:

rpm -e mysql-libs-5.1.52-2.fc14.x86_64

This resulted in dependency errors. All of the dependencies were on php, which is not working either at this point, I worked my way down each dependency removing mysql and php. When I was done, I re-tired:

yum -y install mysql

And now it is installed. Interesting that yum install does not download the most up to date version of mysql and that the OS Installation of a Web Server downloads a different version.