What are the requirements for MYSQL / mydac on OS X

I am testing and can run a simple database app on windows.

I have compiled to OSX and get 'cannot connect to mysql server on XXXX'.

I have install mysql server on the mac (hoping this installed the necessary bits and pieces).

Is there some equivalent of dlls I have to add?

Thanks....
0
Ste
1/27/2015 5:13:17 PM
embarcadero.delphi.database 1294 articles. 0 followers. Follow

8 Replies
1381 Views

Similar Articles

[PageSpeed] 21
Get it on Google Play
Get it on Apple App Store

What I suggest you do is use whatever tools MySQL gives you on your Mac 
for connectivity. Most likely, those tools will result in the same 
error. Get it working there, and it should work in the Delphi the same.

Ste War wrote:
> I am testing and can run a simple database app on windows.
>
> I have compiled to OSX and get 'cannot connect to mysql server on XXXX'.
>
> I have install mysql server on the mac (hoping this installed the necessary bits and pieces).
>
> Is there some equivalent of dlls I have to add?
>
> Thanks....
>
0
quinn
1/27/2015 1:01:01 AM
I ran terminal and used :

telnet www.xxxx.com 3306

and the connection failed.

I then tried

telnet http://www.xxxx.com 3306

I got a connection.

So I tried adding http:// to the server string in Delphi but when I connect I get unknown host error code 11004($2AFC)

I also tried add the string at runtime but got the same error.
0
France
1/27/2015 1:01:01 AM
I ran terminal and used :

telnet www.xxxx.com 3306

and get the connection

Edited by: France English on Jan 27, 2015 3:36 PM
0
France
1/27/2015 1:01:01 AM
That's not the same thing. You need to use tools from MySQL to connect 
to the database. On Windows, I use the MySQL command line tool. All 
telnet does is connect to the port. If you have the wrong user name, or 
password, or database name, or a pathing problem or the server is not 
running, telnet will find none of this.

France English wrote:
> I ran terminal and used :
>
> telnet www.xxxx.com 3306
>
> and get the connection
>
> Edited by: France English on Jan 27, 2015 3:36 PM
>
0
quinn
1/27/2015 1:01:01 AM
> {quote:title=Ste War wrote:}{quote}
> I am testing and can run a simple database app on windows.
> 
> I have compiled to OSX and get 'cannot connect to mysql server on XXXX'.
> 
> I have install mysql server on the mac (hoping this installed the necessary bits and pieces).
> 
> Is there some equivalent of dlls I have to add?
> 
> Thanks....

http://margotskapacs.com/2013/01/installing-mysql-on-mac/
0
Viktor
1/28/2015 1:01:01 AM
> {quote:title=France English wrote:}{quote}
> I ran terminal and used :
> 
> telnet www.xxxx.com 3306
> 
> and get the connection
If you want direct connection then you can use devart's MyDAC (or UniDAC). Then you will not need MySQL client library.

Best regards,
Cristian Peta
0
Cristian
1/28/2015 1:01:01 AM
I am trying to connect to a remote mysql database from a mac not mysql on the local machine.

I installed mysql server in the hope it cured the problem I am having.


The TMyConnection.Options.Direct property is True

I have 3 different macs.
None of them have firewall switched on.
None have antivirus.

I am able to use SequelPro ( mysql database management ) on each machine.

I can connect to all my databases with this okay.

Is there anyway I can trace where its failing?
0
France
1/29/2015 1:01:01 AM
> {quote:title=France English wrote:}{quote}
> The TMyConnection.Options.Direct property is True
If you are using devart's MyDAC then why not trying to ask on their forum. Usually you will have a response in less than a working day.

Best regards,
Cristian Peta
0
Cristian
1/29/2015 1:01:01 AM
Reply:

Similar Artilces:

Bugzilla having problem connecting to MySQL database on Mac OS X Lion
Hi, I'm trying to install Bugzilla 4.0.1 on Mac OS X Lion. I've managed to install all necessary and most optional Perl modules. When I run the checksetup.pl script, I get the following error: There was an error connecting to MySQL: install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted. Compilation failed in require at (eval 1296) line 3, <DATA> line 522. at Bugzilla/DB.pm line 1154 This might have several reasons: * MySQL is not running. * MySQL is running, but there is a problem either in the server configuration or the database access r...

