<div dir="ltr">Reloading the page / phpmyadmin on Firefox I saw "You should upgrade to MySQL 5.5.0 or later." So I<div><br></div><div><p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
The mysql55 client has been installed.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">To install the mysql55 server, install the mysql55-server port.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">---> Activating mysql55 @5.5.38_0</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px"><br></p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">On activation if no /opt/local/etc/mysql55/my.cnf file exists one</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">will be created which loads</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">/opt/local/etc/mysql55/macports-default.cnf.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px"><br></p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">If a /opt/local/etc/mysql55/my.cnf file exists MacPorts does not</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">touch it and any changes you make to /opt/local/etc/mysql55/my.cnf</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">will be preserved (e.g., during port upgrades, deactivations or</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">activations). /opt/local/etc/mysql55/my.cnf is a good place to</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">customize your mysql55 installation.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px"><br></p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Any changes made to /opt/local/etc/mysql55/macports-default.cnf</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">will be lost during port upgrades, deactivations or activations so you</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">are advised to not make changes here. Currently</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">/opt/local/etc/mysql55/macports-default.cnf contains only one</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">directive; to disable networking. With disabled networking it is</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">possible to install and have running all the MacPorts mysql ports</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">simultaneously.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px"><br></p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">---> Cleaning mysql55</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">---> Updating database of binaries</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">---> Scanning binaries for linking errors </p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">---> No broken files found. </p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">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</p>
</div><div class="gmail_extra"><br></div><div class="gmail_extra">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 <span style="background-color:rgb(255,192,203);color:rgb(0,0,0);font-family:sans-serif;font-size:13px">#2002 Cannot log in to the MySQL server</span></div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 21, 2014 at 5:25 PM, Jasper Frumau <span dir="ltr"><<a href="mailto:jasperfrumau@gmail.com" target="_blank">jasperfrumau@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">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 <a href="http://blog.kicaj.com/installing-and-configuring-php-5-5-using-macports/" target="_blank">http://blog.kicaj.com/installing-and-configuring-php-5-5-using-macports/</a> ) :<div>
<br></div><div><p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">7541 sudo port install php55</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7547 sudo port select php php55</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7557 port search php | grep apache</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7571 sudo port install php55-apache2handler</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7592 sudo port install php5-openssl</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7593 sudo port install php55-openssl</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7605 sudo port search mbstring</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7606 sudo port install php55-mbstring</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7608 sudo port install php55-mysqli</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7609 sudo port search mysqli</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)"> 7610 sudo port install php55-mysql</p></div><div><br></div><div>PHP 5.5. is running:</div><div><br></div><p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">
php --version</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">PHP 5.5.15 (cli) (built: Jul 25 2014 13:17:32) </p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Copyright (c) 1997-2014 The PHP Group</p>
<div><span style="background-color:rgb(0,0,0);color:rgb(245,245,245);font-family:Monaco;font-size:10px">Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies</span></div><div><br></div><div>And I checked the ini from localhost and all good.</div>
<div>MySQL is OK and is still running:</div><div><br></div><div><br></div><div><p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">mysql5 -u root -p</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Enter password: </p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Welcome to the MySQL monitor. Commands end with ; or \g.</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Your MySQL connection id is 348</p>
<p style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)">Server version: 5.1.72-log Source distribution</p></div><div><br></div><div><br></div><div>But in phpmyadmin I now get this error:</div>
<div><br></div><div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;background-color:rgb(255,192,203)">#2002 Cannot log in to the MySQL server</span><br></div><div><div><br></div><div>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.</div>
<div><br></div><div>Any ideas?</div><span class=""><font color="#888888"><div><br></div>-- <br><div dir="ltr"><b style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px;color:rgb(0,0,0)">Jasper</b><br>
</div>
</font></span></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><b style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px;color:rgb(0,0,0)">Jasper Frumau @ Imagewize Ltd</b> <span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">web design | web development | branding</span><br style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">
<span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">w:</span> <a href="http://www.imagewize.net/" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px;color:rgb(0,0,0);text-decoration:none;border-bottom-width:1px;border-bottom-color:rgb(153,153,153);border-bottom-style:dotted" target="_blank">imagewize.</a><span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">com</span> <span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">email:</span> <a href="mailto:jasper@imagewize.net" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px;color:rgb(0,0,0);text-decoration:none;border-bottom-width:1px;border-bottom-color:rgb(153,153,153);border-bottom-style:dotted" target="_blank">jasper@imagewize.</a><span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">com</span> <span style="color:rgb(85,85,85);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:10px;line-height:14px">t: +66806044547 skype: frumau</span><br>
</div>
</div></div>