[MacPorts] #46104: Install MySQL 5.5 in OS X 10.10 Yosemitet - It's works!

[MacPorts]

#46104: Install MySQL 5.5 in OS X 10.10 Yosemitet - It's works!
----------------------+--------------------------------
 Reporter:  ebanis@…  |      Owner:  macports-tickets@…
     Type:  update    |     Status:  new
 Priority:  Normal    |  Milestone:
Component:  ports     |    Version:  2.3.3
 Keywords:  mysql55   |       Port:  mysql55-server
----------------------+--------------------------------
 1)
 $ sudo port install mysql55-server

 2)
 $ sudo port select mysql mysql55

 or (better)

 $ export PATH=$PATH:/opt/local/lib/mysql55/bin

 3)
 $ sudo -u mysql mysql_install_db
 $ sudo chown -R mysql:mysql /opt/local/var/db/mysql55/
 $ sudo chown -R mysql:mysql /opt/local/var/run/mysql55/
 $ sudo chown -R mysql:mysql /opt/local/var/log/mysql55/

 4)
 $ sudo port load mysql55-server

 (test)
 $ ps -ax | grep mysql

 5)
 $ mysqladmin -u root -p password 'your-pass'
 When "Enter password:" - Enter

 6)
 $ mysql -u root -p
 After enter password

 (test)

 mysql> exit;

 7)
 Update /opt/local/etc/mysql55/my.cnf (you can copy default from
 /opt/local/share/mysql55/support-files/my-large.cnf)
 If you used "skip-locking", rename - "skip-external-locking".

 Restart:
 $ sudo port unload mysql55-server
 $ sudo port load mysql55-server

 8)
 /opt/local/etc/php53/php.ini (php53 - for example)
 pdo_mysql.default_socket = /opt/local/var/run/mysql55/
 mysqld.sockmysql.default_socket = /opt/local/var/run/mysql55/
 mysqld.sockmysqli.default_socket = /opt/local/var/run/mysql55/mysqld.sock

 Restart Apache:
 sudo /opt/local/apache2/bin/apachectl -k restart

-- 
Ticket URL: <https://trac.macports.org/ticket/46104>
MacPorts <https://www.macports.org/>
Ports system for OS X