Difference between revisions of "Use MySQL-client on apf9328"
(→Configure host database) |
(→Connecting apf9328 to host database) |
||
(One intermediate revision by the same user not shown) | |||
Line 34: | Line 34: | ||
=== Configure host database === | === Configure host database === | ||
− | A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html] | + | A good tutorial to configure host MySQL database can be found here [http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html] or here |
− | + | [http://www.bidon.ca/Tr%C3%A8s_mini_howto_MySQL.html](fr). | |
− | + | ||
=== Connecting apf9328 to host database === | === Connecting apf9328 to host database === | ||
+ | |||
+ | <source lang="mysql"> | ||
+ | mysql -u plop -h 192.168.0.214 -p | ||
+ | </source> |
Latest revision as of 14:21, 5 December 2008
I made this page to write some procedure to install mySQL-client in apf9328. It's not a howto, because to be clean, the buildroot package must be rebuild.
Contents
select Package Selection for the target -> database -> MySQL-client.
Clean the package
MySQL-client buildroot package was made without size optimisation, then if you compile as-is, the rootfs size is 80Mo ! To optimize size, just use a graphical-fs viewer like filelight or kdirstat to suppress useless files in directory : buildroot/project_build_armv4t/apf9328/root/, and try to reduce by 8Mo or 16Mo according to your flash size.
compile
- To force buildroot re-building the rootfs suppress buildroot/binaries/apf9328/apf9328-rootfs.arm.jffs2 file then make.
- flash rootfs
- boot
Resolve link error
If you try to launch mysql you will have an error:
[root@armadeus MySQL-python-1.2.2]# mysql
mysql: can't load library 'libmysqlclient.so.16'
Quick method to solve it is to make symbolic link in /usr/lib:
[root@armadeus lib]# ln -s mysql/libmysqlclient.so.16
This is really dirty method but that work ;-)
Configure host database
A good tutorial to configure host MySQL database can be found here [1] or here [2](fr).
Connecting apf9328 to host database
mysql -u plop -h 192.168.0.214 -p