>> > [root@rwideman2 root]# mysql -u root mysql >> > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) >> >> It should ask you for a password here (note that it said "using >> password: no"). The only reason I know why it wouldn't do so is when >> you have somewhere defined to use an empty password. Have a look into >> ~/.my.cnf resp. /etc/my.cnf (if either exists) and look for a line like >> >> password=
Nope. No files... >> Regardless, you can force the command to ask you for a password by >> adding "-p": >> >> mysql -u root -p mysql WAHOOOOO, asked for password. WAHOOOOO I am in. >> > [root@rwideman2 root]# mysql -u mysql mysql >> > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' >> >> Of course, some arbitrary user is not allowed to access the database >> where the access rights are stored (named mysql). But at least, it let >> you login. Ye, i was thinkin the password just got totally corrupted then i couldnt do anything the link i had up had on it...nothing worked. >> > [root@rwideman2 root]# mysql --user="mysql" >> > Welcome to the MySQL monitor. Commands end with ; or \g. >> >> Same as above, it let you login as user "mysql", but you have no right >> to access the database "mysql". This is my 2nd day (yesterday was my first) to mess with MySQL....I am definitely on a learning curve with this. >> >> > I tried the password editing options listed on >> > http://www.mysql.com/doc/en/Access_denied.html >> > and still cant fix it. >> >> That you have missed the part about "--skip-grant-tables" apparently? Nope, i tried it, nogo. >> That is to be expected. Removing MySQL will not remove any database >> (in order to protect you from data loss) and the access rights are >> stored in a database. So you are working on the same databases with >> the same privilege settings. I figured this but wasnt for sure. >> What do you mean by that? The database *files* should be under >> /var/lib/mysql. That you have some DB is obvious by the fact that you >> once managed to login (without any database, you would get something >> like "could not find file 'host.frm" as error). Meaning i did NOT create a DB or do ANYTHING except change the root password within MySQL. Its the learning curve kicking in... >> > I tried to verify the files that were >> > installed by: >> >> The commands and results you quoted already show that apparently MySQL >> is installed correctly. You "just" have problems to login for whatever >> reason. But see the suggestions above. >> >> > Is there away to completely remove mysql files and start over? >> >> If you de-install MySQL (via rpm) and then also do /var/lib/mysql, >> /etc/my.cnf and ~/.my.cnf, you should got everything MySQL-related. MMM, will keep this in mind, but dont need it now. Thanks a biggy. Rob....a Newbie after 3 years. Once a Newbie, Always a Newbie, :)
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
