Email  Print  Favorites | More

Setting Up MySQL

MySQL should have been installed when you selected the packages. Now you just need to start it and make it start automatically everytime the computer starts. To do so:

#chkconfig --levels 235 mysqld on
#/etc/rc.d/init.d/mysqld start

Now check that networking is enabled. Run:

#netstat -tap

You should see a line like this:

tcp 0 0 *:mysql *:* LISTEN 2721/mysqld

If it does not, edit /etc/my.cnf and comment out the option skip-networking:

#skip-networking

Now, assing a password for the root user in MySQL, and replace the user root with the user mysql. I'm using the password mythtv.

#mysqladmin -h localhost -u root password mythtv
# mysql -uroot -pmythtv mysql
mysql> UPDATE user SET user='mythtv' WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit