Setup data connection - mySQL connection failed (1 Viewer)

Werner123

Portal Member
January 6, 2018
14
4
39
Germany Germany
Country flag
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

Last edited:

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    12,631
    7,312
    Kyiv
    Ukraine Ukraine
    Country flag
    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

    Similar threads
    OP Title Forum Replies Date
    G Newb trying MP2, trouble with guide data General 5
    T MP2 - V2.3 New MP User: Setup Help General 3
    O Help with TV setup Newcomers Forum 76
    D Hauppauge HDPVR 1212 quick setup ? Installation, configuration support 8
    J Where the heck is the Client side setup? General 2
    J TV Server setup question Newcomers Forum 0
    M Initial Setup MP2 (On Wndows 10) General 2
    A Client/Server Setup: Slow TV Startup Television (MyTV frontend and TV-Server) 0
    A MP2.2.2, understanding movies/videos/tv and WTV recordings. General 16
    C Setup failed: 0xfffffff7 Allgemeines Support- und Diskussionsforum 1
    B Ceton infinitv channel are red not green after initial setup General 1
    Edwardfc Fanart setup/configuration General 10
    cbr954rr How to setup only german channels in online videos Plugin Development 13
    raffe How do I setup MP2 as an UPnP server? General 3
    F [solved] Dual monitor setup General 4
    M [solved] Setup Issue - Hanging on Starting Services General 3
    M mp2-setup-2.2.zip General 14
    N Setup General 17
    emphatic Mediaportal sends Windows into hibernation without being setup to do so MediaPortal 1 Talk 21
    Requiem Mediaportal setup with plugins - quo vadis? MediaPortal 1 Talk 6
    splatterpop My optimized dvb epg configuration for tv server MediaPortal 1 Talk 0
    S Gpu/hdtv/mp setup help please Newcomers Forum 3
    S [MP2-768] Installation Setup Failed - Error 0x80070666 - VC++ 2015/2017 Redist bug 2.2 Archive 19
    M Failed Setup General 11
    D [Rejected] LAV filter setup wizard Feature Requests 1

    Similar threads

    Top Bottom