MySQL setup without "mysql.server" in CentOS5

Ericxx · 07-14-2010, 10:00 AM

Hello all,

I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not. Please suggest. Thanks.

Regards,
Eric

anomie · 07-14-2010, 10:04 AM

How did you install MySQL? (By selecting it during CentOS install time? Using yum, from the CentOS repositories? Or something else?)

Should be as simple as:

Code:

# chkconfig mysqld on

Ericxx · 07-14-2010, 11:21 PM

Thanks, anomie. Now can autostart the MySQL everytime reboot the server.

I installed MySQL during the CentOS installation without using yum. And here is the output:
#rpm -qa centos-release mysql\* | sort
centos-release-5-5.el5.centos
mysql-5.0.77-4.el5_5.3
mysql-server-5.0.77-4.el5_5.3

Regards,
Eric

Ericxx · 07-16-2010, 02:51 AM

Figured this out.

Below is the statement from MySQL doc:

If you use the Linux server RPM package (MySQL-server-VERSION.rpm), the mysql.server script is installed in the /etc/init.d directory with the name mysql. You need not install it manually. Some vendors provide RPM packages that install a startup script under a different name such as mysqld.

So i believe this is my case.

Regards,
Eric