vicidial.org

Hi All,

I chose to install mysql on centos 5.1 using yum install and im using the release 5.0.22 since im having a hardtime installing mysql following the scartchinstall.

Does anyone here tried installing mysql the same way i did?

I also noticed that putting this "### start up the MySQL server
/usr/local/mysql/bin/mysqld_safe --user=mysql --skip-name-resolve --skip-host-cache &" to rc.local, wont start mysql automatically so i did a chkconfig --level 345 mysqld on and it started automatically on boot.

How can i add this line "--skip-name-resolve --skip-host-cache &" since im using chkconfig to start mysql on boot?

Thanks in advance

Regards,

Jojo

You need to put those entries in /etc/my.cnf. Should look like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-name-resolve
skip-host-cache

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Since you're using CentOS as your distro, you can add Mysql to the bootup scripts by issuing this as root:

checkconfig --level 345 --add mysql

Hi Gardo,

Which of these two scripts would you prefer? Im using the last one and it seems to be ok.

checkconfig --level 345 --add mysql

or

checkconfig --level 345 mysqld on

Whats the difference between the two?

Regards,

Jojo

You can use both. The difference is explained by entering "man chkconfig" on the command prompt.

It's "chkconfig" and not "checkconfig" by the way.

Got it loud and clear

Thanks Gardo for your time.

Regards,

Jojo