DBD::mysql bad auto/DBD/mysql/mysql.bundle file on OS X
Howdy group :) Having a bit of trouble getting DBD::mysql installed on OS X I get this error: root# perl -e 'use DBD::mysql;' Can't load '/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle(2): Not a recognisable object file at -e line 1 Compilation failed in require at -e line 1. BEGIN failed--compilation aborted at -e line 1. root# Here is what is in the directory: root# ls /Library/Perl/5.8.1/darwin-thread-multi-2level/au...

How to attach a MySql database to a MySql database server.
Hi all, I have developed a web application in VS 2005, and it uses MySql 4.1 as database. Now, I have created the database and tables, and there is data in it. How can I copy this same database along with its tables and contents, to another server? Which all files should I copy? Is there any procedure to 'attach' a database? I use MySql  Manager to create databases and tables. Thanks Tomy Hi The best way to make a dump of your existsing MySql database is to use mysqldump utility which comes with any mysql server package. Here is a sample usage: "C:\Program File...

Difference between Firebird OS X and Camino OS X
Not a wish list, but I was just wondering what the difference between these two programs were. Everyone is raving about firebird and since it is a fast stand-alone browser than what is the point of Camino which is also stated as a Fast Mac OS X browser. ALso what are the plans for Camino in the future? Abtin Shakouri wrote: > Not a wish list, but I was just wondering what the difference between > these two programs were. Everyone is raving about firebird and since it > is a fast stand-alone browser than what is the point of Camino which is > also stated as a Fast...

Create a MySQL database from another MySQL database or Backup
I'm starting on a new ASP.NET project using MySQL as backend. While I'm familiar with SQL2k, I'm totally new in MySQL. Here's my questions: 1) Given a Web Server for installing the MySQL database, what do I need to start off? MyODBC and/or some other mySQL connector or console? I read tutorial mention Telnet or Shell access. What's that? I know how to create a FTP database in SQL2k. How's that done in MySQL? 2) Also given a backup of a MySQL database as data source and a remote MySQL database the backup was made from, what are the technical steps to create my first MySQL dat...

Backup a MySQL database from Delphi
Is there an easy way to backup/restore a MySQL tables from my Delphi application. The database is hosted by my Web host. To remotely connect to my MySQL database, I use ADO (dbGo tab) components. My tables use MyISAM. Can I use mysqldump or mysqlhotcopy from Delphi via ADO? BTW, I use Delphi 2009. > Can I use mysqldump or mysqlhotcopy from Delphi via ADO? mysqldump does not need any additional connectivity layer, like ADO, ODBC or what else. mysqldump uses TCP/IP to connect to MySQL server. So, all what you need: - mysqldump of the your MySQL server version; - run mysqldum...

Delphi on Mac OS X
Hello, Are there plans to extend Delphi to run on other OS's like Mac OS X, Ubuntu and Solaris ? Mac OS X is booming business. You can read it everyday in the newspapers and on internet. Because Delphi is not available for the Mac, I have to use NetBeans with MySQL. When I give demonstrations on the Mac and ask then when it was the last time that they want to throw the PC out of the window, people are easy to be persuaded to buy a Mac. It is a pity that I still have to use Windows. I have been developing software for 20 years on MS-DOS/Windows systems and still have r...

DBD::mysql OS X
------=_Part_5735_8090040.1154614921559 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, Has someone manage to install DBD::mysql in Mac X Tiger. Can anyone point me to a tutorial or how to do this. Thanks ------=_Part_5735_8090040.1154614921559-- YWFhYW5kIGFnYWluIHdpdGggdGhlIHJlcGx5LXRvLgoKLS0tLS0tLS0tLSBGb3J3YXJkZWQgbWVz c2FnZSAtLS0tLS0tLS0tCkZyb206IEpheSBTYXZhZ2UgPGRhZ2dlcnF1aWxsQGdtYWlsLmNvbT4K RGF0ZTogQXVnIDMsIDIwMDYgMTA6NDAgQU0KU3ViamVjdDogUmU6IERCRDo6bXlzcWwgT1MgWApU bzogV2FsdGVyIENvcGVu...

Delphi on Mac OS X
Hello, In the closing keynotes of Coderage III, Wayne Williams told that Embarcadero has plans to port Delphi to Mac OS X and Linux. How far are these plans and realisations ? I see on internet that a lot of Delphi developers want to use Delphi on the Mac: http://www.petitiononline.com/bdfmosx/petition.html More and more companies are moving to Mac OS X: e.g. http://www.macnn.com/articles/09/02/23/siemens.nx.6.for.mac/ Hubert On Wed, 25 Feb 2009 00:47:47 -0800, Hubert Anemaat wrote: > In the closing keynotes of Coderage III, Wayne Williams told that > Embarcader...

