Setup MySQL on Fedora 15

yum install mysql-server

Start MySQL server and autostart on boot:

/etc/init.d/mysqld start  ## use restart after update
##OR##
service mysqld start ## use restart after update
chkconfig --levels 235 mysqld on

Create root:

/usr/bin/mysqladmin -u root password rootpassword
/usr/bin/mysqladmin -u root -h www.server.world password rootpassword

Conect to MySQL:

mysql -u -root -p
## or ##
mysql -h localhost -u root -p

Create a new user:

mysql -u root -p
CREATE USER newusername;
SET PASSWORD FOR newusername=PASSWORD("password");
GRANT ALL PRIVILEGES ON *.* TO newusername IDENTIFIED BY 'password';
or
GRANT SELECT, INSERT, UPDATE DELETE, CREATE, DROP,
     REFERENCES, EXECUTE ALTER on databasename.* TO newusername;

MySQL Secure Installation

/usr/bin/mysql_secure_installation

Download and install JDBC (connector/J) driver.