MySQL errors

a2jfreaka2jfreak Houston, TX Member
edited January 2004 in Internet & Media
I hate to start a thread just for a single error, so if others could start posting their MySQL errors in here then that should help keep things clean.

C:\mysql\bin>mysql -uroot -p********
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

How can I fix this? (Yes, I'm using the correct password.)

Comments

  • ShortyShorty Manchester, UK Icrontian
    edited January 2004
    Have you flushed the privileges?

    If that doesn't work, then you can restart the mysql daemon with "--skip-grant-tables" switch.. that will allow you unrestricted access to your databases.

    Set a new password, then restart the daemon and flush the privileges :)

    http://www.mysql.com/doc/en/Command-line_options.html
  • a2jfreaka2jfreak Houston, TX Member
    edited January 2004
    That's for 4, I use 3.

    I'll just remove 3 and install 4.
    How do I take dbs from 3 over to 4?
  • ShortyShorty Manchester, UK Icrontian
    edited January 2004
    I've never done it under Windows, so I can't give you an accurate guide :(

    Il ask someone I know who may know :)
  • KwitkoKwitko Sheriff of Banning (Retired) By the thing near the stuff Icrontian
    edited January 2004
    If you're using MyIsam tables, it should be a seamless port from 3 to 4. Just dump the DBs them import them into 4. Chances are you're using MyIsam, since that's the default for MySQL, and I've never heard of anyone using other than that, especially if you're using MySQL as a web DB.
  • a2jfreaka2jfreak Houston, TX Member
    edited January 2004
    Thanks! :)
    Up and running with MySQL 4.0.17 now. All seems fine.

    I've got another Q, but I think it might warrant a thread of its own since it's not an error and it's a question I think might not be extremely uncommon among SQL newbies such as myself.
Sign In or Register to comment.