View previous topic :: View next topic |
Author |
Message |
bruor Apprentice
Joined: 08 Jul 2003 Posts: 239
|
Posted: Sun Sep 28, 2003 3:00 pm Post subject: mythtv mysql error |
|
|
im running gentoo x on my xbox and i cant connect to the master backend at all....
here is the error msg...
Xbox root # mythsetup
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.0.11' is not allowed to connect to this MySQL server
Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Host '192.168.0.11' is not allowed to connect to this MySQL server
but when i try to access the mysql server and do the following:
mysql> grant all on mythconverg* to mythtv@*192.168.0.%* identified by *mythtv*;
i get this:
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*to mythtv@*192.168.0.%* identified by *mythtv*' at line 1
i have compiled qt 2x with the mysql in my use flags so i know that is not the issue... im pretty sure that all i need to do is add access for my other boxes to access the sql server remotely... if anyone know the proper syntax or has any ideaas please help
thank you in advance |
|
Back to top |
|
|
kamikaze_gerbil n00b
Joined: 08 Feb 2003 Posts: 71 Location: Vancouver, Canada
|
Posted: Sun Sep 28, 2003 5:51 pm Post subject: Re: mythtv mysql error |
|
|
bruor wrote: |
but when i try to access the mysql server and do the following:
mysql> grant all on mythconverg* to mythtv@*192.168.0.%* identified by *mythtv*;
|
should those asterisks be there?
According to mythtv site try:
mysql> grant all on mythconverg.* to mythtv@"%.mydomain.com" identified by "mythtv"; |
|
Back to top |
|
|
bruor Apprentice
Joined: 08 Jul 2003 Posts: 239
|
Posted: Mon Sep 29, 2003 11:48 am Post subject: |
|
|
thank you for the post....
i just was thinking perhaps i shouldnt be trying to do this on the xbox while its hooked to the tv... i was wondering about those asterisks...
|
|
Back to top |
|
|
bruor Apprentice
Joined: 08 Jul 2003 Posts: 239
|
Posted: Mon Sep 29, 2003 12:06 pm Post subject: |
|
|
that worked so far now i have to test connection to the dbase ill try it when i get home from work.... |
|
Back to top |
|
|
|