MediaPortal Wiki > MediaPortal 1 > Customization > TV-Server > SQL Server > MySQL

MySQL

0 of 1 found this page helpful
    edit.png

    On 22 Sep 2010, chefkoch suggested that this page or content is incomplete and needs to be expanded.

    Configuring TV-server for MySQL

    • Install MediaPortal and TV-Server.
    • Launch TV-Server by through Start > All Programs > Team MediaPortal > MediaPortal TV Server.
    • You will get a window called Setup database.
    • Click the radio button next to MySQL 5.
      • Hostname is the name of the server machine (what it is called on the network when you look in My Network Places).
      • Username is root.
      • Password is what you defined in the MySQL installation.

    Limited connectivity

    When MySQL is installed by MediaPortal setup, it is configured to allow all clients to connect. If MySQL was installed earlier it might be configured to deny access to some client computers.

    MySQL - Not allowed to connect to this server.png

    To configure the MySQL settings you need to install MySQL Workbench.

    Launch MySQL Workbench and click Server Administration.

    MySQL - Server Administration.png

    Enter the root password.

    Select the Users and Privileges tab and make sure that the user root is not prevented to connect from your MediaPortal computer. You may use % as wildcard in the field Limit Connectivity to Hosts Matching to allow access from any host.

    MySQL - Limit Connectivity to Hosts Matching.png




    Go to top
    Powered by MindTouch
    Running the latest version?
    V1.2.3 - released April 2012
    Releasenews | Download
    Changelog
     | Requirements
    opensource-logoTeam-MediaPortal 
    About
    Contact |  Press
    Partners