I found this link http://www.ehow.com/how_2072063_open-mysql...-ms-access.html and have installed MySql and think I have that set up correctly.

I have followed the steps to 5 and have come unstuck. Step 5 says"In the Create New Data Source dialogue box select MyODBC driver and click finish." I do not see "MyODBC" driver listed. Can anyone explain why this might be and how I go about setting up "MyODBC". All I have are:

dBASE Files
Excel Files
MS Access Database

When I click add I do not find a "MyODBC" the closest I find is Oracle ODBC and Sql Server neither of which look like what the tut on the site looks like.


What I am trying to do is use Access to access my MySql database for my websites.

I have MSAccess 2003

Any advice pointers will be cheerfully appreciated

Alan

You are supposed to download and install MyODBC driver. MySQL has it at their website.

http://dev.mysql.com/downloads/connector/odbc/

More info here:
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc.html

In Configuration and "Notes & Tips", they talk about configuring the driver for MS Access. Be sure to read them as well.

Best of luck!

You need to install MyODBC first.

Thanks guys...too embarrassed to look to see if I read wrong what I needed to download :-)

Don't feel so. I, myself, overlook important parts very often.

Cheers!

FYI, ... There is a MySQL Forum here at UA. I can move this thread there if you want me to.

much appreciated....I am stuck trying to fill in the connector dialog......Cant work out what to write in Server: and Database:

All my Tests - bleep me.

Well those two settings depends on how you are connecting and from where.

If the MySQL database is on the same computer you're logged in to right, put down 'localhost' for the server. Database is just the name of the database you want to open... So if your database is named "MyCoolDatabase" put this down as for the Database.

Did that help?

Okay...sorry for not explaining more.

DB is remote on our website. I have tried both the IP and url without www and have the correct user name and password.

I have searched and found some advice and have whitelisted port 3306 in my Windows firewall.

I am using version 5.1.6 I watched a utube tut using 3.5? but is basically the same....I am not connecting because no database is shown in the combo box. Test just comes up with

connection failed [HY000] [MySQL][ODBC 5.1 Driver]Cant connect to MySql server on 'my url' [10060]

I googled the error number where I found help about firewall etc.

database is atlantis phpmyadmin

I dont play with this stuff so I know so little.

Alan

PS Found this but not sure if it safe

Go to PhpMyAdmin. Go to database. Go to priveleges. Click the authorized user. Change the choice of access from Localhost to Anyhost or '%'. Can help?

Let's do first things first.

We need to verify you actually can reach the MySQL.

Can you ping the MySQL's host?

Are you sure you are authorized to access the host? (e.g. sometime they require you to use a VPN or log in remotely for example)

Good idea...so how do I ping the MySql host.

I have access to the host as it's my website and I have admin access....in fact I have been exporting the tables that I now have discovered I can access with Access....very cool to be able to do that I must say :-)

Off to Google how to ping my host.....sounds painful.

Pinged.

All seems good. Round trip took just 36ms no packets lost on the way

Download MySQL client, (I don't think Windows has a seaprate package but you can choose "Express installation" and somewhere in the installation, choose MySQL Client only. Open the MySQL client and give this command:

mysql -h myURL -u myUserName -p

Googled MySQL Client and they are all for purchase which I dont think is what you are telling me to get. Will this do the trick http://dev.mysql.com/downloads/gui-tools/5.0.html


How do you get the East closer to the West? .....

Can I leave that for later......head is already fit to burst.

Sorry to be such a noob with this.

As I said, you have to download the server itself to get the client- you can choose to not install server and just the client.

http://dev.mysql.com/downloads/mysql/#downloads

Look for "essentials" (it's in a small print under the heading "Windows x86...")

Well, yeah, you can use GUI tool if you prefer. When you download it, you'll need to set up it for Server Administration but that means you need to configure it as well.

Okay all installed.

I have not checked - Enable root access from remote computers. There is a setting for that in the wizard...I left it alone...dont know what it means :-)

Everything seems okay. Service is started and all the checks on install/finish were ticked/confirmed.

As a matter of interest I had this all installed previously but the service would not start. I uninstalled and reinstalled now and this time the service started. Previously I had to go to Admin-Services and start manually.

I have tried again to set up the connection but still the database does not populate in the database combo of the dialog box of the connector. Test results in the same error 10060.

I switched off my Windows firewall - no luck.
I know the user and password is correct because I can login at the database via the browser perfectly.

Is there perhaps some service or other issue that I need to check wrt my Windows install....it's not out of the ordinary in any way...just the basic XP PRO set up.

I take it that the user and password in the dialog is the same for when I connect to phpMyAdmin via my browser.


I did not reboot.....no need as far as I can tell

Just to be clear... what was actually installed? It sounds like you actually installed MySQL Server? Or maybe GUI?

No need to reboot.

Do you know if your phpMyAdmin uses SSL?

I installed MySQL Server. Apparently phpMyAdmin does not use SSL...my partner knows more than me on that side and she says no..... :-)

