debian armhf mysql_Debian for ARM

/*************************************************************************

* Debian for ARM

* 说明：

* 尝试一下Debian for ARM，然后安装了一下MySQL，还是遇到以前遇到的问题，

* 目前还是没有解决。

*

* 2017-2-17 深圳 南山平山村 曾剑锋

************************************************************************/一、参考文档：1. 向Tiny210移植Debian Linux

http://blog.csdn.net/laohuang1122/article/details/10828987

2. Debian GNU/Linux 安装手册

https://www.debian.org/releases/stable/armhf/index.html.zh-cn

3. EmDebian CrossDebootstrap

https://wiki.debian.org/EmDebian/CrossDebootstrap

4. 使用 debootstrap 建立完整的 Debian 系統

https://github.com/KingBing/blog-src/blob/master/%E4%BD%BF%E7%94%A8%20debootstrap%20%E5%BB%BA%E7%AB%8B%E5%AE%8C%E6%95%B4%E7%9A%84%20Debian%20%E7%B3%BB%E7%B5%B1.org

5. linux forARM development boards

https://www.armbian.com/

6. How to fix GPG inupdater [duplicate]

http://askubuntu.com/questions/235880/how-to-fix-gpg-in-updater

7. 创建基于arm的debian文件系统

http://blog.csdn.net/luoqindong/article/details/42737879

8. mysql指定路径启动

http://www.cnblogs.com/mangu-uu/p/4162984.html

9. Unable to set password forthe mysql “root” user

http://askubuntu.com/questions/253023/unable-to-set-password-for-the-mysql-root-user

二、主要操作：1. # apt-get install binfmt-support qemu qemu-user-staticdebootstrap2. # mkdir debian_armhf_wheezy3. # debootstrap --foreign --arch armhf wheezy debian_armhf_wheezy http://ftp.debian.org/debian/

4. # cp /usr/bin/qemu-arm-static debian_armhf_wheezy/usr/bin5. # DEBIAN_FRONTEND=noninteractive DEBCONF_NONINTERACTIVE_SEEN=true LC_ALL=C LANGUAGE=C LANG=C chroot debian_armhf_wheezy /debootstrap/debootstrap --second-stage6. # DEBIAN_FRONTEND=noninteractive DEBCONF_NONINTERACTIVE_SEEN=true LC_ALL=C LANGUAGE=C LANG=C chroot debian_armhf_wheezy dpkg --configure -a7. # sudo chroot debian_armhf_wheezy8. # vi /etc/apt/source.list

deb http://cdn.debian.net/debian wheezy main contrib non-free

deb-src http://cdn.debian.net/debian wheezy main contrib non-free

三、运行MySQL出错：1. 查看信息：

root@aplex:/var/log/mysql# mysql_install_db --user=mysql --ldata=/var/lib/mysql/WARNING: The host'aplex'could not be looked up with resolveip.

This probably means that your libc libraries are not100 %compatible

withthisbinary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges!Installing MySQL system tables...000102 9:38:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed ina future release. Please use the full name instead.000102 9:38:54 [Warning] Ignoring user change to 'mysql' because the user was set to 'root'earlier on the command line000102 9:38:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed ina future release. Please use the full name instead.000102 9:38:54 [Warning] Ignoring user change to 'mysql' because the user was set to 'root'earlier on the command line000102 9:38:54 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.000102 9:38:54 [Note] /usr/sbin/mysqld (mysqld 5.5.54-0+deb7u2) starting as process 4915...

ERROR:130 Incorrect file format 'db'

000102 9:38:54[ERROR] Aborting000102 9:38:54 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed! Examine the logs in

/var/lib/mysql/ formore information.

You cantryto start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant &and use the command line tool/usr/bin/mysql

to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql

mysql>show tables

Try'mysqld --help' if you have problems with paths. Using --log

gives you a login /var/lib/mysql/that may be helpful.

Please consult the MySQL manual section'Problems running mysql_install_db', and the manual section that

describes problems on your OS. Another information source are the

MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before submitting a bug report

at http://bugs.mysql.com/

root@aplex:/var/log/mysql#2. 避开权限进入：/usr/sbin/mysqld --skip-grant &