RE: MySQL Migration Toolkit
"Mike Lischke" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Organization | MySQL AB |
| Message-ID | <[email protected]> |
Hi Audrey, > I am trying to migrate my Access Database to my sbc yahoo web > server, which uses MySQL and referred me to your site. I can > connect to the Access database on my local computer fine, > however, I have been trying for two days to connect to the > database on the web server. What am I doing wrong? Please help. In order to remotely connect to a MySQL server it must be configured so that external access is allowed. Many providers do not allow such remote connection so the first thing you should do is to ask Yahoo support about external database access. In addition you must grant a user the right for remote connection (and use that user for remote connections, of course). Read the MySQL docs for the details (http://dev.mysql.com/doc/mysql/en/index.html). You need either shell access to your web server (SSH) or have a special management software installed there (usually phpMySQLAdmin). Mike -- Mike Lischke, Software Engineer GUI MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]