[mythtv-users] Help me fix my database

[Jarod C. Wilson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 21 April 2004 16:56, Dex West wrote:
> I did something today to my database setup trying to
> get Mythweb to work.  Now when I type mythbackend i
> get the follow error message:
>
> Unable to connect to database!
> Driver error was [1/1045]:
> QMYSQL3:  Unable to connect
> Database error was:
> Access denied for user 'mythtv at localhost' (Using
> password: YES)
>
>
> Couldn't open database.
>
> Any suggestions?  i retyped the UPDATE user ...
> command from Jarod's instructions.  That didn't seem
> to solve anything.

Those commands are only for the root user. The error is for the mythtv user, 
so try resetting the login for your mythtv user. Try this:

# mysql -u root mysql -p
(enter the root password you set)
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit

That won't fix things if you've removed the mythtv user somehow, but should 
reset a tanked password. Try:

$ mysql -u root -p < /usr/share/doc/mythtv-0.14/database/mc.sql

Or at least some of the user add commands out of that mc.sql file (its 
plain-text) if you need to restore some missing user info.

- -- 
Jarod C. Wilson, RHCE
jcw at wilsonet.com

Got a question? Read this first...
     http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
     http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
     http://www.gossamer-threads.com/archive/MythTV_C2/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAhyADln8CX+oYdJURAtJvAKCJO16OonGpyImunR64UCd/KorkkQCgtz4R
1zim16jDQ2eiRu/52aYmMIs=
=7jJl
-----END PGP SIGNATURE-----