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...)
 
 
(One intermediate revision by the same user not shown)
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
*Note: I used macport to update mysql. After the update, the org.macports.mysql5.plist is missing. Therefore, mysql needs to be manually started for now.
    sudo /opt/local/bin/mysqld_safe5 &

Latest revision as of 01:56, 8 January 2013

Migration log[edit]

  • 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
  • Note: I used macport to update mysql. After the update, the org.macports.mysql5.plist is missing. Therefore, mysql needs to be manually started for now.
   sudo /opt/local/bin/mysqld_safe5 &