Quick install/config guide:

1. Install rpms

   • http://dev.mysql.com/downloads/repo/yum/

   • Older versions available in distros

2. run mysql_install_db

3. Lock root user by running one of the following:

   /usr/bin/mysqladmin -u root password 'new-password'
   /usr/bin/mysqladmin -u root -h nap password 'new-password'
   
   /usr/bin/mysql_secure_installation ## more than just pwd
   

4. Check my.cnf files for content:

   • /usr/my.cnf

   • /etc/my.cnf

5. Update ownership/permissions: chown -R mysql:mysql /var/lib/mysql

6. Create non-root/admin users

   • Create admin user:

     create user dkoleary identified by '${pwd}';;
     grant all privileges on *.* to 'dkoleary'@'%' with grant option;
     grant all privileges on *.* to 'dkoleary'@'localhost'
     with grant option;
     set password for '${user}'@'%' = password('${pwd}');
     set password for '${user}'@'localhost' = password('${pwd}');
     

   • Create application user as needed:

     create user 'cmdb'@'localhost' identified by 'nuther_pwd';
     grant select, insert, update, delete, create, drop
     on cmdb.*
     to 'cmdb'@'localhost';
     

7. Create and restore db:

   create database cmdb
   mysql -u dkoleary -p cmdb < ${backup_file}
   

8. kickstart post scipt: Assumes repo is aleady installed and/or available via spacewalk like environment.

   #!/bin/ksh
   
   echo ''
   echo "Removing OEM mysql rpms:"
   echo "------------------------"
   
   yum -y erase mysql php-mysql
   
   echo ''
   echo "Enabling mysql community channels:"
   echo "----------------------------------"
   
   for c in mysql56.x86_64 mysql_connectors.x86_64 mysql_tools.x86_64
   do
       rhn-channel -a -c ${c} -u admin -p Not_really_my_pwd
   done
   
   echo ''
   echo "Installing mysql community  gpg key:"
   echo "------------------------------------"
   rpm --import http://repo.mysql.com/RPM-GPG-KEY-mysql
   
   echo ''
   echo "Installing community mysql packages:"
   echo "------------------------------------"
   
   yum -y install mysql-workbench-community mysql-community-server \
       mysql-community-client php-mysql tinyxml libzip php phpmyadmin \
       mysql-utilities httpd firefox
   
   echo ''
   echo "Correcting permissions and configs:"
   echo "-----------------------------------"
   
   chown -R mysql:mysql /var/lib/mysql
   cd /etc/httpd/conf.d
   mkdir -m 700 RCS && echo phpMyAdmin.conf | ci -l phpMyAdmin.conf