[SOLVED]Lazarus1.0 and MySQL

[guest48180]

I have Mint 13 Cinnamon installed. I downloaded mysql5.1 and tried to install it (debian file) and it gives me an error
dependency. The thing is, I've never installed MySQL on this OS before. I do see where it has some MySQL files...so how
do I get rid of them to install the MySQL 5.1? Lazarus only goes up to MySQL 5.1 and I can't work with dbs with the 5.5,
which is so readily available? Growing frustrated in Dallas. Please help this Texan and I'll give ya an oil well 

Or is there an easier db to use with Lazarus 1.0?

[Leledumbo]

I downloaded mysql5.1 and tried to install it (debian file) and it gives me an error dependency. The thing is, I've never installed MySQL on this OS before. I do see where it has some MySQL files...so how do I get rid of them to install the MySQL 5.1?

Mint is based on Ubuntu, so you can use Ubuntu method for this (synaptic, apt-get, whatever).

Lazarus only goes up to MySQL 5.1 and I can't work with dbs with the 5.5, which is so readily available?

Depends on your version, mine (trunk about a week ago) got 5.5 component available and AFAIK 6.0 is also ready.

[marcov]

There are several threads about mysql and its incompatibilities on the forum. The end conclusion is often simply to avoid mysql if you can, or be conservative with versions.

We can't release a new binding till we know it is compatible, and we only release once in a while. 2.6.2 will have mysql 5.5 connection

[BigChimp]

Or is there an easier db to use with Lazarus 1.0?

I'd look into Firebird (my personal choice) or PostgreSQL.
Firebird: can be embedded as well (file-based, no need to install a server)
PostgreSQL: very well-known/used database. Good documentation.
Both are fine databases with complete SQL support, much more permissive licenses than MySQL as well as more stable drivers.

[Leledumbo]

I'd look into Firebird (my personal choice) or PostgreSQL.
Firebird: can be embedded as well (file-based, no need to install a server)
PostgreSQL: very well-known/used database. Good documentation.
Both are fine databases with complete SQL support, much more permissive licenses than MySQL as well as more stable drivers.

For small amount of data (<10000) I'll pick SQLite3 which is file-based, embeddable and requires no server at all.

[reneve59]

If you have not solved your problem yet, I have applications developed using Lazarus 1.0.2, FPC 2.6.0, and ZeosLib 7.0 that access a remote MySQL 5.5 database without problems.

Also installed MySQL 5.x on Linux (Fedora 17, Linux Mint 13, Centos 5.8, Centos 6.2) and Windows 7 without problems.

What kind of dependency error are you getting when installing MySQL?

Regards