sanedog
I solved the issue and following are the steps:
I have installed the XBMC nightly builds so that the mythtv PVR addon is based on mythtv 0.27 and therefore is compatible with Ubuntu 13.10's 0.27 mythtv.
- type on terminal "mysql -u root -p"
at the mysql prompt type-
show databases;
select user, host, password from mysql.user;
see whether the passwords for all the users (i.e. root and mythtv) are the same
if not then you will have to set the passwords using
SET PASSWORD FOR 'User'@
HOST=PASSWORD('yourpassword');
FLUSH Privileges;
type select user, host, password from mysql.user; and
now you should see all the encrypted passwords look alike.
exit;
and i believe you should be done.
If not then the use
command sudo find / -name mysql.txt to see whether you have used the hostnames as the static ip address and not the localhost or 127.0.0.1