Lab IT server migration: Difference between revisions

From ZhangLabWiki
Jump to navigation Jump to search
(New page: ==Migration log== *Use the Migration Assistant in the Mac OS X to copy files to the new Mac Pro. **Problem: don't know what the root password is, but can use sudo. *Enable Apache PHP Modu...)
 
Line 12: Line 12:
   port install mysql5 +server
   port install mysql5 +server
   launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
   launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
  ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock
   mkdir /var/mysql
   mkdir /var/mysql
   ln -s /opt/local/var/run/mysql5/mysqld.sock /var/mysql/mysql.sock
   ln -s /tmp/mysql.sock /var/mysql/mysql.sock
   launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
   launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
   /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
   /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Line 20: Line 19:
   mysql5 -u root
   mysql5 -u root
       UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';
       UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';
      FLUSH PRIVILEGES;
      UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'wikiuser';
       FLUSH PRIVILEGES;
       FLUSH PRIVILEGES;
       quit
       quit

Revision as of 00:11, 9 October 2008

Migration log

  • Use the Migration Assistant in the Mac OS X to copy files to the new Mac Pro.
    • Problem: don't know what the root password is, but can use sudo.
  • Enable Apache PHP Module:
  vi /etc/apache2/http.conf
  uncomment the line:
  # LocaModule php5_module
  • Turn on the Apache server
  • Install Xcode.
  • Install MacPort, the binary files are in /opt/local/bin
  • Install MySQL5
  port install mysql5 +server
  launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
  mkdir /var/mysql
  ln -s /tmp/mysql.sock /var/mysql/mysql.sock
  launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
  /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
  sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
  mysql5 -u root
     UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';
     FLUSH PRIVILEGES;
     UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'wikiuser';
     FLUSH PRIVILEGES;
     quit