Hello:
I re-installed MySql RPM and now cannot access MySql. The details...
I have RedHat 7.1 installed and am running Apache 1.3.14, MySql 3.23.26 and
PHP 4.04, all from the RedHat 7.1 installation. They have been running for a
month in a stable environment with any problems. I have used all 3 apps
extensively. Other related utilities installed and working:
MySQLGUI 1.7.5
phpMyAdmin 2.2.0
webmin 0.87 (RH 7.1)
A few days ago and while trying to change the root password for MySql, I did
something wrong and could not access MySql. I reviewed the MySQL docs and
The bitbybit.dk MySQL FAQ regarding my problems.
So using RPM, I uninstalled the 4 MySql database apps (mysql, mysql-devel,
mysql-server and mysqlclient9). I removed the Mysql log file and the Mysql
database directory, then re-booted. I then installed the 4 packages using
RPM and re-booted. No problems reported. All defaults locations are used.
In the boot log, this is the error whenever I boot and mysqld is run...
==================
010722 15:59:11 mysqld started
010722 15:59:13 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010722 15:59:13 mysqld ended
And whenever I try to access Mysql, I get this error message...
==================
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
The mysql.sock file appears only after mysqld is run. I have sysreports from
before and after.
I could fix this my doing a RedHat 7.1 Installation, but hopefully there
will be a quicker way, and it will be good for me to learn how to solve this
one.
Your help in solving this problem is greatly appreciated as I am "dead in
the water" without MySql.
Thanks very much. Regards,
Rob Valliere
[EMAIL PROTECTED]
PS - here is the mysqlbug report...
===================
Release: mysql-3.23.36 (Source distribution)
Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux solo 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jun 30 05:42 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 Apr 7 04:58 /lib/libc-2.2.2.so
Configure command: ./configure
i386-redhat-linux --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline --enable-shared
--with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-berkeley-db
