computing.admin@STARTCO.CA wrote:
To start MySQL in RedHat 8.0, enter the following as root:
chkconfig --level 35 mysqld on (this will restart it on a reboot)
/etc/rc.d/init.d/mysqld start (this will start it now)
Note, however, that the reason it may not be starting for you is because it
defaults to use the new innodb database table format and you must first
change your configuration to handle that. If you are trying to get it to use
the old MyASM type tables then you must edit /etc/my.cnf to include the
following:
##########################
# Force to use old-style tables as suggested by /var/log/mysqld.log as
follows:
## Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
## If you do not want to use transactional InnoDB tables, add a line
## skip-innodb
## to the [mysqld] section of init parameters in your my.cnf
## or my.ini. If you want to use InnoDB tables, add to the [mysqld]
## section, for example,
## innodb_data_file_path = ibdata1:10M:autoextend
## But to get good performance you should adjust for your hardware
## the InnoDB startup options listed in section 2 at
## http://www.innodb.com/ibman.html
skip-innodb
##########################
Also note that the version that comes with RedHat 8.0 has a bug which cause
mysqld to restart if a database request is received from a remote computer
that is not listed in /etc/hosts. To fix this you can install the latest
MySQL 3.23.54a release from http://www.mysql.com but the installation is not
trivial. I just fought my way through it.
-----------
Thanks a lot for this useful info.
JD
--
Psyche-list mailing list
Psyche-list@redhat.com
https://listman.redhat.com/mailman/listinfo/psyche-list
