Source language: Translate to:

About online mySQL.

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

About online mySQL.

Postby sakismorGR » Tue Jun 12, 2007 1:21 pm

Congratulations for the new plugin.....a special one.

I like to know if it is possible to connect with an online DB like MySQL. Please if it is not possible please tell if in the near future have an update for this.
User avatar
sakismorGR
 
Posts: 91
Joined: Sat Apr 29, 2006 10:21 pm
Location: Kavala-Greece

Postby smartmedia » Tue Jun 12, 2007 1:24 pm

Hi...

sakismorGR, YES you can very easy connect to MySQL database, i have test it and is working 100%...

Πάρε με τηλέφωνο...

Thanks
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby beno » Tue Jun 12, 2007 1:34 pm

Hi smartmedia,

Can you please post a little example on how to do this?

This could be a great jumpstart for newbies like me in this arena.

Thanks in advance,

beno
User avatar
beno
 
Posts: 678
Joined: Fri Apr 01, 2005 9:03 am
Location: México

Postby dpayer » Tue Jun 12, 2007 3:56 pm

beno wrote:Hi smartmedia,

Can you please post a little example on how to do this?

This could be a great jumpstart for newbies like me in this arena.

Thanks in advance,

beno


There are a few things to be aware of when accessing MySQL remotely

1) you must interact with the server with a username. To interact with the database from a remote location (like your office), the MySQL user on the server must be associated with the host (ip address) or by default MySQL will only accept request from localhost (the server itself, not remote hosts). So you must go into your PHPMyAdmin and create a user for your IP address username@XXX.XXX.XXX.XXX etc)

2) your firewalls must be open (MySQL works on a specific port but it is different for versions 3.X, 4.X, and 5.X)

3) there are security issues. If you do the above and then try to access your database, you are sending your username/password for the database in clear text, which could be intercepted and used against you.

4) you can make a connection via SSH by using Putty or one of the other free ssh programs. This would require your server accept a login from you via ssh. Then you define your MySQL as residing on the localhost address of your own machine. You MUST use MySQL's ODBC driver on your machine to access the server. You can then open via the ssh connection a link to your MySQL database on the server.

See the following page for reference:

http://www.vbmysql.com/articles/securit ... ng-part-1/

This of course may not fit everyone's situation. Your hosting account may not support this type of connection but inexpensive accounts elsewhere do.

5) remember, you can always put data into a database with standard php/asp/perl forms and retrieve it to NB with Internet posts, even without the DB plugin. This may be a way to give customers/clients a way to put information into a database and have it retrieved by an application elsewhere.


A few things to ponder.

David P
User avatar
dpayer
 
Posts: 1384
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA

Postby beno » Tue Jun 12, 2007 6:14 pm

Hi David,

Thanks a lot for your time in writting this useful info.

I need to learn these techniques and will start experimenting with my hosting account and with a local server at my home/office.

Saludos,

beno
User avatar
beno
 
Posts: 678
Joined: Fri Apr 01, 2005 9:03 am
Location: México

Postby Jay-Bird » Tue Jun 12, 2007 6:25 pm

I'm quiverin' with excitement...just downloading...

Thanks NB ...and thanks for the reminders David.

Now I'll be up for 3 days!

Jay
User avatar
Jay-Bird
 
Posts: 164
Joined: Fri Apr 01, 2005 7:01 am
Location: Louisiana , USA

Postby smartmedia » Tue Jun 12, 2007 10:31 pm

Hi...

For anyone want's to try server side connectivity on your local PC or LAN you can use XAMPP.
You can download it FREE from http://www.apachefriends.org/en/xampp.html.
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby dpayer » Wed Jun 13, 2007 7:37 am

smartmedia wrote:Hi...

For anyone want's to try server side connectivity on your local PC or LAN you can use XAMPP.
You can download it FREE from http://www.apachefriends.org/en/xampp.html.


Be aware that the XAMPP installs by default MySQL 5.0 and the ODBC driver for MySQL does not fully support version 5 at this time. There is a beta available of the ODBC driver that is available though.

D
User avatar
dpayer
 
Posts: 1384
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests