help. how to config remote mysql db? - The MySQL Relational Database

Training, Open Source computer languages

Perl • PHP • Python • MySQL • Apache / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS

Home

Accessibility

For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))

help. how to config remote mysql db?

Posted by 4est (4est), 22 July 2003

hi,

ok, so i have my database, mySQL of course, running on my box through IIS. additionally i have the IP, db name, user id, pass, and DSN, that my ISP has assigned me. now i need to know how i can configure my db to meet these criteria ( the name, uid, pwd ) and how do i get the db onto their server? i tried just FTPing the ip with the uid & pass and got denied. maybe there is an online resource that somebody could point me to which covers this type of thing? any help would be greatly appreciated.

4est.

Posted by 4est (4est), 22 July 2003

sorry for the bother, i figured it out, but have another question, posted as a different topic. hope i am not being a nusance
4est.

Posted by admin (Graham Ellis), 22 July 2003

There could be lots of different things here. Questions to help me help you:
* Are you able to get just simple web pages up onto your ISP's machine?
* Can you ssh or telnet into your ISP?
* Can you run your local mysql client
-h123.123.122.121 -uwhoever -ppsswd
and connect in that way (if not, can you do so from a telnet or ssh session?)

[Edit - I was writing as you posted. Thanks for letting me know - I've left the answer up anyway, as you're not the first one to have this question]

This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

Public Training Courses

Running regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Other Forum Posts

resetting root account

creating relationships

extracting record based on time.

password only for a specific database

Select records from March

Variable length MYSQL result

MySQLand HTML

using php and mysql to provide a image library

spot the problem.....

Link tables from two data files

creating relation between tables?

Location of SQL files for submittion through...

A Really easy project, but need help

Image Library - Upload works but image missing?

how to build forum

MYSQL and APACHE on local computer

Using PHP and MySQL to provide an image library

Data truncated for column 'sale_price' at row 1

PHP script, mysqli functions update a record

THREE WAY JOINS with subqueries & groups

Edit Script not working

Looking for a PHP/MySQL programmer to work with

a comma

4 characters in mysql

How to Rename database

2003 Error cannot connect to MySQL on Win XP Home

accessing a mysql server version 4.1.16

Regular Automatic backups of a database.

MySQL  question

select where statement

Joining a table to itself

Programmatically or SQLlly?

using the right tools?

mysql_fetch_array(): argument is not a valid

Images in MySQL

How to get rid of duplicate data??

Upgrade to MySQL 5.0 - PHP,QT,Python Libs

Problem Inserting Data into Table

Moved: Email Notification

Batch Processing ?

Aliases in Update

Query A Different Database?

Linking Tables Foreign key

Multiple users and data integrity

LEFT JOIN

Finding the key of a row just added

Upgrading to MySQL 4.1 - a caution

Using foreign Keys

MySQL Resources

Holding config data in a table

MySQL as Case Sensitive

count even or odd objects

SQL Injection Attacks

MyIsam or InnoDB with small database

Mysql installation & configuration

Mirror database - low bandwidth

only 1000 records in mysql

Database Modelling in UML

Long character string in a WHERE clause filter?

Advantages and disvantages of MySQL

Mysql Full-Text Search

Using ASP with MySQL

Moved: Looking for a script in PHP

mysqldump and deleting table contents

SQL_BUFFER_RESULT

limit table to 1 record

insert into using result of a select

insert and select datetime in GMT timezone

Update syntax

Copying a table structure

Error 1148

MySQL / Java / PreparedStatement Quoting

Limiting number of rows in table

Transform / Pivot tables?

My root account is messed up - what can I do?

Mysql Regex question

Loading a table from data in a text file

Producing a list of names

mySQL over a Beowulf cluster

mysql dump into a text file

Starting mysqld on boot - OSX

making mysql secure

Changing column values

MySQL query to a text file

how to load text file into largetext field?

On limiting selection

loop problem

How does this work?

store file names or store files themselves?

is there any way to do this?

Creating a table with MySQL

Invoking MySQL from the C:\> Promt in Windows 2000

Foreign Keys - steps to enable

Error upon Attempt to Connect

Entering foreign keys into main table

User enetering data into MySQL - 2 tables

MySQL/localhost problems

Does a table exist? Oracle and MySQL check

write to db

web based table editing

timestamp name

linking tables???

convert php / mysql page to html

Data becoming corrupted

cannot connect to the db via an ASP page

error message

MYSQL + tool to build report's

Cannot connect to server

Joining tables

Views, triggers etc in MySQL?

jbuilder8 and mysql need help badly

error message...don't know why

what database should I use?

Microsoft Excel to Mysql

mysql tables on raw partition

How to write an INNER JOIN QUERY in Mysql

Char, Varchar or Text?

date comparisons in sql

Subtraction one set from anothe set in MySQL

How to write this query

Different versions and importing a text file

Tcp port v named socket / Multiple mysqld servers

The Dolphin gets a name!

Finding out about columns

Import Data from MS Access

Are MySQL enquiries case sensitive?

soundex clause

Printed Reference manual

What is MySQL-MAX?

Try out your MySQL ...

© WELL HOUSE CONSULTANTS LTD., 2024: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho