Ahh..
Thank you very much acid_kewpie. I was able to uninstall MySQL using rpm -e MySQ-server. Regarding your remark that I am probably not running the MySQL demon, it seems you are right, the daemon was not running. I tried one more time installing MySQL 4.1.10 and found myself in exactly the same situation. The package installed and i was told
warning: MySQL-server-4.1.10-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h password 'new-password'
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Starting the server is the problem. When i run /etc/init.d/mysql start the server starts, then stops. Typing tail /var/log/mysqld.log yields
050228 01:21:23 mysqld started
050228 01:21:23 mysqld ended
It seems the daemon just won run. I am continually recieving the following error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mysql.sock does not exist on my box. Neither did my.cnf by the way, I made one and placed it in /etc/. Its contents are:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#set-variable = interactive_timeout=240
#set-variable = wait_timeout=240
#set-variable = max_connections=150
bind-address = 127.0.0.1
skip-name-resolve
safe-show-database
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries = /var/log/mysql-slow.log
So I kept googling trying to find a solution. I found this bug report https;//bugzilla,redhat,com/bugzilla/show_bug.cgi?id=141062 (again sorry for the url) which pointed out an issue with the mysql_install_db script and SELinux. So, I did the following..
/usr/sbin/setenforce 0
/etc/init.d/mysql start
checking the error log gave this
> tail /var/log/mysqld.log
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050228 1:37:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
050228 1:37:15 InnoDB: Flushing modified pages from the buffer pool...
050228 1:37:15 InnoDB: Started; log sequence number 0 43634
050228 1:37:16 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050228 01:37:16 mysqld ended
Now I thought running the mysql_install_db script here might be helpful, so I did. It told me the usual stuff.. in particular that I could start the server with cd / ; /usr/bin/mysqld_safe & which resulted in
[1] 5029
root@LONIN:/ > Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050228 01:41:04 mysqld ended
[1]+ Done /usr/bin/mysqld_safe
No luck at all it seems.
I must be missing something here. Apparently it is possible to install MySQL 4.1 on FC3, as I have come across people who seemingly have done so. But I have also found dozens of people who are having
exactly the same issues as myself - getting a ERROR 2002 and a referral to the missing mysql.sock.
The mysql_install_db script does make the files in /var/lib/mysql/mysql. Attempting to start the MySQL server results in this log entry:
InnoDB: buffer...
050228 1:41:35 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050228 1:41:35 InnoDB: Flushing modified pages from the buffer pool...
050228 1:41:35 InnoDB: Started; log sequence number 0 43634
050228 1:41:35 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
050228 1:41:35 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
050228 01:41:35 mysqld ended
which its seems is the same problem referrred to the bug report mentioned above. There is a patch but that only applies to MySQL 3.23... It seems I am buggered. Needless to say I would love to know how those people actually managed to get 4.1 running on FC3. I find SElinux most baffling, and completely frustrating and have not a clue how to fix MySQL in this context. I will continue googling and reading in the hope of finding some more information and post any successes I might discover. If anyone has any further insight into this issue a post into this thread would be much appreciated..
Thanks again acid_kewpie. If others have a similar problem little relief can be found in the MySQL forums outside of the many people registering the same dilemna. FC3 is a whole version behind in their release of MySQL, unfortunatley I am in a position that requires a more up-to-date version. But, as the aforementioned bug report indicates even 3.23 is best with problems in Fedore Core 3. My fingers remain crossed that I will find a solution soon.