Issue
I installed wamp.phpmyadmin working fine. Now that I have installed mysql command line client I am not able to connect to my databases from mysql command line or phpmyadmin. After restarting I could not access phpmyadmin #1045 Cannot log in to the MySQL server
. In addition to that my mysql command line not accepting my password and rejects my config files:
C:\wamp\bin\mysql\mysql5.5.24
my.ini
port=3306
my config.inc.php
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'whtevr';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
httpd.conf
listen port:80
C:\Program Files\MySQL\MySQL Server 5.0
my.ini
port:3306
Again, I reinstalled mysql command line with port changed to 3307
port:3307
WAMP works fine accessing all the databases but from mysql command line client I could not access all my databases. It is only showing show databases;
information_schema
mysql
test
Solution
In case MySQL Server is up but you are still getting the error:
For anyone who still have this issue, I followed awesome tutorial http://coolestguidesontheplanet.com/get-apache-mysql-php-phpmyadmin-working-osx-10-9-mavericks/
However i still got #1045 error.
What really did the trick was to change localhost
to 127.0.0.1
at your config.inc.php
. Why was it failing if locahost points to 127.0.0.1? I don't know. But it worked.
===== EDIT =====
Long story short, it is because of permissions in mysql. It may be set to accept connections from 127.0.0.1 but not from localhost.
The actual answer for why this isn't responding is here: https://serverfault.com/a/297310
Answered By - JGutierrezC
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.