您尚未登录。

楼主 #1 2018-12-12 22:23:23

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

关于arm开发板远程访问mysql数据库

请问具有wifi模块的licheepi,想要进行远程访问pc上的mysql数据库,需要在licheepi上也移植mysql数据库吗?还是直接就可以访问?

离线

#2 2018-12-12 22:30:27

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

只要在zero上面跑 mysqlclient 就可以了





离线

#3 2018-12-12 22:33:10

cityf
会员
注册时间: 2017-11-03
已发帖子: 195
积分: 195

Re: 关于arm开发板远程访问mysql数据库

晕哥 说:

只要在zero上面跑 mysqlclient 就可以了

这样确实可行, 但是不是最优解, 不适合在 嵌入式上面直接操作数据库,那样一点安全性都没有,

最好的办法是做一个应用服务器(网页服务器),

通过 https 鉴权机制登录,发送相应命令,借道网页服务器操作数据库。

离线

楼主 #4 2018-12-12 22:37:23

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

Re: 关于arm开发板远程访问mysql数据库

晕哥 说:

只要在zero上面跑 mysqlclient 就可以了

编译出arm架构的mysql 然后把里面的mysql-client放在licheepi上使用?网上没找到移植mysqlclient的教程..

离线

#5 2018-12-12 22:43:26

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

605364021 说:
晕哥 说:

只要在zero上面跑 mysqlclient 就可以了

编译出arm架构的mysql 然后把里面的mysql-client放在licheepi上使用?网上没找到移植mysqlclient的教程..

灰常简单,用 buildroot: https://whycan.cn/t_561.html





离线

楼主 #6 2018-12-12 22:53:50

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

Re: 关于arm开发板远程访问mysql数据库

晕哥 说:
605364021 说:
晕哥 说:

只要在zero上面跑 mysqlclient 就可以了

编译出arm架构的mysql 然后把里面的mysql-client放在licheepi上使用?网上没找到移植mysqlclient的教程..

灰常简单,用 buildroot: https://whycan.cn/t_561.html

buildroot中mysql-client在的部分是Legacy options removed in 2014.02
这个还能用吗?

离线

#7 2018-12-12 23:03:42

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

https://git.busybox.net/buildroot/commit/?id=06c8212866389948d7ad80573ea0c3faa7411a9c


MySQL client package has been renamed to MySQL.


可能是改名,而不是删除,具体明天我用buildroot试一试。





离线

楼主 #8 2018-12-12 23:07:17

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

Re: 关于arm开发板远程访问mysql数据库

晕哥 说:

https://git.busybox.net/buildroot/commit/?id=06c8212866389948d7ad80573ea0c3faa7411a9c


MySQL client package has been renamed to MySQL.


可能是改名,而不是删除,具体明天我用buildroot试一试。

在bulidroot里面的名字是MySQL client package has been renamed to MySQL. 它在的分支是Legacy options removed in 2014.02,我试一下看能不能用

离线

楼主 #9 2018-12-13 10:34:07

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

Re: 关于arm开发板远程访问mysql数据库

我试了下buildroot中的mysql_client好像是不能用的,修改为yes后buildroot就无法编译了!晕哥你的会这样吗?

离线

#10 2018-12-13 11:19:07

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

确实会出现 :

root@ubuntu:/opt/buildroot-2018.08.2# make
Makefile.legacy:9: *** "You have legacy configuration in your .config! Please check your configuration.".  Stop.

然后就没有然后了

但是把 BR2_LEGACY 屏蔽起来又可以愉快的编译了,

但是不确定能不能生成 mysql client





离线

#11 2018-12-13 15:05:22

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

确实有点棘手, 我再想想办法.





离线

#12 2018-12-14 14:35:22

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

我用 buildroot-2017.08.1 可以编译出 mysql:

