XGrid Setting Up MySql

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!