[mythtv-users] can't login in to sql

Brad DerManouelian myth at dermanouelian.com
Mon Dec 22 02:32:11 UTC 2008


On Dec 21, 2008, at 5:38 PM, the mad doctor kaeding wrote:

> echo 'show databases;' | mysql --user=root --password
> gives
> ....
> mysql
> mythconverg
> .....

So the mythtv user doesn't have access to the mythconverg database by  
the root user does.
Again, I point you to this page:
http://www.mythtv.org/wiki/index.php/Mysql
With special attention to this part:
# mysql -u root -p mysql
myqsl> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
     -> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20081221/0655d1ec/attachment-0001.htm 


More information about the mythtv-users mailing list