Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are two ways to archive connectivity from netbeans:</p> <ol> <li><p><strong>REALLY UNSAFE Method:</strong> Make MySql listen on the network-interface connected to the internet. Set <em>bind-address</em> in your mysql-configuration file to 0.0.0.0 and mysql will listen on all interfaces. <a href="http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_bind-address" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_bind-address</a> You can then access MySql from everywhere on the internet. <br /> <em>Remember: This is a serious security vulnerability! Search Google and you will find a lot of articles explaining in great detail why.</em></p></li> <li><p><strong>Safe method:</strong> SSH can do port-forwarding. It means, that one port on your local machine listens for connections and tunnels all traffic well encrypted to the remote port. On linux this is done with <code>ssh -L 3306:localhost:3306 YOUR_SERVERS_IP</code>. You can then access your MySql-Server on localhost:3306 like it is running on your local computer (just slower). On Windows Putty can be configured to do the same thing. I don't remember exactly where, but in the dialog where you setup your connection (before the command-prompt) you also can configure port-forwarding. </p></li> <li><p>Write an application to run on your server, which takes care of Authorization and exposes and API to users (like the Youtube-api for example, which has some public methods but also some requiring authentication). This could be done in numerous different ways like XMLRPC (using a webserver and some web-application) or a custom protocol. This is probably the one most suitable for production use.</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POHow to access db in vps
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDelphinator
    1. USDelphinator
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to access db in vps
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CO2 is the way to go but it is not working yet, I'm connecting to linux from winwods via putty, but the commands says it is already in use, but when i try to connect from netbeans it fails
      singulars
      1. PO
      1. USIgnacio Garat
    2. CO@Ignacio that sounds like you have something running on that port, our your configuration is not working. If you have any other service running on that vps (like a web-server), try redirecting that. If that works something is wrong with MySql (only listening on a socket? See if "skip-networking" is enabled..), if it doesn't, your configuration is wrong.
      singulars
      1. PO
      1. USDelphinator
    3. COyou where right but now diff problem, please look at new question if possible, thank you very Muchhh
      singulars
      1. PO
      1. USIgnacio Garat
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload