Setting up MySQL on FC6

From Shrubbery

# yum install mysql mysql-server

Then, start the server for the first time:

# service mysqld start

This will tell you to set the root password, so let's do that:

# mysqladmin -u root password 'new-password'

Then, we can create a new database and add a user that can access it. In this example we create 'somedb' which can be accessed by user 'sa' password 'sa':

# mysqladmin create somedb -p
# mysql mysql -p
mysql> grant all privileges on somedb.* to 'sa'@'localhost' identified by 'sa'