PivotalMySQLWeb | free Pivotal open source project , intended to handle | SQL Database library
kandi X-RAY | PivotalMySQLWeb Summary
kandi X-RAY | PivotalMySQLWeb Summary
PivotalMySQLWeb is a free Pivotal open source project, intended to handle the administration of a Pivotal MySQL Service Instance over the Web. PivotalMySQLWeb supports a wide range of operations on a Pivotal MySQL Service Instance such as managing tables, views, indexes which can all be performed via the user interface, while you still have the ability to directly execute any number of SQL statements.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of PivotalMySQLWeb
PivotalMySQLWeb Key Features
PivotalMySQLWeb Examples and Code Snippets
Community Discussions
Trending Discussions on PivotalMySQLWeb
QUESTION
I am trying to understand PCF concepts and thinking that once i am done with creating mysql services in PCF, how i can manage that database like creating tables and maintaining that table just like we do in pur traditional environment using mySqldeveoper. I came across one service like PivotalMySQLWeb and tried but didnt liked it much. So if somehow i can get connection details of mysql service , i can use that to connect using sql developer.
...ANSWER
Answered 2018-Mar-16 at 13:00The links @khalid mentioned are definitely good.
http://docs.pivotal.io/p-mysql/2-0/use.html https://github.com/andreasf/cf-mysql-plugin#usage
More generally, you can use an SSH tunnel to access any service, not just MySQL. This also allows you to use whatever tool you would like to access the service.
This is documented here, but if for some reason that goes away here are the steps.
- Create your target service instance, if you don't have one already.
- Push an app, any app. It really doesn't matter, it can be a hello world app. The app doesn't even need to use the service. We just need something to connect to.
- Either Bind the service from #1 to the app in #2 or create a service key using the service from #1. If you bind to the app, run
cf env
or if you use a service key runcf service-key MY-DB EXTERNAL-ACCESS-KEY
and either one will give you your service credentials. - Run
cf ssh -L 63306:us-cdbr-iron-east-01.p-mysql.net:3306 YOUR-HOST-APP
, where63306
is the local port you'll connect to on your machine andus-cdbr-iron-east-01.p-mysql.net:3306
are the host and port from the credentials in step #3. - The tunnel is now up, use whatever client you'd like to connect to your service. For example:
mysql -u b5136e448be920 -h localhost -p -D ad_b2fca6t49704585d -P 63306
, whereb5136e448be920
andad_b2fca6t49704585d
are the username and database name from step #3 and 63306 is the local port you picked from step #4.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install PivotalMySQLWeb
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page