Creating a MySQL database

[Philip Gilson]

I have tried to do what SHOULD be the simplest of all things and create a blank database for use with phpbb version 3 on my web site.

I have installed version 5.1 of ODBC from the official site.

I have tried using such program titles as Bullzip's MS Access to MySQL converter.
I have also tried using a program called 'SQL Maestro for MySQL' by SQL Maestro Group.

However After entering the settings as I expect them to be, I get the following errors:

ERROR I GET IN MS ACCESS TO MYSQL

SETTINGS
--------
Moving data directly to MySQL server

TABLES
------------
Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Extended Properties="SERVER=www.eaglewing.oxyhost.com;UID=########;PWD=########;PORT=3306;OPTION=0;STMT=;"
Program Version: 3.0.0.108
ODBC Version: 5.1.5.0
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.1 Driver]Access denied for user '#########'@'cpc1-with1-0-0-cust346.bagu.cable.ntl.com' (using password: YES)

-----------------------------------

ERROR I GET IN SQL MAESTRO

SQL Error: Access denied for user '#########'@'cpc1-with1-0-0-cust346.bagu.cable.ntl.com' (using password: YES)

-----------------------------------


The errors seem to be pointing to the same thing as the endind text is the same.
Note I have inserted the #'s for security reasons.

Should I be entering the username and password that I use to logon to my ftp site?

Many thanks.



My web site is on an external server run by oxyhost.com