[mythtv-users] My MySql hell :-)

[Peter Abplanalp]

----- Original Message ----- 
From: "Damian Surr" <damian at gingermagic.co.uk> 
To: "Discussion about mythtv" <mythtv-users at mythtv.org> 
Sent: Friday, March 9, 2007 12:59:47 PM (GMT-0700) America/Denver 
Subject: [mythtv-users] My MySql hell :-) 



> Database error was: 
> Access denied for user 'mythtv'@'192.168.0.2' (using password: YES) 

this error says that you do not have access to that account from that host. i.e. the mythtv client is telling the mysql server that 'mythtv' is connecting from '192.168.0.2' and mysql is telling you that mythtv is not allowed to connect to the service from 192.168.0.2. 

what you need to do is allow access from 192.168.0.2. you can do this by logging in to the mysql server using the root account and running the following command: 

GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'192.168.0.102' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 
flush privileges; 
whatever you use for 'some_pass' needs to be in the mysql.txt file. you can make it easy and use 'mtythtv'. 



> $ mysql -u root mysql 
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO) 

this is a problem. you probably won't be able to update the user table with the mythtv account. i do not know what default password you get with your distro; however, on some it is just blank. you can try a simple <enter> when prompted for a password. 


-- 
Peter Abplanalp 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070309/4da1e991/attachment.htm