Sorry to ask a FAQ, but I am having trouble getting the mysql daemon
to start at boot in Redhat Linux 6.2 with mysql-3.23.33.
I have read the manual and the limited amount that is now available on
Deja News.
Everything about the setup seems to work fine and have no trouble
starting mysql manually with
> /usr/local/mysql/bin/safe_mysqld --user=mysql&
All the tests I have run on the database appear to work fine when it
is started manually.
Here are the relevant (I think) init files on my system, that were
created during the install/config described in gory detail below:
[root@c715466-a rc3.d]# ls -lF /etc/rc.d/init.d/mysql.server
-rwxr-xr-x 1 root root 4040 Feb 18 14:18 /etc/rc.d/init.d/mysql.server*
[root@c715466-a rc3.d]# ls -lF /etc/rc.d/rc3.d/S99mysql
lrwxrwxrwx 1 root root 29 Feb 18 14:19 /etc/rc.d/rc3.d/S99mysql ->
/etc/rc.d/init.d/mysql.server*
Is there some other incantation I need to make to get this to start
properly at boot? I enter runlevel 5 by default at boot.
Thanks,
John Hunter
Here is the exact sequence I did at install and configure:
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
cd /usr/local/src
tar xvfz ~jdhunter/src/mysql-3.23.33.tar.gz
cd mysql-3.23.33/
configure --prefix=/usr/local/mysql
make
make install
scripts/mysql_install_db
chown -R mysql.mysql /usr/local/mysql/
/usr/local/mysql/bin/safe_mysqld --user=mysql&
/usr/local/mysql/bin/mysqladmin -u root password thepass1
/usr/local/mysql/bin/mysql -u root -p mysql #this test worked fine
cp support-files/mysql.server /etc/rc.d/init.d/
ln -s /etc/rc.d/init.d/mysql.server /etc/rc.d/rc3.d/S99mysql
chmod 755 /etc/rc.d/init.d/mysql.server
cp support-files/my-medium.cnf support-files/my.cnf
emacs -q -nw support-files/my.cnf #added 'user = mysql'
cp support-files/my.cnf /etc/
Created a test database and user permissions:
/usr/local/mysql/bin/mysql -u root -p mysql
mysql> GRANT SELECT,INSERT,DELETE,UPDATE ON users.* TO
jdhunter@"c715466-a.chmpgn1.il.home.com" IDENTIFIED BY 'thepass';
mysql> create database users;
Query OK, 1 row affected (0.02 sec)
mysql> CREATE TABLE passwd (
username varchar(8) not null,
crypt varchar(128) not null,
realname varchar(64) not null,
shell varchar(20) not null
);
mysql> quit;
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
