ExtremeCloud IQ- Site Engine & Extreme Management Center

Expand all | Collapse all

is it possible to open mySQL database from Microsoft power BI or excel or external application?

  • 1.  is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 04-11-2016 11:34
    I want to access mySQL database from external application, is this possible to access it by Excel or power BI


  • 2.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 04-11-2016 18:10
    AFAIK you can access mySQL externally with some old versions of NetSight. Recent versions can be accessed only from the netsight host.

    but you can change it by:

    cd /usr/local/Extreme_Networks/NetSight/mysql/bin /usr/local/Extreme_Networks/NetSight/mysql/bin$ ./mysql --host=localhost --user=netsight --password=XXXX --port=4589 --protocol=TCP

    GRANT ALL PRIVILEGES ON netsight.* TO 'zdenek'@'192.168.10.201' IDENTIFIED BY 'mojeheslo';
    GRANT ALL PRIVILEGES ON netsightrpt.* TO 'zdenek'@'192.168.10.201' IDENTIFIED BY 'mojeheslo';

    where "zdenek" is the new username, "mojeheslo" is the new password and "192.168.10.201" is IP of your SQL client and XXXX is the old password to the database (you will see that in NetSight on the place where you run database backup"

    I have no information how you can access it by Excel or power BI (whatever are those two programs). :)

    Regards

    Zdenek


  • 3.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 05-12-2016 13:43
    Hello,

    Shouldn't I be able to connect the MySQL NetSight database by Workbench?




  • 4.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 05-17-2016 07:39
    I't works, I had to grant access to this host.


  • 5.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 12-21-2017 01:50
    I still can't access the database after the commands, Am I missing something? restarting the service?


  • 6.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 04-11-2016 18:10
    Thanks Zdenek,

    I am now able to connect to database


  • 7.  RE: is it possible to open mySQL database from Microsoft power BI or excel or external application?

    Posted 04-11-2016 18:10
    Thanks for joining the Hub Tarek.

    Great to see you get a quick resolution here and circling back to let the Community know. Good stuff!