
January 3rd, 2004, 11:57 AM
|
|
Junior Member
|
|
Join Date: Jan 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
similar mysql problem - locked self out
Hi
I am building the site for URL on my own computer, using apache+mysql+phpnuke from the php-nuke installer kit.
I am running windows 2k professional with 700megs of ddr ram and 1.6Ghz cpu.
I am new to php and mysql and have made a lot of errors already - but i'm learning ^_^.
I ran the site for a few months and then wanted to add some further facilities to the website, including a chatter facility; X7Chat and another one I can't remember. However, after checking it out I found it wasn't what I wanted and I wanted to remove it, but couldn't find how to access phpMyAdmin. I got that sorted - i had set the wrong paths in httpd.conf file in apache folder. After sorting that and getting access to the phpMyAdmin page, I found I had no passwords assigned anywhere and was being told to change some defaults. So I added some passwords and locked myself out of the phpMyAdmin page and website and now get the following error:
Quote:
Welcome to phpMyAdmin 2.4.0
Error
MySQL said:
Access denied for user: 'root@127.0.0.1' (Using password: NO) |
I did some reading and tried logging in using the command prompt:
Quote: C:\mysql\bin\>mysql -u myname -p -h 127.0.0.1
Enter password: ****** |
welcome msg follows
How can I take all passwords back off again and assuming that gets me back to being able to use the the phpMyAdmin page again, what should I set and not set?
Thanks a lot 
|