[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