MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old January 3rd, 2004, 11:57 AM
Project-Stealth Project-Stealth is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 Project-Stealth User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy 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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > similar mysql problem - locked self out


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway