Results 1 to 5 of 5

Thread: Remote frontend cannot connect to backend

  1. #1
    Join Date
    Aug 2005
    Beans
    51

    Remote frontend cannot connect to backend

    My backend server ip is 192.168.1.4. How do I fix the following?

    Code:
    xxx@hardy2:~$ mysql -u mythtv -pXXX-h 192.168.1.4 mythconverg
    ERROR 1045 (28000): Access denied for user 'mythtv'@'hardy2.local' (using password: YES)
    I've looked at http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 and done the following:

    Code:
    $ mysql -u root mythconverg
    mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
    mysql> flush privileges;
    I've also checked /etc/mysql/my.cnf and changed set "bind-address=192.168.1.4" and made sure "skip-networking" is not found. Do I have to add an entry into /etc/hosts.allow on my backend?

    Thanks

  2. #2
    Join Date
    Aug 2005
    Beans
    51

    Re: Remote frontend cannot connect to backend

    On my backend 192.168.1.4 I tried:

    Code:
    xxx@hardy1:~$ mysql -u mythtv -pXXX -h localhost mythconverg
    and it connects. But when I still get an error when I try:

    Code:
    xxx@hardy1:~$ mysql -u mythtv -pXXX -h 192.168.1.4 mythconverg
    ERROR 1045 (28000): Access denied for user 'mythtv'@'hardy1.local' (using password: YES)
    How do I fix this?

  3. #3
    Join Date
    May 2007
    Location
    NY's first capital
    Beans
    2,618
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: Remote frontend cannot connect to backend

    If you changed the default password for mysql mythtv user, you will need to tell mysql. You will need to get your mysql prompt with root user and perform a change password command.

    Check here if you need the commands.

    http://www.cyberciti.biz/faq/mysql-c...root-password/
    Nothing is ever easy, but if it is difficult you must be doing it wrong.

  4. #4
    Join Date
    Aug 2005
    Beans
    51

    Re: Remote frontend cannot connect to backend

    I set the password to be the same as shown in:

    Code:
    mysql> select host, user, password from user;
    +--------------+------------------+-------------------------------------------+
    | host         | user             | password                                  |
    +--------------+------------------+-------------------------------------------+
    | localhost    | root             |                                           | 
    | hardy1       | root             |                                           | 
    | 127.0.0.1    | root             |                                           | 
    | localhost    |                  |                                           | 
    | hardy1       |                  |                                           | 
    | localhost    | debian-sys-maint | *CE19B4B351A9A3318C7AB4DB72FEE5E316546D4E | 
    | localhost    | mythtv           | *7E599B667CFA08BEF39E0B49F0E5E83CA2A43C41 | 
    | %            | mythtv           | *7E599B667CFA08BEF39E0B49F0E5E83CA2A43C41 | 
    | 192.168.1.%  | mythtv           | *7E599B667CFA08BEF39E0B49F0E5E83CA2A43C41 | 
    | %.local      | mythtv           | *7E599B667CFA08BEF39E0B49F0E5E83CA2A43C41 | 
    | hardy1.local | mythtv           | *7E599B667CFA08BEF39E0B49F0E5E83CA2A43C41 | 
    +--------------+------------------+-------------------------------------------+
    11 rows in set (0.00 sec)
    but I still get:

    Code:
    xxx@hardy1:~$ mysql -u mythtv -pXXX -h 192.168.1.4 mythconverg
    ERROR 1045 (28000): Access denied for user 'mythtv'@'hardy1.local' (using password: YES)

  5. #5
    Join Date
    Aug 2005
    Beans
    51

    Re: Remote frontend cannot connect to backend

    It is fixed now. The following code work from my remote computers but not my backend server.

    Code:
    xxx@hardy2:~$ mysql -u mythtv -pXXX -h 192.168.1.4 mythconverg
    The problem was the mythtv user had different passwords. Whenever I did:

    Code:
    $ mysql -u root mythconverg
    mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
    mysql> flush privileges;
    by default it would set up the new user with the same password as the "debian-sys-maint" password.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •