2020年01月15日 | 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 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:

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

            mysql> show tables

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

        gives you a log in /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 &