Geek Answers Handbook

Can I try phpMyAdmin on a local network using webmatrix?

I want to try phpMyAdmin to run it locally from webmatrix ... It regularly shows the login page, but I have problems logging in. Each attempt allows me to get # 2002 Impossibile for logging into MySQL server

After downloading the latest version of phpMyAdmin, I created the config.inc.php file recommended in the official guide. I tried to execute many parameters without success. The actual file configuration is as follows:

<?php /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = 'localhost'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'HTTP'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'pass'; $cfg['Servers'][$i]['AllowNoPassword'] = true; /* End of servers configuration */ $cfg['DefaultLang'] = 'en-utf-8'; $cfg['ServerDefault'] = 1; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>

Where am I mistaken?

+6
source share
1 answer

I followed two solutions to your problem, try choosing the one that works.

Solution: 1

You set the password for MySQL as pass, but you set the TRUE flag in this parameter. $cfg['Servers'][$i]['AllowNoPassword'] = true;

Try setting the flag to false , like this

 $cfg['Servers'][$i]['AllowNoPassword'] = false;

Solution: 2

Since you are logging in as the root user for MySQL, you need to change the above configuration parameter to

 $cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;
+2
source

More articles:


All Articles