# Install the base database
/usr/local/bin/mysql_install_db

# Set permissions to correct owner
chown -R mysql:mysql /var/db/mysql

# Start the server
cd /usr/local ; /usr/local/bin/mysqld_safe &

# Perform basic checks
/usr/local/bin/mysqladmin version
/usr/local/bin/mysqladmin variables

# Set a Password!
/usr/local/bin/mysqladmin -u root password mysqlpassword

# Secure a production server
/usr/local/bin/mysql_secure_installation

# Add a "mysql" user with password and grant that user permission to connect
/usr/local/bin/mysql --user=root --password=mysqlpassword mysql
GRANT ALL PRIVILEGES ON *.* TO mysql@localhost IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO mysql@"%" IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

# Add a "mysqltop" user with no password and no ability to make changes and only usable via localhost for the "mtop" CLI tool
/usr/local/bin/mysql --user=root --password=mysqlpassword mysql
grant super, reload, process on *.* to mysqltop;
grant super, reload, process on *.* to mysqltop@localhost;
flush privileges;
exit

# (Optional) Add some compatibility for Linux applications by creating a symbolic links
ln -sv /usr/local/bin/mysqladmin /usr/bin/mysqladmin
ln -sv /usr/local/bin/mysqldump /usr/bin/mysqldump