delphi10 mysql_DELPHI10.2的LINUX数据库开发环境配置

DELPHI10.2的LINUX数据库开发环境配置

ubuntu使用firedac访问mysql

1.安装mysql-client包

sudo apt-get install mysql-client

mysql-client-5.7

mysql-client-core-5.7

2.建立libmysqlclient.so关联

cd /usr/lib/x86_64-linu-gnu

sudo ln libmysqlclient.so.20.3.4 libmysqlclient.so

sudo ldconfig -v

-----------------------------------------------------

centos7已安装好mysql-client-5.7

cd /usr/lib64/mysql

ln -s libmysqlclient.so.20.3.4 libmysqlclient.so

cd /etc/ld.so.conf.d

vi mysql-x86_64.conf 加入/usr/lib64/mysql

ldconfig -v

-----------------------------------------------------

解决MYSQL中文乱码的问题

LINUX当前字符集设置为UTF8

FDConnection.Params.CharacterSet=ctUtf8