PHP55 Upgrade , PHPMyAdmin No Longer Works
Jasper Frumau
jasperfrumau at gmail.com
Thu Aug 21 23:41:16 PDT 2014
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 <
billc_lists at greenbuilder.com> 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 <jasperfrumau at gmail.com>
> 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 <jasperfrumau at gmail.com>
>> 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 at imagewize.
>> <jasper at imagewize.net>com t: +66806044547 skype: frumau
>>
>
>
>
> --
> *Jasper Frumau @ Imagewize Ltd* web design | web development | branding
> w: imagewize. <http://www.imagewize.net/>com email: jasper at imagewize.
> <jasper at imagewize.net>com t: +66806044547 skype: frumau
>
>
> _______________________________________________
> macports-users mailing listmacports-users at lists.macosforge.orghttps://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 at imagewize.
<jasper at imagewize.net>com t: +66806044547 skype: frumau
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/macports-users/attachments/20140822/ca9bc2df/attachment.html>
More information about the macports-users
mailing list