timriley (owner)

Revisions

  • 8767c1 Sat Aug 29 00:41:47 -0700 2009
gist: 177424 Download_button fork
public
Public Clone URL: git://gist.github.com/177424.git
Embed All Files: show embed
mysql snow leopard install.txt #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
sudo port install ruby
sudo port install rb-rubygems
 
sudo port install mysql5-server
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
sudo -u mysql mysql_install_db5
/opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin -u root -h yomi.local password 'new-password'
cd /opt/local/bin && sudo ln -s mysql5 mysql
 
mysql -u root -p mysql
select Host,User,Password from User;
update User set password=PASSWORD('password-here') where User='root';
delete from User where User='';
CREATE USER 'tim'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'tim'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
 
sudo gem install mysql -- --with-mysql-include=/opt/local/include/mysql5 --with-mysql-lib=/opt/local/lib/mysql5 --with-mysql-config=/opt/local/lib/mysql5/bin/mysql_config