[mythtv-users] Database setup
Michael T. Dean
mtdean at thirdcontact.com
Sun Mar 23 00:54:28 UTC 2008
On 03/22/2008 08:05 PM, Harry Devine wrote:
> I can do all of those commands fine. I even followed the suggestion of
> another post where I did the "drop database mythconverg" command, then
> ran thru the steps in that Wiki article you sent me. All went well,
> BUT, when I run mythtv-setup I'm getting the same "Host <ip> is not
> allowed to connect to this MySQL server" error.
>
> How can I completely remove all of the mysql stuff and get back to a
> clean slate?
First, I'm assuming that you did /not/ configure MythTV (in the Database
Configuration popup that appeared the first time you started
mythtv-setup) to use the MySQL root user. Therefore any test with
"-uroot" is irrelevant. Most likely you configured MythTV to use the
mythtv user in MySQL, so you need to test with "-umythtv".
Also, the hostname you specified in that Database Configuration popup is
important. It's used to make the connection. So, you may just need to
reset the MythTV database configuration (which you do with "rm
~/.mythtv/config.xml") and then restart mythtv-seutp. Then, before
clicking Next (or whatever the button is), test the username, password,
and hostname/IP address you specify with:
mysql -h<hostname> -u<username> -p <database_name>
(and type in your password at the prompt). The <hostname> should be the
hostname or IP address you give to MythTV (i.e. some computer name or
localhost or 127.0.0.1 or ...). Once you can make a connection like
that, you can submit the Database Configuration popup and mythtv-setup
should work.
Note the lack of a space after the MySQL command-line argument (i.e.
"-h" and "-u") and the value that follows it. It is /critical/ that you
do not put a space there (while it often works with just -u, when adding
other arguments, it won't). So, an example of how to connect to a
database on hostname "mythhost" with username "mythtv" with database
name "mythconverg" is:
mysql -hmythhost -umythtv -p mythconverg
Note, also, there is a big difference between "-hmythhost" and
"-hmythhost.mydomain". You need to use exactly what you specify to MythTV.
Mike
More information about the mythtv-users
mailing list