MYSQLCONNECTION fails on My SQL 5.2.38

After Installing My SQL 5.2.38 , I could connect to using the BDE OBDC components. I tried many times to connect to it via the Data explorer Server Name , Database name, User name and password . For the Server Name I used the name of the Server Instance on the Server Administration Local MySQL55. When I tested the connection I got a message back Borland.Data.TDBXError: DBX Error:  Driver could not be properly initialized.  Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path.

Is this a typical problem with the connection components and My SQL 5.2.38, or Im doing something completely wrong?

Thanks,
Mike
miker454Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
MySQL Workbench 5.2.38 and Delphi / Borland are not directly connected.  To connect to MySQL, you need a user with the appropriate connection privileges defined.  http://dev.mysql.com/doc/refman/5.5/en/adding-users.html   And here is the link to the ODBC connector: http://dev.mysql.com/downloads/connector/odbc/
0
miker454Author Commented:
I actually used the MySQL workbench that is a visual interface for windows and set up a connection with a connection name , Hostname, port, Username, and password. As well as Server instances that indentifies the directory where the data is to be stored.
I could not connect to the My SQL using the data explorer and MYSQL.

Thanks,
Mike
0
Dave BaldwinFixer of ProblemsCommented:
Have you installed the MySQL ODBC connector?  That must be installed.  Here is some info on BDE ODBC with MySQL/ODBC: http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-usagenotes-apptips.html
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

miker454Author Commented:
On the Windows 2008 server I can actually run the  MySQL ODBC 5.1 driver connector fill in the Data Source Name, User, TCI/IP Server, port 3306, password, and the database and it works fine. I test it and it is succesfull. On the client (windows 7 computer) I fill the same names and ports and it fails to even see the databases and it gives connection error when we test the connection. Connection Failed: [HY000][MySQL][ODBC 5.1 DRIVER]Can't connect to MySQL server on 'localhost' (10061) . Is there some details in the details tabs that needs to filled in for the client machine that I'm overlooking? I disabled the firewall on both the client and server. Not sure what else to do.


Thanks,
Mike
0
Dave BaldwinFixer of ProblemsCommented:
Since your original user was set up for 'localhost', that won't work from another machine.  You probably need to create another MySQL user with the same username and password but with the 'anyhost' connection option.  See the link above about adding users.  Adding the user also includes adding the type of connection that is allowed and you have to make sure that user has permissions on the database also.
0
miker454Author Commented:
Thanks for the help Dave. I've set up My SQL server on both the local computer and the server computer. It took me while , but with the help of few on here I have set up an ODBC for both Databases (the local and the MSQLserver on the server) .  I can use the ODBC with the BDE, but I would like to use DBExpress  Data Explorer since they it is 64 bit. Using the Data Explorer to first try to connect to the MySQL in the local computer, I filled in the the Data Explorer:
Server Name: localhost
Database Name: mysql
User Name : root
Password :*******  
After clicking the test connection I get this message :
Borland.Data.TDBXError: DBX Error:  Driver could not be properly initialized.  Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path.

The Localhost database is active and root is the User name on the Database instance. I figure if I cannect to the local database first, I can then connect to the database on the server computer later (deal with other issues like the firewall). I'm assuming the db Express connects to the database instance directly and does not have to go through the BDE.
Thanks,
Mike
0
Dave BaldwinFixer of ProblemsCommented:
First, you should never use 'root' for anything other than administrative purposes on MySQL.  'root' has permissions on ALL databases to do ALL things... including deleting everything.

So did you install the 64-bit version of MySQL ODBC Connector on the 64-bit machine?  I don't know what "DBExpress  Data Explorer" is but I do know that you have to have a MySQL connector to work with MySQL databases.  You might want to read this page: http://stackoverflow.com/questions/5765424/how-to-access-databases-from-within-delphi-xe-professional-ide

Frankly, it would have been simpler to create an appropriate user on the other database.  Unless you're using 'root' there too in which case you should not create a 'root' user with external access.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
miker454Author Commented:
Hi Dave appreciate all your advice. The problem was finally solved when I downloaded the libmysql.dll and put it delphi program directory. I followed the advice in this article http://wiltonsoftware.com/posts/view/getting-embarcadero-dbexpress-mysql-working-dbx-error-driver-not-initialized . It pretty much solved the problem. Appreciate all your great advice.

Thanks,
Mike
0
Dave BaldwinFixer of ProblemsCommented:
Good find, glad you got it working.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.