Can't login to phpmyadmin on my Mac running Yosemite
I am running Yosemite 10.10.1 I am running the latest mysql 5.6.22. It works in system prefixes. I can access the database using mysql workbench. I set a root password and I can type: mysql -u root -p and it works. I am running the latest Apache. I am running MacOSX Server 4 I have setup phpmyadmin, a remote sample config file.
Here is my phpmyadmin config file.
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypassword';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
But I cannot login to phpmyadmin. I go to localhost / phpmyadmin or 127.0.0.1/phpmyadmin and I get a login window. When I login to root and my password, I get an error: Can't login to MySQL server
It drives me crazy!!!
The mysql root password works!
thank
source to share
I am late to the party, but I solved the exact same error by using these commands in the terminal:
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
The socket was in the "wrong" location, which effectively tells the system where it is located. Hope this helps anyone in the future!
source to share
download a fresh copy of PHPMyAdmin and copy it to the root document named phpmyadmin and from the terminal create directory, for example
mkdir ~/Sites/phpmyadmin/config
change resolution
chmod o+w ~/Sites/phpmyadmin/config
And install phpmyadmin from
http://localhost/phpmyadmin/setup/
source to share