[mythtv-users] can't login in to sql
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
So the mythtv user doesn't have access to the mythconverg database by
the root user does.
Again, I point you to this page:
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;
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users