Hello All,
Brand new to mythTV and trying to setup on LinuxMint 17.3. Package installation appeared to go fine, but running initial backend setup is stuck trying to log into MySQL.
Reading the terminal screen running behind the setup GUI i see "Access denied for user ... Cannot login to database"
Although I am certain I wrote the MySQL password down properly when prompted a couple minutes ago, maybe I could reset it. How might I do that?
Also, what would be the proper User name to use in the Database Server Settings? Can I use anything I'd like?
Appreciate any help you could provide.
Backend initial setup stuck on MySQL login
Moderator: Forum Moderators
-
dizygotheca
- Developer
- Posts: 267
- Joined: Wed Sep 03, 2014 9:02 am
Re: Backend initial setup stuck on MySQL login
If you're installing from the Ubuntu repository/Software Centre then you may have been bitten by the packaging bug described in
viewtopic.php?f=36&t=67&p=5224&hilit=ac ... nied#p4008
A proper installation shouldn't require you to type in the password and there's no simple way to reset it.
If you're not using MySQL for anything else, the simplest remedy is to purge it (uninstalling MythTV) and start again. Make sure you remove the MySQL database completely though - simply reinstalling won't reset the database.
The Ubuntu repository contains a very old version. Current version (and updates) are available from the Mythbuntu repository (see link). Installing from there should work out-of-the-box.
In the Frontend setup/Database Server Settings, the user/password must match those configured in MySQL during installation, so don't try and change them from the frontend.
There's little point in changing from the default mythtv/random string - it's only the MySQL account by which Myth accesses the database. You should never need to use it manually and it can be easily retrieved from your config.xml, if necessary. But you can set your own user/password during installation, if you wish.
Note that during installation you will also be prompted to set a MySQL admin password, for managing MySQL itself. This is not used by Myth and is the one you should make a note of.
viewtopic.php?f=36&t=67&p=5224&hilit=ac ... nied#p4008
A proper installation shouldn't require you to type in the password and there's no simple way to reset it.
If you're not using MySQL for anything else, the simplest remedy is to purge it (uninstalling MythTV) and start again. Make sure you remove the MySQL database completely though - simply reinstalling won't reset the database.
The Ubuntu repository contains a very old version. Current version (and updates) are available from the Mythbuntu repository (see link). Installing from there should work out-of-the-box.
In the Frontend setup/Database Server Settings, the user/password must match those configured in MySQL during installation, so don't try and change them from the frontend.
There's little point in changing from the default mythtv/random string - it's only the MySQL account by which Myth accesses the database. You should never need to use it manually and it can be easily retrieved from your config.xml, if necessary. But you can set your own user/password during installation, if you wish.
Note that during installation you will also be prompted to set a MySQL admin password, for managing MySQL itself. This is not used by Myth and is the one you should make a note of.
Re: Backend initial setup stuck on MySQL login
This is exactly what i'm up against.
I'll work through your suggestions.
Thanks for the quick reply.
I'll work through your suggestions.
Thanks for the quick reply.