I have tried Sinisa's suggestions to the following problem, nothing has
worked so far:
I have been using MySQL versions 3.22.X for the past 8 months. I just
installed 3.23.5-alpha on Red Hat Linux. The MySQL server starts if I use
./configure or safe_mysqld & but not if I use ./mysql.server start. I have
installed the databases using scrips/mysql_install_db
I installed the binary in /usr/local/scr/mysql-3.23.5-alpha-pc-linux-gnu-i686
I created a symbolic link:
ln -s /usr/local/scr/mysql-3.23.5-alpha-pc-linux-gnu-i686 /usr/local/mysql
The .err file reports:
mysqld started on Sun Dec 26 10:56:38 EST 1999
Can't change to run as user 'cr-jay.com' ; Please check that the user exists!
991226 10:56:38 Aborting
mysqld ended on Sun Dec 26 10:56:38 EST 1999
My hosts file:
127.0.0.1 localhost localhost.localdomain
150.100.100.7 cr-jay.com cr-jay
150.100.100.10 cjmobile
150.100.100.09 crjnt2
My /etc/my.cnf file:
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
# Start logging
log
[mysql.server]
user=root
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
I have checked in the mysql.server file and it sets the mysql_daemon_user
to root.
Thanks for any help.
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped