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

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I want to access mySQL database from external application, is this possible to access it by Excel or power BI
Photo of Tarek Elwan

Tarek Elwan

  • 82 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Pala, Zdenek

Pala, Zdenek, Employee

  • 9,834 Points 5k badge 2x thumb
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
Photo of Tarek Elwan

Tarek Elwan

  • 82 Points 75 badge 2x thumb
Thanks Zdenek,

I am now able to connect to database
Photo of Ryan Mathews

Ryan Mathews, Alum

  • 8,988 Points 5k badge 2x thumb
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!
Photo of Yves Haslimann

Yves Haslimann

  • 898 Points 500 badge 2x thumb
Hello,

Shouldn't I be able to connect the MySQL NetSight database by Workbench?
Photo of Yves Haslimann

Yves Haslimann

  • 898 Points 500 badge 2x thumb
I't works, I had to grant access to this host.
Photo of Supermac7

Supermac7

  • 132 Points 100 badge 2x thumb
I still can't access the database after the commands, Am I missing something?  restarting the service?