Jan 22 2010, 09:22 AM
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:
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
Jan 22 2010, 09:26 AM
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!
Jan 22 2010, 09:28 AM
You need to install MyODBC
Jan 22 2010, 10:02 AM
Thanks guys...too embarrassed to look to see if I read wrong what I needed to download :-)
Jan 22 2010, 10:20 AM
Don't feel so. I, myself, overlook important parts very often.
Jan 22 2010, 10:22 AM
FYI, ... There is a MySQL Forum here at UA. I can move this thread there if you want me to.
Jan 22 2010, 10:55 AM
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.
Jan 22 2010, 11:00 AM
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?
Jan 22 2010, 11:38 AM
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' 
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.
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?
Jan 22 2010, 11:44 AM
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)
Jan 22 2010, 12:07 PM
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.
All seems good. Round trip took just 36ms no packets lost on the way
Jan 22 2010, 12:09 PM
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
Jan 22 2010, 12:41 PM
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.
Jan 22 2010, 01:18 PM
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.
Jan 22 2010, 04:03 PM
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
Jan 22 2010, 04:07 PM
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?
Jan 22 2010, 04:13 PM
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
Jan 22 2010, 04:14 PM
I installed Essentials the whole caboodle
Jan 22 2010, 04:20 PM
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
Jan 22 2010, 04:21 PM
One more thing... did your partner say to use any other port? MySQL's default is 3306 but it could be changed...
Jan 22 2010, 04:33 PM
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
Jan 22 2010, 04:39 PM
Tried21 and it errors :
lost connection to MySql server at 'reading initial communication packet', system error 2
Jan 22 2010, 04:43 PM
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?
Jan 22 2010, 04:48 PM
Think you can ignore stuff under this line found this in phpAdmin info
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
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.
Jan 22 2010, 04:49 PM
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.
Jan 22 2010, 04:50 PM
Tons of other stuff too which I have no idea of....want me to look for anything in particular?
Jan 22 2010, 04:58 PM
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
Jan 22 2010, 05:01 PM
okay tried again but used the phpadmin password same issue.......error 10060
Jan 22 2010, 05:01 PM
could it be my antivirus. using avast!
Jan 22 2010, 05:05 PM
by the way 3306 is the port used
Jan 22 2010, 05:08 PM
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.
Jan 22 2010, 05:17 PM
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.
Jan 22 2010, 05:28 PM
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).
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here