Initial setup and configuration of MySQL on XP SP2

Posted on 2006-06-14
Last Modified: 2012-06-27

I'm having a devil of a time installing MySQL for the very first time so that it hooks into ODBC. I assume this is the way to do it if I'm ultimately trying to setup a data bind for Dreamweaver MX 04.

When I am in the ODBC config area, I see my recently installed MySQL ODBC driver 3.51.12. If I select that to add to ODBC stack, the config screen comes up, but when i try to add the database (which I had just created successfully in the Command window) I'm getting an error:

Request returned with SQL_ERROR

If I hit the Diagnostics button in the ui, it reads:

[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)


[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: YES)

I've tried it both ways with the only password I've indicated during initial setup of MySQL.

Can you tell I'm a total newb? Help!


Question by:billium99
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 19

Expert Comment

by:Kim Ryan
ID: 16908731
What is the username for your only password? It looks like MySQL expects an account to exist with user name of  ODBC.

Author Comment

ID: 16908748
Thanks - yeah I didn't give any user name during setup so I believe it defaulted to ODBC. I've tried with and without including this as my user name.

LVL 30

Accepted Solution

todd_farmer earned 500 total points
ID: 16908769
Try it with using "root" as your user name (leaving the password blank).
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Expert Comment

ID: 16908862
I would suggest that you create a new user for the connection.
Also with host '%'. The first root user is for localhost.So you won't be able to connect from another PC with root@localhost.

Author Comment

ID: 16908884
root as the user name did it! Now for some reason in Dreamweaver I'm still having an issue binding to this db instance, but I'll set that as another new question.



Author Comment

ID: 16908888
Thanks ZO3niE - would you say that the remote access issue is the only consequence to leaving the user name as root? If so, I won't worry about this for now, but I appreciate the advice.
LVL 30

Expert Comment

ID: 16908895
It is not the only consequence - the root account is a full-access account.  Leaving it with a blank password is not recommended, nor is using it for anything other than local development.  Probably OK for a dev box (although I would recommend changing it) - definately not secure for a publicly-accessible box.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
I want to echo out my field names with its values into a table 10 43
mysql database, schema and table creation 13 114
Currency in SQL? 2 51
WordPress  Failed to Import Media 8 64
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question