Setup data connection - mySQL connection failed (1 Viewer)

Werner123

Portal Member
January 6, 2018
21
5
42
Home Country
Germany Germany
Hello everybody,
after the installation of MP1.23 I have a problem with the TV server. On opening the TV server configuration the window "Setup database connection" pops up. When trying to "Test" the connection with MySQL selected, the error message "Connection failed" shows up. All fields were pre-filled. More details can be seen in the screenshot attached.
Cheers


And in German:
Hallo zusammen,
nach der Installation von MP 1.23 habe ich ein Problem mit dem TV-Servers. Es erscheint das Fenster "Setup database connection". Beim Testen der Verbindung über MySQL erscheint dann die Fehlermeldung "Connection failed". Alle Daten in den Feldern waren vorausgefüllt! Details siehe Screenshot im Anhang.
VG
 

Attachments

  • mysql.JPG
    mysql.JPG
    97.7 KB
Last edited:

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    When trying to "Test" the connection with MySQL selected, the error message "Connection failed" shows up.
    Have you changed something? Computer name? IP address? MySQL on this host? Or? ...

    In google i found similar problem:

    Problem: Connection to the MySQL server occurs with the error "Host‘ such and such ’is not allowed to connect to this MySQL server." This is due to the fact that the user on behalf of whom you are accessing the MySQL server does not have access to this server from the current IP address.
    Solution: in the user table, you need to allow the user access to the database either from a specific one (for example, ‘10 .10.10.10 ’@ @’ user ’) or from any IP address (‘% ’@’ user ’).
    Actions: In the console, log in to the MySQL server under the root username with its password, create (or modify, if it already exists) the user with the ability to connect to the database we need from any IP address and reload the permissions table:
    Code:
    ~# mysql -u root mysql -p
    Code:
    mysql> GRANT ALL PRIVILEGES ON database.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
    mysql> exit;
    Code:
    ~# mysqladmin -u root -p flush-privileges
    Here database is the database to which we assign the rights to the user username with password password.

    If MySQL and Mediaportal TV Server on one host, try change computer name in connect window to localhost ...
     

    Users who are viewing this thread

    Top Bottom