Access, read & wrtie to a MySql databse via Internet
We have a database on the internet that uses MySql. We want to access this database as if it was in our computer or local LAN. The MySql is located in Goddady hosting.
Whats the best way of doing this using?
Whats the best way of doing this using?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Any specific or technical question I have to ask Godaddy, besides "I want to access my DB from my PC"?
I have an Access DB for my GoDaddy site. They provide how-to instructions, although I only use the connection string they provided and connect via that in my server-side ASP (all written in JavaScript).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK... I'll contact them at this moment.
ASKER
TheHiTechCoach:
I download both links "mySQL ODBC driver" and "HeidiSQL", when I install them, I just
create the ODBC thru Administration Tools as always?
I download both links "mySQL ODBC driver" and "HeidiSQL", when I install them, I just
create the ODBC thru Administration Tools as always?
You have to create the database on Godaddy first and get the connection parameters from the database setup. Make sure you set it up for external access because you can't change it after it is set up. You would have to create a new one and transfer the data.
ASKER
I talked with the Cust Support of Godaddy. I also have my MySql database setup and with data (they are setup as remote access).
They gave all the parameters: Host Name or Server, Port and User Name.
Now how do I connect?
They told me I can use Microsoft SQL Studio to connect to my MySql databases, but it doesn't work.
Please advice
They gave all the parameters: Host Name or Server, Port and User Name.
Now how do I connect?
They told me I can use Microsoft SQL Studio to connect to my MySql databases, but it doesn't work.
Please advice
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I wouldn't have suggested that. What applications are you wanting to connect with? What resources or programming languages do you have available? I have used OpenOffice's Base program to connect to MySQL databases.
ASKER
I downloaded & installed the program recommended by Godaddy: "MySQL GUI Tools".
It installed 4 apps:
MySQL Administrator
MySQL Migration Toolkit
MySQL Query Browser
MySQL System Tray Monitor
I ran the Administrator and it worked, but when I ran Query Browser, it asks for a DEFAULT_SCHEME
Is it necessary?
It installed 4 apps:
MySQL Administrator
MySQL Migration Toolkit
MySQL Query Browser
MySQL System Tray Monitor
I ran the Administrator and it worked, but when I ran Query Browser, it asks for a DEFAULT_SCHEME
Is it necessary?
ASKER
Just a note, I am connected to the MySql database in my hosting, I just want to know about the programs I mention above.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Three (3) last things related to the Tool I downloaded:
1. Every time I run MySQL Query Browser, it asks for DEFAULT_SCHEME, which I
click "Ignore. What is DEFAULT_SCHEME? What is it referring to?
2. To understand each item installed by the Too, can we say the follwing:
MySQL Administrator is the same as Microsoft SQL Entreprise or Studio?
MySQL Migration Toolkit is the same as Data Import/Export in Microsoft SQL Studio?
MySQL Query Browser is the same as Microsoft Query Analyzer or Studio Query?
MySQL System Tray Monitor is the same as Microsoft SQL Server of 2000 which has
to stay resident?
3. The four (4) items that was installed with the MySQL tool I installed:
MySQL Administrator, MySQL Migration Toolkit, MySQL Query Browser
and MySQL System Tray Monitor, do I have to have any of them running while
running the MySQL Query Browser or MySQL Administrator?
(I use Microsoft SQL 2000 & 2005 Studio and want to understand MySql)
1. Every time I run MySQL Query Browser, it asks for DEFAULT_SCHEME, which I
click "Ignore. What is DEFAULT_SCHEME? What is it referring to?
2. To understand each item installed by the Too, can we say the follwing:
MySQL Administrator is the same as Microsoft SQL Entreprise or Studio?
MySQL Migration Toolkit is the same as Data Import/Export in Microsoft SQL Studio?
MySQL Query Browser is the same as Microsoft Query Analyzer or Studio Query?
MySQL System Tray Monitor is the same as Microsoft SQL Server of 2000 which has
to stay resident?
3. The four (4) items that was installed with the MySQL tool I installed:
MySQL Administrator, MySQL Migration Toolkit, MySQL Query Browser
and MySQL System Tray Monitor, do I have to have any of them running while
running the MySQL Query Browser or MySQL Administrator?
(I use Microsoft SQL 2000 & 2005 Studio and want to understand MySql)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx
ASKER
Thanx
The client talks to the server via Ajax, where the server does your bidding (database CRUD) and returns the result.