debian armhf mysql_Debian for ARM-CSDN博客

本文链接：https://blog.csdn.net/weixin_35472986/article/details/114978910

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

* 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 for ARM development boards

https://www.armbian.com/

6. How to fix GPG in updater [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 for the 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-static debootstrap

2. # mkdir debian_armhf_wheezy

3. # debootstrap --foreign --arch armhf wheezy debian_armhf_wheezy http://ftp.debian.org/debian/

4. # cp /usr/bin/qemu-arm-static debian_armhf_wheezy/usr/bin

5. # DEBIAN_FRONTEND=noninteractive DEBCONF_NONINTERACTIVE_SEEN=true LC_ALL=C LANGUAGE=C chroot debian_armhf_wheezy /debootstrap/debootstrap --second-stage

6. # DEBIAN_FRONTEND=noninteractive DEBCONF_NONINTERACTIVE_SEEN=true LC_ALL=C LANGUAGE=C chroot debian_armhf_wheezy dpkg --configure -a

7. # sudo chroot debian_armhf_wheezy

8. # 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 not 100 % compatible

with this binary 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 in a 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 line

000102 9:38:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a 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 line

000102 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] Aborting

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

Installation of system tables failed! Examine the logs in

/var/lib/mysql/ for more information.

You can try to 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: