| re: MySQL Access Denied Question
I had that also and see the question repeated. Hopefully someone will
provide a proper answer. However, here's what I did.
[the brute force approach, simple, effective]
I got the mysql tables (~mysql/mysql/*) from a working install....killed
mysql on the new install and put my "working" tables onto ~mysql/mysql. Then
restarte mysql and of course it let me in. Then do proper finish up of
grants etc.
dp
"Kevin Goad" <None@none.com> wrote in message
news:dWmdnd4ZYsrI0OaiXTWJig@comcast.com...[color=blue]
> Im running Mandrake Linux 9.1 on a Laptop I recently bought, and its
> purpose its a PHP development machine, and I want to use a MySQL
> Backend. I think when I was installing MySQL, something got corrupt,
> and I cannot do anything, it says access denied(And no password was ever
> set, and I've tried all the "--skip-grant-tables" and all that stuff).
> Ive tried installing and uninstalling the RPM' packages, but a database
> I created(called "test") is there after i unistall and reinstall. This
> shows me something somewhere isnt being taken out, and if it did get
> taken out, it could solve my problems.
>
> Anyone know how to do this?
>
> Just an example:
>
> [kevin@localhost kevin]$ mysqladmin ping
> mysqld is alive
> [kevin@localhost kevin]$ mysqladmin create test1
> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
> '@localhost' to database 'test1''
>
> (It does the same thing when I am root)
>
>[/color]
| 
