WampServer

what is the user & pass of phpmyadmin ?

کد تخفیف نت افراز , کد تخفیف نت افراز

Userid = root
Password = ( leave this blank )


Its the standard MySQL userid/password pair that comes with every new install of MySQL!

---------------------------------------------------------------------------------------------
(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-

Hy,
I have changed the password of Mysql privilege, but now the phpadmin not start.
Which file .ini have I to modify ?

Thanks

Please answer these questions [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(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-

In order to make it simpler to suggest answers to your problems:
Before asking a question please add the answer these questions to your first post.
Thank you.

Version of Operating system? ===> Win7 Pro Services Pack1
Version of Wamp Server installed? ===> WampServer 2.2
Version of Apache you are running? ===> apache2.4.2
Version of MySQL you are running? ===> mysql5.5.24
Version of PHP you are running? ===> php5.4.3

What colour is your WampManager icon? ( the in the system tray )
It could be Green, Orange or Red ===> Green

Do you have a HOSTS file? [c:\windows\system32\drivers\etc\hosts] ===> Yes. 127.0.0.1
Paste any entries relating to the domain localhost and also any relating to your Virtual Hosts if you have any.

Not quite sure with that version of phpMyAdmin, but look at this file

\wamp\apps\phpmyadmin3.4.10\config.inc.php


If it looks like this :-

$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'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Then change it to :-

$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'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';

---> make sure this is the userid you want to use.
$cfg['Servers'][$i]['user'] = 'root';

---> change these 2 lines that follow
$cfg['Servers'][$i]['password'] = 'ADD_NEW_PASSWORD_HERE';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Alternatively if you woudl like phpmyadmin to throw a Userid/password challenge dialog try changing it to this

$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'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['LogoutURL'] = 'http://localhost/';

and each time you access phpmyadmin it will ask for a username and password via a dialog box.

---------------------------------------------------------------------------------------------
(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-

Thanks Riggs,

I used the dialog box config.

But now, every time I log in phpadmin, I'm not asking for the password.

If I develop an application, I will be forever bound to this user or this is only for the phpdamin?

Thanks for the support

Each login will be be cached for a few minutes so a second attempt will possibly not throw the challenge. Refresh the browser cache ( CTRL+F5) should get a uid/pwd challenge back.

The user/pass you use with phpmyadmin is normally a SuperUser account, so you never have issues with privilages to do anything.

However there is no reason why Using phpmyadmin you cannot create hundereds of other Userid/password sets ( one for each of your sites for example ). You can then login to phpmyadmin using those other accounts to test they work etc and check their privilages allow them to access whatever they should be allowed to access and NOT what they shouldn't.

You should also consider giving each of these site specific users, access to only the database they are used for.

In short you probably need to do a little reading up on how MySQL works, and also on how phpMyAdmin works.


By the way its not the only tool for creating/maintaining databases, but it is the one you are MOST LIKELY to find on hosted sites, so you should get used to using it before you try and migrate a test site to a hosted live site.

I personally prefer MySQL Workbench CE, but like I say you are going to find phpmyadmin on hosted sites.

---------------------------------------------------------------------------------------------
(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-

Riggs, thanks for the advice.

I am an expert on old IBM databases (DB2 to be precise) and then I have a bit of knowledge about the DB in general.

I also have a bit of experience in structured programming languages ​​(COBOL) and on the web site in general, and now I'm playing to deal with PHP.

Let's see what I can learn ....

Do you have any guidance you can recommend?

Thank you again for your kind support.

Hello

atty

There are literally hundered of tutorials out there on the web, but no short cuts.

---------------------------------------------------------------------------------------------
(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-