BusyBee Debian

Configuring MySQL

It seems that the Debian distribution that I have does not include mysql. Only postgres is included. I wonder why this is so. Maybe postgres is more stable? Anyways, it seems that the installation is straight forward. All I have to do is do an

apt-get mysql-server

. After downloading from the source, Debian Configuration screens pops up and told that mysql will not be installed if the hostname is non-numeric. So I guess I have to check this first. I quickly checked by doing a

hostname

and did a

cat /etc/hosts

Seems to be ok, I have furt (my box) to point to 192.168.1.202. Now lets go through the rest of the configuration.

Debconf will also create a debian-sys-maint user apparently and this is the bugger who will start and stop the cron scripts.

Note to self: Set MySQL password. (where is this set I wonder)

Debian also mentioned that if use the

.my.cnf 

file then i will have to put both the user and password line there. Wonder what goes in the

.my.conf

file. Anyway more documentation can be found at the normal debian documentation path

/usr/share/doc/mysql-server/README.Debian

Also Debian seems to put mysql database files in

/var/lib/mysql

and I chose not to delete the database files if the mysql-server package gets deleted. I also allowed mysql to start at boot.

I went around after that to take a look at the place to put the password. I recalled doing this some time ago but now I've forgotten where it should go. Anyway, I just edited the my.cnf at

/etc/mysql

and change and uncommented the password line.

Posted by zoo at February 16, 2003 05:51 PM