debugdump@ubuntu:/disk4/buildroot-2017.08.1$ find output/target/ |grep mysql
output/target/var/mysql
output/target/etc/init.d/S97mysqld
output/target/usr/share/mysql
output/target/usr/share/mysql/errmsg.txt
output/target/usr/share/mysql/mi_test_all.res
output/target/usr/share/mysql/czech
output/target/usr/share/mysql/czech/errmsg.sys
output/target/usr/share/mysql/japanese
output/target/usr/share/mysql/japanese/errmsg.sys
output/target/usr/share/mysql/charsets
output/target/usr/share/mysql/charsets/koi8u.xml
output/target/usr/share/mysql/charsets/latin5.xml
output/target/usr/share/mysql/charsets/Index.xml
output/target/usr/share/mysql/charsets/cp1256.xml
output/target/usr/share/mysql/charsets/macce.xml
output/target/usr/share/mysql/charsets/ascii.xml
output/target/usr/share/mysql/charsets/cp1251.xml
output/target/usr/share/mysql/charsets/cp1250.xml
output/target/usr/share/mysql/charsets/latin7.xml
output/target/usr/share/mysql/charsets/koi8r.xml
output/target/usr/share/mysql/charsets/armscii8.xml
output/target/usr/share/mysql/charsets/cp1257.xml
output/target/usr/share/mysql/charsets/swe7.xml
output/target/usr/share/mysql/charsets/greek.xml
output/target/usr/share/mysql/charsets/geostd8.xml
output/target/usr/share/mysql/charsets/hp8.xml
output/target/usr/share/mysql/charsets/dec8.xml
output/target/usr/share/mysql/charsets/latin2.xml
output/target/usr/share/mysql/charsets/README
output/target/usr/share/mysql/charsets/hebrew.xml
output/target/usr/share/mysql/charsets/keybcs2.xml
output/target/usr/share/mysql/charsets/cp866.xml
output/target/usr/share/mysql/charsets/latin1.xml
output/target/usr/share/mysql/charsets/macroman.xml
output/target/usr/share/mysql/charsets/cp852.xml
output/target/usr/share/mysql/charsets/cp850.xml
output/target/usr/share/mysql/portuguese
output/target/usr/share/mysql/portuguese/errmsg.sys
output/target/usr/share/mysql/spanish
output/target/usr/share/mysql/spanish/errmsg.sys
output/target/usr/share/mysql/mysql_test_data_timezone.sql
output/target/usr/share/mysql/greek
output/target/usr/share/mysql/greek/errmsg.sys
output/target/usr/share/mysql/mi_test_all
output/target/usr/share/mysql/my-huge.cnf
output/target/usr/share/mysql/estonian
output/target/usr/share/mysql/estonian/errmsg.sys
output/target/usr/share/mysql/fill_help_tables.sql
output/target/usr/share/mysql/config.huge.ini
output/target/usr/share/mysql/norwegian
output/target/usr/share/mysql/norwegian/errmsg.sys
output/target/usr/share/mysql/slovak
output/target/usr/share/mysql/slovak/errmsg.sys
output/target/usr/share/mysql/mysql.server
output/target/usr/share/mysql/hungarian
output/target/usr/share/mysql/hungarian/errmsg.sys
output/target/usr/share/mysql/my-large.cnf
output/target/usr/share/mysql/german
output/target/usr/share/mysql/german/errmsg.sys
output/target/usr/share/mysql/my-medium.cnf
output/target/usr/share/mysql/italian
output/target/usr/share/mysql/italian/errmsg.sys
output/target/usr/share/mysql/romanian
output/target/usr/share/mysql/romanian/errmsg.sys
output/target/usr/share/mysql/serbian
output/target/usr/share/mysql/serbian/errmsg.sys
output/target/usr/share/mysql/mysql_fix_privilege_tables.sql
output/target/usr/share/mysql/french
output/target/usr/share/mysql/french/errmsg.sys
output/target/usr/share/mysql/korean
output/target/usr/share/mysql/korean/errmsg.sys
output/target/usr/share/mysql/ndb-config-2-node.ini
output/target/usr/share/mysql/russian
output/target/usr/share/mysql/russian/errmsg.sys
output/target/usr/share/mysql/mysql_system_tables.sql
output/target/usr/share/mysql/dutch
output/target/usr/share/mysql/dutch/errmsg.sys
output/target/usr/share/mysql/config.medium.ini
output/target/usr/share/mysql/binary-configure
output/target/usr/share/mysql/polish
output/target/usr/share/mysql/polish/errmsg.sys
output/target/usr/share/mysql/norwegian-ny
output/target/usr/share/mysql/norwegian-ny/errmsg.sys
output/target/usr/share/mysql/swedish
output/target/usr/share/mysql/swedish/errmsg.sys
output/target/usr/share/mysql/mysql-log-rotate
output/target/usr/share/mysql/my-small.cnf
output/target/usr/share/mysql/config.small.ini
output/target/usr/share/mysql/mysqld_multi.server
output/target/usr/share/mysql/ukrainian
output/target/usr/share/mysql/ukrainian/errmsg.sys
output/target/usr/share/mysql/english
output/target/usr/share/mysql/english/errmsg.sys
output/target/usr/share/mysql/my-innodb-heavy-4G.cnf
output/target/usr/share/mysql/mysql_system_tables_data.sql
output/target/usr/share/mysql/danish
output/target/usr/share/mysql/danish/errmsg.sys
output/target/usr/bin/mysql_client_test_embedded
output/target/usr/bin/mysql_waitpid
output/target/usr/bin/mysql_convert_table_format
output/target/usr/bin/msql2mysql
output/target/usr/bin/mysqlshow
output/target/usr/bin/mysql_setpermission
output/target/usr/bin/mysqlbug
output/target/usr/bin/mysqlaccess
output/target/usr/bin/mysqltest_embedded
output/target/usr/bin/mysqltest
output/target/usr/bin/mysqldump
output/target/usr/bin/mysqlimport
output/target/usr/bin/mysql_zap
output/target/usr/bin/mysqlbinlog
output/target/usr/bin/mysql_client_test
output/target/usr/bin/mysql_fix_privilege_tables
output/target/usr/bin/mysql
output/target/usr/bin/mysql_install_db
output/target/usr/bin/mysqlcheck
output/target/usr/bin/mysql_upgrade
output/target/usr/bin/mysql_fix_extensions
output/target/usr/bin/mysqld_multi
output/target/usr/bin/mysqldumpslow
output/target/usr/bin/mysql_config
output/target/usr/bin/mysql_tzinfo_to_sql
output/target/usr/bin/mysqladmin
output/target/usr/bin/mysql_secure_installation
output/target/usr/bin/mysqld_safe
output/target/usr/bin/mysqlhotcopy
output/target/usr/bin/mysql_find_rows
output/target/usr/bin/mysqlslap
output/target/usr/lib/libcppdb_mysql.so.0
output/target/usr/lib/libcppdb_mysql.so.0.3.1
output/target/usr/lib/libcppdb_mysql.so
output/target/usr/lib/libmysqlclient_r.so.16
output/target/usr/lib/libmysqlclient_r.so.16.0.0
output/target/usr/lib/mysql
output/target/usr/lib/libmysqlclient.so.16.0.0
output/target/usr/lib/libmysqlclient_r.so
output/target/usr/lib/libmysqlclient.so.16
output/target/usr/lib/libmysqlclient.so
output/target/usr/libexec/mysqld
output/target/usr/libexec/mysqlmanager

但是用 buildroot-2018.08.2/ 总是提示前面的错误,不知道哪步操作出问题了.





离线

#13 2018-12-14 14:50:47

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

mysql 源码目录搜索 client:

debugdump@ubuntu:/disk4/buildroot-2017.08.1$ find output/build/oracle-mysql-5.1.73/ |grep client
output/build/oracle-mysql-5.1.73/sql/mini_client_errors.o
output/build/oracle-mysql-5.1.73/sql/client.c
output/build/oracle-mysql-5.1.73/sql/client_settings.h
output/build/oracle-mysql-5.1.73/sql/client.o
output/build/oracle-mysql-5.1.73/sql/mini_client_errors.c
output/build/oracle-mysql-5.1.73/sql/sql_client.cc
output/build/oracle-mysql-5.1.73/sql/sql_client.o
output/build/oracle-mysql-5.1.73/libmysql_r/client.lo
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/libmysqlclient_r.so.16
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/libmysqlclient_r.so.16.0.0
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/libmysqlclient_r.la
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/libmysqlclient_r.so
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/libmysqlclient_r.lai
output/build/oracle-mysql-5.1.73/libmysql_r/.libs/client.o
output/build/oracle-mysql-5.1.73/libmysql_r/client.c
output/build/oracle-mysql-5.1.73/libmysql_r/libmysqlclient_r.la
output/build/oracle-mysql-5.1.73/libmysql_r/client_settings.h
output/build/oracle-mysql-5.1.73/tests/mysql_client_fw.c
output/build/oracle-mysql-5.1.73/tests/mysql_client_test.c
output/build/oracle-mysql-5.1.73/tests/mysql_client_test.o
output/build/oracle-mysql-5.1.73/tests/mysql_client_test
output/build/oracle-mysql-5.1.73/extra/yassl/examples/echoclient
output/build/oracle-mysql-5.1.73/extra/yassl/examples/echoclient/echoclient.cpp
output/build/oracle-mysql-5.1.73/extra/yassl/examples/client
output/build/oracle-mysql-5.1.73/extra/yassl/examples/client/client.cpp
output/build/oracle-mysql-5.1.73/man/mysql_client_test.1
output/build/oracle-mysql-5.1.73/man/mysql_client_test_embedded.1
output/build/oracle-mysql-5.1.73/libmysqld/client.c
output/build/oracle-mysql-5.1.73/libmysqld/client_settings.h
output/build/oracle-mysql-5.1.73/libmysqld/client.o
output/build/oracle-mysql-5.1.73/libmysqld/examples/mysql_client_test_embedded
output/build/oracle-mysql-5.1.73/libmysqld/examples/mysql_client_test.c
output/build/oracle-mysql-5.1.73/libmysqld/examples/mysql_client_test.o
output/build/oracle-mysql-5.1.73/netware/mysql_client_test.def
output/build/oracle-mysql-5.1.73/mysql-test/r/mysql_client_test.result
output/build/oracle-mysql-5.1.73/mysql-test/r/client_xml.result
output/build/oracle-mysql-5.1.73/mysql-test/t/mysql_client_test-master.opt
output/build/oracle-mysql-5.1.73/mysql-test/t/client_xml.test
output/build/oracle-mysql-5.1.73/mysql-test/t/mysql_client_test.test
output/build/oracle-mysql-5.1.73/mysql-test/std_data/client-cert.pem
output/build/oracle-mysql-5.1.73/mysql-test/std_data/client-key.pem
output/build/oracle-mysql-5.1.73/sql-common/client.c
output/build/oracle-mysql-5.1.73/client
output/build/oracle-mysql-5.1.73/client/my_vle.o
output/build/oracle-mysql-5.1.73/client/my_bitmap.o
output/build/oracle-mysql-5.1.73/client/mf_getdate.o
output/build/oracle-mysql-5.1.73/client/Makefile
output/build/oracle-mysql-5.1.73/client/my_user.o
output/build/oracle-mysql-5.1.73/client/readline.o
output/build/oracle-mysql-5.1.73/client/my_decimal.h
output/build/oracle-mysql-5.1.73/client/CMakeLists.txt
output/build/oracle-mysql-5.1.73/client/Makefile.in
output/build/oracle-mysql-5.1.73/client/mysqladmin.o
output/build/oracle-mysql-5.1.73/client/mysqlshow
output/build/oracle-mysql-5.1.73/client/decimal.c
output/build/oracle-mysql-5.1.73/client/mysqldump.o
output/build/oracle-mysql-5.1.73/client/base64.o
output/build/oracle-mysql-5.1.73/client/mysqlslap-mysqlslap.o
output/build/oracle-mysql-5.1.73/client/mysql.o
output/build/oracle-mysql-5.1.73/client/mysqltest.cc
output/build/oracle-mysql-5.1.73/client/log_event_old.h
output/build/oracle-mysql-5.1.73/client/rpl_utility.h
output/build/oracle-mysql-5.1.73/client/mysqlshow.c
output/build/oracle-mysql-5.1.73/client/mysql_priv.h
output/build/oracle-mysql-5.1.73/client/mysql_upgrade.o
output/build/oracle-mysql-5.1.73/client/readline.cc
output/build/oracle-mysql-5.1.73/client/completion_hash.cc
output/build/oracle-mysql-5.1.73/client/my_user.c
output/build/oracle-mysql-5.1.73/client/mysqltest
output/build/oracle-mysql-5.1.73/client/log_event_old.cc
output/build/oracle-mysql-5.1.73/client/.libs
output/build/oracle-mysql-5.1.73/client/mysqlbinlog.cc
output/build/oracle-mysql-5.1.73/client/link_sources
output/build/oracle-mysql-5.1.73/client/mysqldump
output/build/oracle-mysql-5.1.73/client/mysqlimport.c
output/build/oracle-mysql-5.1.73/client/mysqlimport
output/build/oracle-mysql-5.1.73/client/rpl_tblmap.cc
output/build/oracle-mysql-5.1.73/client/completion_hash.h
output/build/oracle-mysql-5.1.73/client/mysqlimport-mysqlimport.o
output/build/oracle-mysql-5.1.73/client/mysqlcheck.o
output/build/oracle-mysql-5.1.73/client/mysqlbinlog
output/build/oracle-mysql-5.1.73/client/Makefile.am
output/build/oracle-mysql-5.1.73/client/mysqlshow.o
output/build/oracle-mysql-5.1.73/client/my_decimal.cc
output/build/oracle-mysql-5.1.73/client/log_event.h
output/build/oracle-mysql-5.1.73/client/mysql
output/build/oracle-mysql-5.1.73/client/rpl_record_old.cc
output/build/oracle-mysql-5.1.73/client/rpl_tblmap.h
output/build/oracle-mysql-5.1.73/client/mysqlcheck
output/build/oracle-mysql-5.1.73/client/mysql_upgrade
output/build/oracle-mysql-5.1.73/client/mysqldump.c
output/build/oracle-mysql-5.1.73/client/log_event.cc
output/build/oracle-mysql-5.1.73/client/sql_string.cc
output/build/oracle-mysql-5.1.73/client/sql_string.o
output/build/oracle-mysql-5.1.73/client/mysql.cc
output/build/oracle-mysql-5.1.73/client/mysql_upgrade.c
output/build/oracle-mysql-5.1.73/client/mysqladmin
output/build/oracle-mysql-5.1.73/client/client_priv.h
output/build/oracle-mysql-5.1.73/client/completion_hash.o
output/build/oracle-mysql-5.1.73/client/mysqlslap.c
output/build/oracle-mysql-5.1.73/client/mf_tempdir.o
output/build/oracle-mysql-5.1.73/client/mysqlcheck.c
output/build/oracle-mysql-5.1.73/client/sql_string.h
output/build/oracle-mysql-5.1.73/client/mysqladmin.cc
output/build/oracle-mysql-5.1.73/client/mysqltest-mysqltest.o
output/build/oracle-mysql-5.1.73/client/my_bit.o
output/build/oracle-mysql-5.1.73/client/my_readline.h
output/build/oracle-mysql-5.1.73/client/get_password.c
output/build/oracle-mysql-5.1.73/client/rpl_constants.h
output/build/oracle-mysql-5.1.73/client/mysqlslap
output/build/oracle-mysql-5.1.73/client/my_getpagesize.o
output/build/oracle-mysql-5.1.73/client/my_new.o
output/build/oracle-mysql-5.1.73/client/mysqlbinlog.o
output/build/oracle-mysql-5.1.73/client/echo.c
output/build/oracle-mysql-5.1.73/client/rpl_record_old.h
output/build/oracle-mysql-5.1.73/storage/ndb/config/type_mgmapiclient.mk.am
output/build/oracle-mysql-5.1.73/storage/ndb/config/type_ndbapiclient.mk.am
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/CommandInterpreter.cpp
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/Makefile
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/Makefile.in
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/ndb_mgmclient.h
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/main.cpp
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/ndb_mgmclient.hpp
output/build/oracle-mysql-5.1.73/storage/ndb/src/mgmclient/Makefile.am
output/build/oracle-mysql-5.1.73/libmysql/client.lo
output/build/oracle-mysql-5.1.73/libmysql/.libs/libmysqlclient.lai
output/build/oracle-mysql-5.1.73/libmysql/.libs/libmysqlclient.so.16.0.0
output/build/oracle-mysql-5.1.73/libmysql/.libs/libmysqlclient.la
output/build/oracle-mysql-5.1.73/libmysql/.libs/libmysqlclient.so.16
output/build/oracle-mysql-5.1.73/libmysql/.libs/client.o
output/build/oracle-mysql-5.1.73/libmysql/.libs/libmysqlclient.so
output/build/oracle-mysql-5.1.73/libmysql/client.c
output/build/oracle-mysql-5.1.73/libmysql/libmysqlclient.la
output/build/oracle-mysql-5.1.73/libmysql/client_settings.h




