Arch Linux

schome1

Member

Registered: 2004-02-15

Posts: 61

mysql problems

I entered a password incorrectly using

mysqladmin -u root password 'password
'

Now I can't get into mysql and I can't re-issue the mysqladmin comment because it won't allow me to connect to the database.  What can I do to get access to the database and change my root password?

this is the error I get when trying to run mysql

[root]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

cactus

Taco Eater

From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰

Registered: 2004-05-25

Posts: 4,622

Website

Re: mysql problems

http://forums.gentoo.org/viewtopic.php?t=153453

haven't really read all of it, but it looks promising..
heh...those gentoo people sure can figure things out.

---

"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

schome1

Member

Registered: 2004-02-15

Posts: 61

Re: mysql problems

Thanks for the link.  It is now working on my system.