Thanks a lot for the insight. Working on it again now. Added the MySQL version as you added:
sudo cp -r /opt/local/var/db/mysql5 /opt/local/var/db/mysql55 sudo chown -R _mysql:_mysql /opt/local/var/db/mysql55 sudo port install mysql55 +openssl mysql55-server sudo port select mysql mysql55 Got this error: ---> Cleaning mysql55 Error: Port mysql55-serve not found Then I decided to upgrade all first and see. It upgraded PHPMyadmin as well. ---> Activating phpmyadmin @4.2.7.1_0+php5 Still had the error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2) Then I followed your writings a little further: sudo /opt/local/lib/mysql55/bin/mysqld_safe & [1] 19249 jaspersmbp:php5 jasper$ cd /opt/local/lib/mysql55 [1]+ Stopped sudo /opt/local/lib/mysql55/bin/mysqld_safe (wd: /opt/local/etc/php5) (wd now: /opt/local/lib/mysql55) jaspersmbp:mysql55 jasper$ sudo mysqladmin -u root -p password Password: Sorry, try again. Password: Sorry, try again. Password: Sorry, try again. sudo: 3 incorrect password attempts The password I know does not seem to be the password it needs. Perhaps there is a new standard password added now. Not sure yet. On Thu, Aug 21, 2014 at 8:59 PM, Bill Christensen < [email protected]> wrote: > By the way, the reason I'm reading the MacPorts list today is to report > a problem I just discovered with the latest ImageMagick upgrade. On my > WordPress sites, uploading an image fails. I reverted to ImageMagick > @6.8.9-1_0+x11 and all is well. > > Just in case you run into similar. > > On 8/21/14 11:04 AM, Jasper Frumau wrote: > > OK. Selected MySQL55 and server, then unloaded MYSQL 5 so I did not have > to running and now I have > > mysql5 -u root -p > > Enter password: > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/opt/local/var/run/mysql5/mysqld.sock' (2) > > and I think that is because the socket path is not correct. Not sure yet > how to adjust... > > > On Thu, Aug 21, 2014 at 6:44 PM, Jasper Frumau <[email protected]> > wrote: > >> Reloading the page / phpmyadmin on Firefox I saw "You should upgrade to >> MySQL 5.5.0 or later." So I >> >> The mysql55 client has been installed. >> >> To install the mysql55 server, install the mysql55-server port. >> >> ---> Activating mysql55 @5.5.38_0 >> >> >> On activation if no /opt/local/etc/mysql55/my.cnf file exists one >> >> will be created which loads >> >> /opt/local/etc/mysql55/macports-default.cnf. >> >> >> If a /opt/local/etc/mysql55/my.cnf file exists MacPorts does not >> >> touch it and any changes you make to /opt/local/etc/mysql55/my.cnf >> >> will be preserved (e.g., during port upgrades, deactivations or >> >> activations). /opt/local/etc/mysql55/my.cnf is a good place to >> >> customize your mysql55 installation. >> >> >> Any changes made to /opt/local/etc/mysql55/macports-default.cnf >> >> will be lost during port upgrades, deactivations or activations so you >> >> are advised to not make changes here. Currently >> >> /opt/local/etc/mysql55/macports-default.cnf contains only one >> >> directive; to disable networking. With disabled networking it is >> >> possible to install and have running all the MacPorts mysql ports >> >> simultaneously. >> >> >> ---> Cleaning mysql55 >> >> ---> Updating database of binaries >> >> ---> Scanning binaries for linking errors >> >> ---> No broken files found. >> >> jaspersmbp:phpmyadmin jasper$ sudo port install php55-xdebug php55-sqlite >> php55-pear php55-openssl php55-mysql php55-memcached php55-mcrypt >> php55-mbstring php55-imagick php55-iconv php55-gd php55-curl >> >> But I still have the same error. I do not think I need to install the >> mysql server do I? Well I did it anyways, but still #2002 Cannot log in >> to the MySQL server >> >> >> >> >> >> On Thu, Aug 21, 2014 at 5:25 PM, Jasper Frumau <[email protected]> >> wrote: >> >>> I have had a Macports LAMP running for a year now or so and just >>> upgraded to php 5.5. port to do some more development on my MBP. So I added >>> the openssl port as well as the necessary php55 ports (got some help from >>> http://blog.kicaj.com/installing-and-configuring-php-5-5-using-macports/ >>> ) : >>> >>> 7541 sudo port install php55 >>> >>> 7547 sudo port select php php55 >>> >>> 7557 port search php | grep apache >>> >>> 7571 sudo port install php55-apache2handler >>> >>> 7592 sudo port install php5-openssl >>> >>> 7593 sudo port install php55-openssl >>> >>> 7605 sudo port search mbstring >>> >>> 7606 sudo port install php55-mbstring >>> >>> 7608 sudo port install php55-mysqli >>> >>> 7609 sudo port search mysqli >>> >>> 7610 sudo port install php55-mysql >>> >>> PHP 5.5. is running: >>> >>> php --version >>> >>> PHP 5.5.15 (cli) (built: Jul 25 2014 13:17:32) >>> >>> Copyright (c) 1997-2014 The PHP Group >>> Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies >>> >>> And I checked the ini from localhost and all good. >>> MySQL is OK and is still running: >>> >>> >>> mysql5 -u root -p >>> >>> Enter password: >>> >>> Welcome to the MySQL monitor. Commands end with ; or \g. >>> >>> Your MySQL connection id is 348 >>> >>> Server version: 5.1.72-log Source distribution >>> >>> >>> But in phpmyadmin I now get this error: >>> >>> #2002 Cannot log in to the MySQL server >>> >>> I browsed some forums and tried a few rings like adding the path to >>> the mysql socket in the php 55 init, but I still cannot get phpmyadmin to >>> work again. >>> >>> Any ideas? >>> >>> -- >>> *Jasper* >>> >> >> >> >> -- >> *Jasper Frumau @ Imagewize Ltd* web design | web development | branding >> w: imagewize. <http://www.imagewize.net/>com email: jasper@imagewize. >> <[email protected]>com t: +66806044547 skype: frumau >> > > > > -- > *Jasper Frumau @ Imagewize Ltd* web design | web development | branding > w: imagewize. <http://www.imagewize.net/>com email: jasper@imagewize. > <[email protected]>com t: +66806044547 skype: frumau > > > _______________________________________________ > macports-users mailing > [email protected]https://lists.macosforge.org/mailman/listinfo/macports-users > > > -- *Jasper Frumau @ Imagewize Ltd* web design | web development | branding w: imagewize. <http://www.imagewize.net/>com email: jasper@imagewize. <[email protected]>com t: +66806044547 skype: frumau
_______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
