This is how the SQLd (MySQL) service should be configured on band site hosting servers.

See also: Creating a Band Site Hosting Server

# yum install mysql-server mysql-devel


Server configurations

# vi /etc/my.cnf


under [mysqld]

skip-networking
slow_query_log
long_query_time=10


# /etc/init/mysqld restart


Configure the root acct

# mysqladmin -u root password 'tech password'


Create default DB and user

$ mysql -u root -p
> CREATE DATABASE bandsX_bombplates;
> GRANT ALL ON bandsX_bombplates.* TO 'bandsX_bomb'@'localhost' IDENTIFIED BY 'password';

Remember this username and password. You'll need them later. Important! The password must be alphanumerics only!

Enable the daemon