/*************************************************************************
* 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 &