MySql connect on Mac OS X
I'm testing Delphi XE2 on a little app that I wrote to see if I can connect to a MySql database on MAC OS X. I know that I must put libsqladapter.dylib and libsqlmys.dylib (the TSqlConnection.DriverName) on the path. I think that the TSqlConnection.VendorLib must be set to libmysqlclient.dylib. Is this right? With this done, when I try to connect I get the message: First chance exception at $00016870. Exception class TDBXError with message 'DBX Error: Driver could not be properly initialized. Client library may be missing, not installed properly, of the wrong version, or the d...

Delphi 2011
I am curious about the new Delphi, which compiles for OS X. I know it is too early for more then rumors, but I have some questions. We are making plans and we want our application to run on a Mac. Can Delphi 2011 compile for a Mac? Can we cross compile our current project or do we have to change all visual components (like VCL vs CLX)? Is the Virtual Treeview supported? And Synapse? Thanks, Alex Alex Habbo wrote: > Can > Delphi 2011 compile for a Mac? <being helpful as usual> Nope, only OS X, I'm afraid. </being helpful as usual> > {quote:title=Alex...

Delphi running directly in to Mac OS X?
Hello: Have Embarcadero provided to make an Delphi/RAD Studio version for run directly in Mac OS X?. We have millions of users of Mac, and in last year much more because innefective Windows 8 has meant that Mac sales soar. I have virtual machine on my Macbook with an Windows XP copy with Delphi XE5, but battery runs out quickly, heated laptop and is not the same as naturally programmed in Mac OS X environment native. I would be very happy if Embarcadero launched a version of RAD for mac. Anyone know anything?. Thanks!! XE5 can create OSX applications no problem (using firemon...

mysql database, delphi 2010 and connection charset
Hi. I want to write an application which will use a MySQL database. I made a basci connection and queries. Everything is ok, except viewing data from database on a website generated with php. I'm polish and using my national letters and this is problem. When i add text into database in my app written in delphi and then view it in app, everything is ok, national letter are correct. But, when i want to view this data on a website i see strange things where were national letters. Fields in database are defined i n UTF-8, website uses UTF too. I can see on website data added from delphi on...

How to convert the database in a mysql database ???
I need help, i want to put asp.net portal to a mysql data base Good luck! Since the Data MAnipulation Layer is written in Stored Procedures, you will have to rewrite all of it. It probably would not be very time effective in my opinion. Well, maybe it won't be that bad. Looks like someone is already doing it. Check out their forum for more upates. http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=482434...

Web resources about - What are the requirements for MYSQL / mydac on OS X - embarcadero.delphi.database

Visa requirements for Swedish citizens - Wikipedia, the free encyclopedia
Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc. , a non-profit organization.

Facebook Adds Requirements For Submissions Of Apps, Open Graph Actions
Facebook announced three new requirements for developers submitting applications and Open Graph actions for approval. continued… New Career ...

Facebook platform update: ad image policy, age requirements, developer alerts
... followed or enforced. We’ve heard Facebook is developing a grid-based text overlay detection tool to identify non-compliant images. Age Requirements ...

YouTube - How to Define Agile Requirements
Veröffentlicht am 07.09.2012 Although understanding and defining user requirements is fundamental to delivering successful agile projects, this ...

Hillary Clinton's personal requirements for speech raise eyebrows
It was a list of requirements worthy of a Hollywood diva, from the temperature of the water in the carafe, to the shape of the chair cushions ...

China unlikely to cut bank reserve requirements: report
Central bank statement hints cut to reserve requirement ratio is not imminent.

Push for relaxation of workplace gender requirements
The federal government will face fresh calls to water down planned new gender equality rules for medium-sized businesses.

"Hammered asinine requirements": Now there’s a secure password
You’re best off forgetting your grammar lessons when it comes to creating passphrases, according to new research out of Carnegie Mellon University ...

OSFI moves to raise bank's capital requirements for residential mortgages
Canada's top financial regulator wants to update the rules that govern how much capital lenders must hold to offset the risk that the residential ...

Associate Bonus Watch: Without A Billable Hours Requirement, All Associates At This Firm Got Bonuses
This firm eliminated billable-hours requirements from its bonus eligibility standards, and associates seem happy with their bonuses.

Resources last updated: 12/27/2015 4:23:55 PM