running phpmyadmin using wamp server

6 views
Skip to first unread message

Sudhakar

unread,
Oct 18, 2009, 5:52:51 PM10/18/09
to NZ PHP Users Group

i have installed wamp on my computer and when i access phpmyadmin i
get the following error

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

i already have xampp installed on my computer, i want to learn smarty
templates so i am using wamp for the sake of learning smarty, i do not
want to install smarty on xampp as it is already configured with other
settings so i would like to use wamp

i am using windows xp service pack 2

i have changed the port to 81 in the httpd.conf configuration file of
wamp and changed server name to localhost:81 so i access wamp as
http://localhost:81 this works fine, from this page when i click on
phpmyadmin link i get the error

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

i have followed the steps from the following links

http://www.wampserver.com/phorum/read.php?2,30300
http://forums.macosxhints.com/showthread.php?t=58057


i have tried stopping all services and restarted wamp service however
i am not able to access phpmyadmin but i am able to access wamp as
http://localhost:81 and any files i create in the wamp/www folder

please advice.

thanks

S.Mohammed Alsharaf

unread,
Oct 18, 2009, 5:56:54 PM10/18/09
to nzp...@googlegroups.com
make sure the user name and password are correct in phpmyadmin configuration file
/phpmyadmin/config.inc.php
 
Thanks
Mohammed Alsharaf
 

 
> Date: Sun, 18 Oct 2009 14:52:51 -0700
> Subject: [phpug] running phpmyadmin using wamp server
> From: sudhak...@gmail.com
> To: nzp...@googlegroups.com

Michael

unread,
Oct 18, 2009, 6:03:12 PM10/18/09
to nzp...@googlegroups.com
On Mon, 19 Oct 2009 10:52:51 Sudhakar wrote:
> i have installed wamp on my computer and when i access phpmyadmin i
> get the following error
>
> #1045 - Access denied for user 'root'@'localhost' (using password: NO)
>
> i already have xampp installed on my computer, i want to learn smarty
> templates so i am using wamp for the sake of learning smarty, i do not
> want to install smarty on xampp as it is already configured with other
> settings so i would like to use wamp
>
> i am using windows xp service pack 2

It is a MySQL permissions issue. Go and set a root username and password for
MySQL.

It does sound though like you should be spending some time learning some
fundamentals prior to attempting your project, as your question really does
rate along with 'how do I turn my computer on'?

MatF

unread,
Oct 20, 2009, 6:24:01 PM10/20/09
to NZ PHP Users Group
if ($userName = 'Micheal')
{
echo header( 'http://groups.google.com/group/elitenzphpug/' ) ;
}

Wow. I almost wrote that from scratch! Dang, I'm getting better at
this PHP thing ;p

Keri Henare

unread,
Oct 20, 2009, 6:34:52 PM10/20/09
to nzp...@googlegroups.com
Sudhakar:
Hey man. Basically, your Mysql root user has a password set, but
phpmyadmin isn't providing a password when it connects to the
database. You need to edit phpmyadmin's config.inc.php file and put
your password in there (if it auto logs in, which I suspect it is).
Wamp should allow you to see or set the password somewhere. Might be a
default in documentation?

Hope this helps.

Michael:
stop being such a prick! This is a mailing list that's here for help.
You don't want to help someone then fine, but keep your mouth shut.
It's no worse than a lot of the questions that you ask.

Kind regards,

---------------------------------------------------
Keri Henare
(Views expressed are not necessarily those of my employer.)

[e] ke...@henare.co.nz
[m] (+64) 021 874 552
[w] kerihenare.com

ber...@pobox.com

unread,
Oct 20, 2009, 6:36:39 PM10/20/09
to nzp...@googlegroups.com
>>>>> "MatF" == MatF <mace.o...@gmail.com> writes:

MatF> if ($userName = 'Micheal') { echo header(
MatF> 'http://groups.google.com/group/elitenzphpug/' ) ; }

MatF> Wow. I almost wrote that from scratch! Dang, I'm getting
MatF> better at this PHP thing ;p

Eh, that should be

$userName == 'Micheal' [sic?]

So two ==, not one, thanks PHP's C heritage.

--
Cheers,

Berend de Boer

Sid Bachtiar

unread,
Oct 20, 2009, 6:43:31 PM10/20/09
to nzp...@googlegroups.com
Might need to use === just to enforce which type of Michael is targeted here :P
--
Blue Horn Ltd - System Development
http://bluehorn.co.nz
Reply all
Reply to author
Forward
0 new messages