Advanced Search

Results 1 to 2 of 2

Thread: Tried adding a password to MySQL Console, now it won't let me login.

  1. #1
    Join Date
    May 2011
    Posts
    8
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Default Tried adding a password to MySQL Console, now it won't let me login.

    Hello I have some html experience but am a newbie to the world of php and mysql. I was following along with the tutorial on Lynda.com (PHP with MySQL Essential Training) So I downloaded Wampserver2.2 withApache, MySql, PHP SQL Buddy, and Xdebug.

    I went to add a password to MySql Console and now it wont let me in.

    Here are my steps:

    Enter password>
    Use my sql>
    UPDATE user>
    SET password= Password("******" >
    WHERE user='root';>
    (Query updated 3 rows affected)
    mysql>
    FLUSH PRIVILEGES>
    quit

    I am running windows 7
    Apache 2.2.22
    MySQL 5.5.24
    SQL Buddy 1.3.3
    XDebug 2.2.0

    Thanks in advance.

  2. #2
    Join Date
    May 2011
    Posts
    8
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Default

    I think I got it figured out. Rookie mistake.

    Last night I had accidentally downloaded the 32 bit version to my computer, and today when i installed it I used that version.

    Long story short, I installed the 64bit now and I'm okay.

    For now anyway, ha ha.

Similar Threads

  1. Login and Password code
    By Kevin1201 in forum JavaScript
    Replies: 28
    Last Post: 12-16-2010, 05:16 PM
  2. login and password not working
    By vineet in forum PHP
    Replies: 1
    Last Post: 10-25-2008, 07:36 AM
  3. Login Password Script Help
    By isamarlow in forum JavaScript
    Replies: 26
    Last Post: 03-24-2007, 01:29 AM
  4. PHP Login Password Script HELP!!
    By isamarlow in forum PHP
    Replies: 4
    Last Post: 02-28-2007, 09:49 PM
  5. password login
    By timpoth in forum HTML
    Replies: 5
    Last Post: 11-24-2005, 04:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •