1
Users / Re: "myth tv seems to have died"
« on: June 20, 2007, 12:11:13 am »
Hello,
I also had problems logging in to mySQL with user mythtv.
I think I solved it with the following procedure:
Login as root:
Select the mysql database:
Display al users:
Remove all mythtv users:
When all mythtv users are removed, create a new one with all rights and without a password:
Exit mySQL and try to log in as mythtv.
I wrote this procedure without referencing the exact commands. So there may be errors in the commands, but I think the general idea is clear.
If it works you can assign a password and revoke rights if security is an issue.
Succes,
Electuur.
I also had problems logging in to mySQL with user mythtv.
I think I solved it with the following procedure:
Login as root:
Code: [Select]
mySQL –u root
(Use –p if you have a password assigned)Select the mysql database:
Code: [Select]
use mysql;
Display al users:
Code: [Select]
Select User, Host, Password form user;
Remove all mythtv users:
Code: [Select]
Drop user ‘mythtv’@’localhost’;
Drop user ‘mythtv’@’192.168.80.1’;
Etc. whatever ‘mythtv’@...... user is listed in the user table.When all mythtv users are removed, create a new one with all rights and without a password:
Code: [Select]
Grand all privileges on *.* to ‘mythtv’@’localhost’;
Exit mySQL and try to log in as mythtv.
I wrote this procedure without referencing the exact commands. So there may be errors in the commands, but I think the general idea is clear.
If it works you can assign a password and revoke rights if security is an issue.
Succes,
Electuur.