Topic: Unable to start MySQL - V5.1.47-1

Afternoon all,

My system is Red Hat Enterprise Linux 5.3 x86_64 and I have just installed the following packages:

mysql - All version 5.1.47-1.el5
mysqlclient15
mysql-devel
mysql-libs
mysql-server
perl-DBD-mysql

php - All version 5.3.2-1.el5
php-cli
php-common
php-mysql
php-pdo

sqlite2-2.8.17-2.el5

Once installed I go to start the MySQL service by issuing the command:

service mysqld start

However I get the following output:

[root@Stephenson phprpms]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

Upon looking at the log I see some error messages but don't know what they mean, anyone shed any light?

100608 16:01:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Unknown collation '#46' in table 'plugin' definition
100608 16:01:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100608 16:01:53  InnoDB: Started; log sequence number 0 46409
100608 16:01:53 [ERROR] Fatal error: Can't open and lock privilege tables: Unknown collation '#46' in table 'host' definition
100608 16:01:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Really need to get this working ASAP.

Cheers.

Re: Unable to start MySQL - V5.1.47-1

In which MySQL version you're database have been created ?

Do you run mysql_upgrade on each new version.

Here is some tests
- downgrade mysql (previous major version)
- dump the database
- run mysql_update

- upgrade mysql
if launch succed
- run nmysql_upgrade again

if it fails
- create an empty database
- load the dump

+

P.S. ASAP have no meaning when using free software

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: Unable to start MySQL - V5.1.47-1

I think there was a previous version of MySQL running on this particular server but I don't know what version it was or if it was ever used.

I've not gotten as far as creating any sort of database at all, would it be easier to uninstall the RPMS and then manually uninstall any remaining bits?

Re: Unable to start MySQL - V5.1.47-1

Well, if you don't have any data, just create a new database

service mysqld stop
rm -rf /var/lib/mysql/*
service mysqld start
mysql_secure_installation

+

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: Unable to start MySQL - V5.1.47-1

Thats brilliant Remi, thank you very much smile