I made a fresh install of Debian Buster via the net install iso on this computer in order to use MythTV on it. My local network is on the 192.168.10.x subnet mask. My computer has a hostname that I gave it (so, not the default one). In the MythTV settings, it seems that all I typed in it is OK. As an admin user, I can use mythtv-setup with no problem. But it gets stuck with the mythtv user.
Here are the commands I used with MariaDB.
Code: Select all
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'192.168.10.%' IDENTIFIED BY 'mot de passe';
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'127.0.0.1' IDENTIFIED BY 'mot de passe';
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'localhost' IDENTIFIED BY 'mot de passe';
UPDATE user SET Password=PASSWORD('mot de passe') WHERE user='mythtv';
FLUSH PRIVILEGES;
Code: Select all
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'192.168.10.%' IDENTIFIED BY 'mot de passe' WITH GRANT PRIVILEGES;
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'127.0.0.1' IDENTIFIED BY 'mot de passe' WITH GRANT PRIVILEGES;
GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'localhost' IDENTIFIED BY 'mot de passe' WITH GRANT PRIVILEGES;
UPDATE user SET Password=PASSWORD('mot de passe') WHERE user='mythtv';
FLUSH PRIVILEGES;
Code: Select all
mysqlcheck --user=mythtv --password=mot de passe mythconverg
Code: Select all
E [DBManager0] Unable to connect to database!
E Driver error was [1/1045]: QMYSQL:
Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)
I Start up testing connections, DB Sutiwora, BE 192.168.10.xyz, attempt 2, status beAwake, Delay: 2000
I MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 192.168.10.xyz:6543 (try 1 of 1)
E MythSocket(7f47c00abf0:-1): Failed to connect to (127.0.0.1:6543) Connection refused
E Connection to master server timed out.
Either the server is down or the master server settings in mythtv-settings does not contain the proper IP address
A Cannot connect to backend
E Failed to init MythContext, exiting.
Edit: I changed the title of the subject in order to mark it as solved.