Had a look at the phpMyAdmin home page and dont see anything that says SSL

I installed Essentials the whole caboodle

Okay, I said to install client only, not everything, but what's done is done.

So, when you open up the MySQL Client (you can do this by opening a Command Prompt, and entering the command I gave earlier), you get the same error?

mysql -h myURL -u myUserName -p


If this fails, what does this say? (again, on the command prompt)

mysqladmin ping -h myURL -u myUserName -p

?

One more thing... did your partner say to use any other port? MySQL's default is 3306 but it could be changed...

Sorry :-(


mysql -h myURL -u myUserName -p results in "->"

I replaced myUrl with the Url http://etc and -u username and -p passsword

mysqladmin ping -h myURL -u myUserName -p

results in the same thing
->

and if I hit enter I just get more
->

does the -> mean I have connected via the command line?

As far as the port is concerned I remember seeing something that said port 21 but I cant find the reference to that anywhere at the moment. I will try port 21 anyway

Tried21 and it errors :
lost connection to MySql server at 'reading initial communication packet', system error 2

That's for telnet, and I seriously doubt MySQL DBA would use that. If you're not sure, you should find out what is the correct port. Does phpMyAdmin tell you that?

Think you can ignore stuff under this line found this in phpAdmin info
port 3,306
-----------------------


searched google to find port info and found this on a forum

does phpmyadmin have a specific port so that admins on my site can login to an SQL database without needing to login to cpanel
? thanks.

reply..

As far as I know phpmyadmin does not have a specific port that you can use. I think it always requires you to login to cpanel because whenever my browser annoyingly closes, it never loads unless I retype in my login information.

So sorry about the frustration. I think you need to change directory because the bin programs aren't in the PATH.

I've attached a screenshot of what a successful connection will look like. Change to the same directory and see if this works for you.

Tons of other stuff too which I have no idea of....want me to look for anything in particular?

Okay...tried as you said using correct path and used the IP and was asked for password (I assume it is the one for the MySQL install and NOT the phpMyAdmin one) and got a cant connect error on my IP which I know is correct because I checked on the net

okay tried again but used the phpadmin password same issue.......error 10060

could it be my antivirus. using avast!

by the way 3306 is the port used

No, use phpMyAdmin one.

The MysQL install is a new MySQL database sitting on your computer but you didn't want a server on your desktop- you wanted to connect to an existing MySQL database from where you have been accessing via phpMyAdmin.

okay...tried with the phpadmin password same result....no go. Just to see I put the IP into the browser address bar and I can go straight in once I have logged in so I know the IP is fine.

I dont get it...why cant my PC connect...is it my router maybe. Some issue there. I have used Filezilla and wotnot for uploading etc...no problem.

Going to hang on for your last reply to this and then I must go to bed...it's 1030pm and I have been working at this and related stuff since 730am

Thanks so much for your patience - I really do appreciate it.

:-)

Last thing and I think I am talking nonsense here. When I installed MySqL - whole caboodle it asks for a password which I entered. That password is different to the phpMyAdmin password.

I assume that does not matter because the password I entered on install is simply for the local side of things right? And has nothing to do with remote side?

In any event I have redone the instance and now I have the same password plus I have added the windows path to the C: prompt and allowed Root/Remote issue (cant remember exact text).