CentOS 6.x on VMware Player: Part 4

Note these documents are subject to update, this one was last edited 04/26/2014

Part 4: Configuring MySQL

  • First we will make some basic configuration changes to MySQL. Later we will get into much more database configuration and tuning.
  • # cp -a /etc/my.cnf /etc/my.cnf.orig
  • # vi /etc/my.cnf
  • After the line user=mysql insert default-storage-engine=InnoDB
  • Save and exit.
  • # chkconfig –level 2345 mysqld on
  • # service mysqld start
  • # /usr/bin/mysql_secure_installation
  • Enter current password for root (enter for none): <enter>
  • Set root password? [Y/n] <enter> and set it
  • Remove anonymous users? [Y/n]  <enter>
  • Disallow root login remotely? [Y/n] n <enter>
  • Remove test database and access to it? [Y/n] <enter>
  • Reload privilege tables now? [Y/n] <enter>
  • # mysql -uroot -pyourpassword
  • mysql> use mysql
  • mysql> grant all on *.* to you@’192.168.1.4′ identified by ‘yourpassword’;
  • mysql> flush privileges;
  • mysql> exit
  • Now you will be able to install and use MySQL Workbench from your workstation or server.
  • # yum install -y flash-plugin.x86_64
  • Start Firefox and browse to http://www.mysql.com/products/workbench
  • Login or create an account if you need to.
  • Select Download Now.
  • Select Platform… Red Hat Enterprise Linux / Oracle Linux.
  • Download the 64-bit version.
  • Open with Package Installer (default) and Select OK.
  • Choose Install including for any additional packages it wants to install and authenticate.
  • When done installing fire it up and check Server Status.
  • # mysql-workbench

centos6.06

  • OK Configuring MySQL is done for now but I do expect to update this substantially over time so be sure and check back. There are also still important configurations and setting up Apache, etc. and later WordPress so please continue to Part 5.

If you have any questions or suggestions don’t hesitate to reach out to me!

Next: Part 5 – Configuring Apache