WampServer

Hello Riggs

been some time. How are you doing? Hope you are fine mate!!

All fine here, keeping myself busy with dev stuff.

So I changed the phpMyAdmin password for user root and now I am looking for the place to login.

/localhost/phpmyadmin/ obviously tells me Access Denied since I did not put in the password.

So when going to phpMyAdmin over localhost, where do I find the login form to put the password?

It is advisable even for local dev work to actually put a password?

Thank you.

Best Regards
Frank

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

OK, I changed the empty password field in file config.inc.php with path C:\wamp\apps\phpmyadmin4.1.14 and have access.


This helped:
[superuser.com]


However I wonder if there is a URL for a login form to phpMyAdmin as well?

Thank you Riggs.

Cheers
Frank

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

OK, I did set a password for some of the root users but somehow I am also at the same time creating new root users that I do not think I need.

Here is a shot of the current users.
[lh3.googleusercontent.com]

Can you tell me what users I MUST have and what users I can safely delete please?

For example can I delete the "ANY" user?

What is the "%" for Host?

What I think I need is 3 users.

root : localhost : all privs : grant yes
root : 120.0.0.1 : all privs : : grant yes
root : ::1 : all privs : : grant yes

Is this a correct assumption or does WP local dev for example need the "ANY" user?

Hang on, I see "ANY" user with grant no, so that means I have to tell phpMyAdmin that ONLY root user can login where all other users are shut out, correct?

So this means I DO indeed need two "ANY" users, one for host "localhost" with grant no and one for host "%" with grant no. So 5 users total, right?

Thank you.

Best Regards
Frank

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

Looks like you have made a bit of a mess here Frank.

You are correct you need to keep these 3 root accounts
root : localhost : all privs : grant yes
root : 120.0.0.1 : all privs : : grant yes
root : ::1 : all privs : : grant yes

Delete the rest. If you want to set a password on these, and thats agood idea, then amend thes 3 accounts dont make random new root accounts


You can delete Any also, I always do.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Ah, OK!

What happened is that I did all the password adding but phpMyAdmin did only show the real users once I reloaded the page. Once reloaded the 3 roots and 2 ANYs where there.

I though ANY is to keep out, well any body that is not root. If that is not the case, what is ANY for then?

Will go ahead and delete them.

Thank you Riggs!

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

Oh and is there a way to log in via URL in the browser or does one ALWAYS have to edit the file config.inc.php once a password for root has been set?

Something like /localhost/phpmyadmin/index.php or /localhost/phpmyadmin/login.php or /localhost/phpmyadmin/admin.php ?

Thank you.



Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

Frank,

Make these chnages to \wamp\apps\phpmyadmin\config.inc.php

/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

This will make phpMyAdmin throw a login screen, where you can use any Username/Password set that exists within your MySQL server.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Thank you heaps!!

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

You are welcome. However in the future you can work rhis stuff out for yourself if you only were to take a look at the manuals. Thats how I did it.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 08/02/2015 05:21PM by RiggsFolly.

In that case you mean the phpMyAdmin documentation I assume.

You can rest assured I am doing lots of reading and tuts and trying to get things right. Hopefully I will reach more confidence with this one day.

Thank you.

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

But just remember one thing if the tut is based on a unix system you can basically ignore anything they say about file and folder permissions. Its almost never an issue on Windows

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-