WampServer

Hi!
I normally dont use phpmyadmin (I use MySql Administrator) but now I needed it but I cant get it to login to my sql.

#1045 - Access denied for user 'XXXX'@'localhost' (using password: NO)

It also says that I should check "config.inc.php". All looks fine there after I edit it with correct login info.

<?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'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'XXXX';
$cfg['Servers'][$i]['password'] = 'XXXXXXX';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

Should I move the file somewhere? it is located under /apps/phpmyadmin.

How can I change the "Using password"??

Thanks in advance!
/Hylsan

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

that looks abit drastic. I've got a couple of other applications and sites using this mysql connection so I'd rather not change it.

Works fine shelling to mysql and with MySql Administrator/query, so the problem isnt the password, it must be something else...

Thanks anyway
/Hylsan

I am having the same problem. ( 1045 access denied when trying to start phpmysqladmin). I have discovered that I can start this app via [localhost] using root and a blank password (which is currently MySQL password) but can not start it from the WampServer icon in the windows tray. I never get the logon screen only the 1045 error. This is not a password problem. This appears to be a problem with how WampServer is calling phpMyAdmin. Any ideas will help. Thanks! Mike

If something is wrong between phpmyadmin and wamp, you should edit file wamp/alias/phpmyadmin.conf
Check your path and access rights in it...

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

well..my problem lies between phpmyadmin and mysql.
Editied the config.inc file again with a diffrent login name and noticed that it still stood root@localhost...so I am editing the wrong file.

Where should I edit to enter my password for mysql?

Thanks in advance!
/Hylsan

since phpmyadmin is gui for mysql, editting file config.inc.php in phpmyadmin so it can talk w/ mysql but it's not actually set password in mysql, and that's why I've provided the guide to show you how to do that and you should give it a try. if don't like it, just go back and undo what you did

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

bear with me but...
first I cant follow your guide on "how to set password..." since I cant start phpmyadmin...the moment I press phpmyadmin I get the login error.

secondly I tried to read what your little "reset"-program does since I dont want anything reset on my database.
Does it just fiddle with phpmyadmin or does it change my root passwords and other passwords I have in MySQL???

Thanks in advance!
/Hylsan

hylsan clear ur browser history...


then open phpmyadmin and on the bottom right of the page press "open in new window"


now try set it again in the config

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hylsan, I suspect you're having the same problem I did. I fixed it by doing this:

Open "config.inc.php", add this line:

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

(Note the "AllowNoPassword" key, all I had in my config.inc.php file was "AllowNoPasswordRoot"

Once I did that it seemed to work for me. I got the tip from this page:
[forum.synology.com]

Edit:
This issue started for me when I upgraded to WampServer 2.0i. In addition to this problem, I also had to manually switch my PHP and MySQL versions to their newer versions that came with the upgrade, because apparently Wamp didn't do it automatically.



Edited 1 time(s). Last edit at 07/25/2009 07:34PM by briley.

Not sure if we had the same problem but I changed my config.inc.php file so it read the following

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

It now works fine