Hi All: I'm trying to get mysql 5 installed on my CentOS 4.6 installation. I've installed mysql using yum: yum -y install perl-DBD-MySQL mysql-server mysql php-mysql mod_auth_mysql phpmyadmin mysqlclient Yum says it installed fine: Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package phpmyadmin.noarch 0:2.11.4-1.el4.rf set to be updated ---> Package perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 set to be updated ---> Package php-mysql.x86_64 0:5.1.6-3.el4s1.8 set to be updated ---> Package mysql-server.x86_64 0:5.0.54-1.el4.centos set to be updated ---> Package mod_auth_mysql.x86_64 1:3.0.0-2.el4s1.3 set to be updated ---> Package mysql.x86_64 0:5.0.54-1.el4.centos set to be updated --> Running transaction check Dependencies Resolved ============================================================================ Package Arch Version Repository Size ============================================================================Installing: mod_auth_mysql x86_64 1:3.0.0-2.el4s1.3 centosplus 22 k mysql x86_64 5.0.54-1.el4.centos centosplus 2.9 M mysql-server x86_64 5.0.54-1.el4.centos centosplus 10 M perl-DBD-MySQL x86_64 2.9004-3.1.centos4 base 112 k php-mysql x86_64 5.1.6-3.el4s1.8 centosplus 85 k phpmyadmin noarch 2.11.4-1.el4.rf dag 4.2 M Transaction Summary ============================================================================Install 6 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 17 M Downloading Packages: Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: mysql ######################### [1/6] Installing: php-mysql ######################### [2/6] Installing: perl-DBD-MySQL ######################### [3/6] Installing: phpmyadmin ######################### [4/6] Installing: mysql-server ######################### [5/6] Installing: mod_auth_mysql ######################### [6/6] Installed: mod_auth_mysql.x86_64 1:3.0.0-2.el4s1.3 mysql.x86_64 0:5.0.54-1.el4.centos mysql-server.x86_64 0:5.0.54-1.el4.centos perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 php-mysql.x86_64 0:5.1.6-3.el4s1.8 phpmyadmin.noarch 0:2.11.4-1.el4.rf Complete! But there isn't a my.cnf file in /etc/ Nor are there any files in: [root at ftp ~]# ls /var/lib/mysql/ mysql test [root at ftp ~]# ls /var/lib/mysql/mysql/ An rpm query shows everything should be installed: [root at ftp ~]# rpm -qa mysql mysql-5.0.54-1.el4.centos [root at ftp ~]# rpm -qa mysql* mysqlclient14-4.1.22-1.el4s1.1 mysqlclient10-devel-3.23.58-9.2.c4 mysql-5.0.54-1.el4.centos mysqlclient10-3.23.58-4.RHEL4.1 mysql-server-5.0.54-1.el4.centos mysqlclient10-3.23.58-9.2.c4 mysql-libs-5.0.54-1.el4.centos Trying to start mysql results in: [root at ftp ~]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] Thoughts?
Ed Morrison wrote:> Hi All: > > I'm trying to get mysql 5 installed on my CentOS 4.6 installation. > I've installed mysql using yum: > > yum -y install perl-DBD-MySQL mysql-server mysql php-mysql > mod_auth_mysql phpmyadmin mysqlclient > > Yum says it installed fine: > > Resolving Dependencies > --> Populating transaction set with selected packages. Please wait. > ---> Package phpmyadmin.noarch 0:2.11.4-1.el4.rf set to be updated > ---> Package perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 set to be updated > ---> Package php-mysql.x86_64 0:5.1.6-3.el4s1.8 set to be updated > ---> Package mysql-server.x86_64 0:5.0.54-1.el4.centos set to be updated > ---> Package mod_auth_mysql.x86_64 1:3.0.0-2.el4s1.3 set to be updated > ---> Package mysql.x86_64 0:5.0.54-1.el4.centos set to be updated > --> Running transaction check > > Dependencies Resolved > > ============================================================================= > > Package Arch Version Repository > Size > ============================================================================= > > Installing: > mod_auth_mysql x86_64 1:3.0.0-2.el4s1.3 > centosplus 22 k > mysql x86_64 5.0.54-1.el4.centos > centosplus 2.9 M > mysql-server x86_64 5.0.54-1.el4.centos > centosplus 10 M > perl-DBD-MySQL x86_64 2.9004-3.1.centos4 > base 112 k > php-mysql x86_64 5.1.6-3.el4s1.8 centosplus > 85 k > phpmyadmin noarch 2.11.4-1.el4.rf dag > 4.2 M > > Transaction Summary > ============================================================================= > > Install 6 Package(s) Update 0 Package(s) > Remove 0 Package(s) Total download size: 17 M > Downloading Packages: > Running Transaction Test > Finished Transaction Test > Transaction Test Succeeded > Running Transaction > Installing: mysql ######################### [1/6] > Installing: php-mysql ######################### [2/6] > Installing: perl-DBD-MySQL ######################### [3/6] > Installing: phpmyadmin ######################### [4/6] > Installing: mysql-server ######################### [5/6] > Installing: mod_auth_mysql ######################### [6/6] > > Installed: mod_auth_mysql.x86_64 1:3.0.0-2.el4s1.3 mysql.x86_64 > 0:5.0.54-1.el4.centos mysql-server.x86_64 0:5.0.54-1.el4.centos > perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 php-mysql.x86_64 > 0:5.1.6-3.el4s1.8 phpmyadmin.noarch 0:2.11.4-1.el4.rf > Complete! > > > But there isn't a my.cnf file in /etc/if you want one, you need to create it. the package installs example file that you can use.> Nor are there any files in: > [root at ftp ~]# ls /var/lib/mysql/ > mysql test > [root at ftp ~]# ls /var/lib/mysql/mysql/ >looks ok. at some time, you'll need to do some post-install tasks to secure the server (mainly, set a password for the root user). see mysql site or google...> > An rpm query shows everything should be installed: > [root at ftp ~]# rpm -qa mysql > mysql-5.0.54-1.el4.centos > [root at ftp ~]# rpm -qa mysql* > mysqlclient14-4.1.22-1.el4s1.1 > mysqlclient10-devel-3.23.58-9.2.c4 > mysql-5.0.54-1.el4.centos > mysqlclient10-3.23.58-4.RHEL4.1 > mysql-server-5.0.54-1.el4.centos > mysqlclient10-3.23.58-9.2.c4 > mysql-libs-5.0.54-1.el4.centos > > > Trying to start mysql results in: > [root at ftp ~]# service mysqld start > Timeout error occurred trying to start MySQL Daemon. > Starting MySQL: [FAILED] > > Thoughts?is selinux enabled on your system? check /var/log/messages.
Ed Morrison <edward.morrison at gmail.com> wrote:> mouss wrote: > >> > >> > anything in /var/log/mysqld.log? >> > nothing: > > [root at ftp ~]# cat /var/log/mysqld.log > > [root at ftp ~]#Speaking of mysqld.log, check the ownership and permissions. I vaguely remember chasing a similar problem only to find out that it was being caused by the log file not having the right permissions and ownership. For mysqld.log the should be: -rw-r----- 1 mysql mysql 249 Jan 18 16:50 mysqld.log It also looks like you have multiple versions of mysqlclient plus the mysql rpm (which is the standard client): [root at ftp ~]# rpm -qa mysql*> mysqlclient14-4.1.22-1.el4s1.1 <--First client > mysqlclient10-devel-3.23.58-9.2.c4 > mysql-5.0.54-1.el4.centos <-- The centos client > mysqlclient10-3.23.58-4.RHEL4.1 <-- Another one > mysql-server-5.0.54-1.el4.centos > mysqlclient10-3.23.58-9.2.c4 <-- and still another > mysql-libs-5.0.54-1.el4.centoswhich could explain why installing the server didn't work. You should only have: # rpm -qa | grep mysql mysql-5.0.22-2.2.el5_1.1 php-mysql-5.1.6-15.el5 mysql-devel-5.0.22-2.2.el5_1.1 mysql-server-5.0.22-2.2.el5_1.1 Cheers, Dave -- Politics, n. Strife of interests masquerading as a contest of principles. -- Ambrose Bierce
Apparently Analagous Threads
- centosplus + priority plugin
- postconf: /usr/lib/mysql/libmysqlclient.so.14: no version information available (required by postconf)
- installing MySQL on 4.3 OR ''am I braindead or what?''
- libmysqlclient not found, while compiling PowerDNS
- RE: MySQL Install error on Centos 4.3