离线

楼主 #14 2018-12-15 09:55:06

605364021
会员
注册时间: 2018-10-23
已发帖子: 251
积分: 251

Re: 关于arm开发板远程访问mysql数据库

已经解决V3S上使用QT访问windows上的mysql数据库,我没有使用buildroot的mysql_client,直接从mysql源码编译,编写对应QT程序可以从读取或修改windows下mysql数据库的内容
教程如下http://bbs.elecfans.com/jishu_910286_1_1.html

最近编辑记录 605364021 (2018-12-15 09:57:04)

离线

#15 2018-12-15 10:29:58

晕哥
管理员
注册时间: 2017-09-06
已发帖子: 9,342
积分: 9202

Re: 关于arm开发板远程访问mysql数据库

605364021 说:

已经解决V3S上使用QT访问windows上的mysql数据库,我没有使用buildroot的mysql_client,直接从mysql源码编译,编写对应QT程序可以从读取或修改windows下mysql数据库的内容
教程如下http://bbs.elecfans.com/jishu_910286_1_1.html

感谢分享!





离线

页脚

工信部备案:粤ICP备20025096号 Powered by FluxBB

感谢为中文互联网持续输出优质内容的各位老铁们。 QQ: 516333132, 微信(wechat): whycan_cn (哇酷网/挖坑网/填坑网) service@whycan.cn