Hi Jake,
mysql -u mythconverg -p -h localhost
but mythconverg is the database not the user?
I've probably changed mine to something totally random, use the details
from /etc/mythtv/mysql.txt
although you do raise a good point
do something like
mysql -u someusername -p -h localhost mythconverg
that should also make sure your logging into the right db and have
access to it.
then think about trying it again with 127.0.0.1 and your machines public
ip address.
(going from memory the mysql client will use a socket on localhost and
tcp/ip on 127)
what do you mean by changed the permissions on mysql?
I use the webmin module to change the settings for MYSQL. I told it allow user
mythtv to connect from any port
That should have fixed up that @'localhost' Vs @'%' thing
take a look in the mysql.user table to check
(ie select * from mysql.user;)
you will also need to edit /etc/mysql/my.conf and change "bind address"
to "0.0.0.0" or to the ip address of your network
got me:
/usr/bin/mysql: unknown variable 'bindaddress=0.0.0.0'
this is the line from my my.cnf
bind-address = 0.0.0.0
what do you mean by change the user? I did notice that sometimes for some
weird reason when I typed int the network IP of my server 192.... it came up
as 'myth' '@' ' ' in the log window, which I thought was weird.
probably some sort of reverse dns lookup weirdness, wouldnt worry about
it too much
Cheers
Jon
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
