XGrid Setting Up MySql

From CSclasswiki
Jump to: navigation, search

Steps to install a MySql server

--Thiebaut 16:35, 13 October 2008 (UTC)

  • Download package from dev.mysql.com
  • install MySQL-5.0.67-osx10.5-x86.pkg
  • install MySQLStartupitem.pkg to make MySQL start automatically when you reboot
  • reboot
  • open a Terminal window and connect to the MySQL server as shown below (good information on these steps can be found here):

$ mysql -u root
mysql> set password for 'root'@'localhost' = PASSWORD( 'xxxxxxxxx' );
mysql> drop user ' '; 
mysql> grant all privileges on *.* to 'root'@'%' identified by 'xxxxxxx' with grant option;

(For the "drop user" command above, it is followed by 2 quotes without a space in between. I had to put a space to make the quotes show :-)

  • Open System Preferences, Security, Firewall, and allow all incoming traffic (I couldn't find a way to open Port 3306 used by mysql in the firewall list...)
  • On another machine, use your favorite GUI (mine is SQLYog) to access your Mac and test your connection. It should work!