安装mysql（失败过程记录……最终结果还是失败）

最新推荐文章于 2024-09-30 14:02:05 发布
最新推荐文章于 2024-09-30 14:02:05 发布
阅读量5.4k 收藏 1
点赞数 2
分类专栏： OpenWRT
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_27508477/article/details/88371057
版权

准备安装mysql数据库，发现不能直接安装。

root@EC2022v:/etc# opkg install mysql
Unknown package 'mysql'.
Collected errors:
 * opkg_install_cmd: Cannot install package mysql.

于是搜索和mysql有关的包……

root@EC2022v:/etc# opkg list|grep mysql
asterisk11-mysql - 11.12.0-1 - Asterisk is a complete PBX in software. It provides all of the features you would expect from a PBX and more. Asterisk does voice over IP in three protocols, and can interoperate with almost all standards-based telephony equipment using relatively inexpensive hardware. This package provides support MySQL support in Asterisk.
asterisk18-mysql - 1.8.30.0-1 - Asterisk is a complete PBX in software. It provides all of the features you would expect from a PBX and more. Asterisk does voice over IP in three protocols, and can interoperate with almost all standards-based telephony equipment using relatively inexpensive hardware. This package provides support MySQL support in Asterisk.
cbtt-mysql - 20060727-2 - Bittorrent tracker (with mysql support)
kamailio4-mod-db-mysql - 4.1.5-3 - kamailio4 MySQL database-backend module
libdbi-drivers-mysql - 0.9.0-1 - libdbi-drivers-mysql
libmysqlclient - 5.1.73-1 - MySQL client library
libmysqlclient-r - 5.1.73-1 - MySQL client library threadsafe
luasql-mysql - 2.1.1-1 - LuaSQL is a simple interface from Lua to a DBMS. . This package contains the MySQL binding.
mysql-server - 5.1.73-1 - MySQL Server
nfacctd-mysql - 0.14.0-1 - NetFlow accounting daemon with MySQL support
php5-mod-mysql - 5.4.27-1 - MySQL shared module
php5-mod-mysqli - 5.4.27-1 - MySQL Improved Extension shared module
php5-mod-pdo-mysql - 5.4.27-1 - PDO driver for MySQL shared module
pmacctd-mysql - 0.14.0-1 - IP pcap-based accounting daemon with MySQL support
python-mysql - 1.2.2-1 - MySQLdb is an thread-compatible interface to the popular MySQL database server that provides the Python database API.
restund-mod-mysql - 0.4.2-3 - restund MySQL database backend module
sfacctd-mysql - 0.14.0-1 - sFlow accounting daemon with MySQL support
snort-mysql - 2.9.2.2-3 - Snort is an open source network intrusion detection and prevention system. It is capable of performing real-time traffic analysis, alerting, blocking and packet logging on IP networks.  It utilizes a combination of protocol analysis and pattern matching in order to detect anomalies, misuse and attacks. This package contains snort with support for logging to a MySQL database.
snort-wireless-mysql - 2.4.3-alpha04-1 - Lightweight Network Intrusion Detection System (MySQL)
strongswan-mod-mysql - 5.3.2-1 - StrongSwan MySQL database interface plugin
uacctd-mysql - 0.14.0-1 - ulog accounting daemon with MySQL support
ulogd-mod-mysql - 1.24-2 - Output plugin for logging to a MySQL database
yate-mod-mysqldb - 5.4.0-1-4 - MySQL Backend DB module for yate
root@EC2022v:/etc#

安装：

root@EC2022v:/etc# opkg install mysql-server
Installing mysql-server (5.1.73-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/oldpackages/mysql-server_5.1.73-1_at91.ipk.
Multiple packages (libpthread and libpthread) providing same name marked HOLD or PREFER. Using latest.
Installing libmysqlclient (5.1.73-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/oldpackages/libmysqlclient_5.1.73-1_at91.ipk.
Installing uclibcxx (0.2.4-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/base/uclibcxx_0.2.4-1_at91.ipk.
Installing libncursesw (5.9-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/base/libncursesw_5.9-1_at91.ipk.

然后就卡在这里了……

重启试一下：

root@EC2022v:~# ping www.baidu.com
PING www.baidu.com (180.97.33.107): 56 data bytes
64 bytes from 180.97.33.107: seq=0 ttl=50 time=53.040 ms
64 bytes from 180.97.33.107: seq=1 ttl=50 time=52.715 ms
^C
--- www.baidu.com ping statistics ---
2 packets transmitted, 2 packets received, 0% packet loss
round-trip min/avg/max = 52.715/52.877/53.040 ms

可以ping通，网络连接正常~

root@EC2022v:~# opkg install mysql-server
Installing mysql-server (5.1.73-1) to root...
Configuring uclibcxx.
Configuring libmysqlclient.
Collected errors:
 * opkg_download_pkg: Package mysql-server is not available from any configured src.
 * opkg_install_pkg: Failed to download mysql-server. Perhaps you need to run 'opkg update'?
 * opkg_install_cmd: Cannot install package mysql-server.
root@EC2022v:~#

安装失败~
尝试opkg update~

root@EC2022v:~# opkg update
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/base/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_base.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/luci/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_luci.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/management/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_management.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/oldpackages/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_oldpackages.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/packages/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_packages.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/routing/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_routing.
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/telephony/Packages.gz.
Updated list of available packages in /var/opkg-lists/barrier_breaker_telephony.

oot@EC2022v:~# opkg install mysql-server
Installing mysql-server (5.1.73-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/oldpackages/mysql-server_5.1.73-1_at91.ipk.
Multiple packages (libpthread and libpthread) providing same name marked HOLD or PREFER. Using latest.
Installing libncursesw (5.9-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/base/libncursesw_5.9-1_at91.ipk.
Configuring libncursesw.
Configuring mysql-server.
Collected errors:
 * copy_file_chunk: write: No space left on device.
 * file_md5sum_alloc: Failed to open file /etc/my.cnf: No such file or directory.

空间不足？

root@EC2022v:~# df -h
Filesystem                Size      Used Available Use% Mounted on
rootfs                   32.0M     32.0M     36.0K 100% /
ubi0:kernel              19.7M     13.4M      6.3M  68% /rom
tmpfs                    59.6M    584.0K     59.1M   1% /tmp
/dev/mtdblock1           32.0M     32.0M     36.0K 100% /overlay
overlayfs:/overlay       32.0M     32.0M     36.0K 100% /
tmpfs                   512.0K         0    512.0K   0% /dev
/dev/mtdblock2          188.0M      1.7M    186.3M   1% /mnt/nandflash

root@EC2022v:~# df /etc
Filesystem           1K-blocks      Used Available Use% Mounted on
rootfs                   32768     32728        40 100% /

空间确实不够了……

先卸载，再重装试试，还是不行……

root@EC2022v:/etc# opkg remove mysql-server
Removing package mysql-server from root...

root@EC2022v:/etc# opkg install mysql-server
Installing mysql-server (5.1.73-1) to root...
Collected errors:
 * verify_pkg_installable: Only have 48kb available on filesystem /overlay, pkg mysql-server needs 2083
 * opkg_install_cmd: Cannot install package mysql-server.

大胆删除root下的各种文件夹~

root@EC2022v:~# df -h
Filesystem                Size      Used Available Use% Mounted on
rootfs                   32.0M     20.1M     11.9M  63% /
ubi0:kernel              19.7M     13.4M      6.3M  68% /rom
tmpfs                    59.6M      1.1M     58.6M   2% /tmp
/dev/mtdblock1           32.0M     20.1M     11.9M  63% /overlay
overlayfs:/overlay       32.0M     20.1M     11.9M  63% /
tmpfs                   512.0K         0    512.0K   0% /dev
/dev/mtdblock2          188.0M      1.7M    186.3M   1% /mnt/nandflash

然后重装……

root@EC2022v:~# opkg install mysql-server
Installing mysql-server (5.1.73-1) to root...
Downloading http://downloads.openwrt.org/barrier_breaker/14.07/at91/9g20/packages/oldpackages/mysql-server_5.1.73-1_at91.ipk.
Multiple packages (libpthread and libpthread) providing same name marked HOLD or PREFER. Using latest.
Configuring mysql-server.

装完还有空间~

root@EC2022v:~# df -h
Filesystem                Size      Used Available Use% Mounted on
rootfs                   32.0M     23.3M      8.7M  73% /
ubi0:kernel              19.7M     13.4M      6.3M  68% /rom
tmpfs                    59.6M      1.1M     58.6M   2% /tmp
/dev/mtdblock1           32.0M     23.3M      8.7M  73% /overlay
overlayfs:/overlay       32.0M     23.3M      8.7M  73% /
tmpfs                   512.0K         0    512.0K   0% /dev
/dev/mtdblock2          188.0M      1.7M    186.3M   1% /mnt/nandflash

修改数据存放地址~虽然不要放到Nand里，但是我只能放到Nand里呀。

############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir		= /mnt/nandflash/mysql/

######### This should also not go on the NAND #######
tmpdir		= /mnt/nandflash/tmp/

skip-external-locking

bind-address		= 0.0.0.0

创建数据文件夹~

root@EC2022v:/etc# cd /mnt/nandflash/
root@EC2022v:/mnt/nandflash# ls
lost+found  rsa_test    ssltest
root@EC2022v:/mnt/nandflash# mkdir mysql
root@EC2022v:/mnt/nandflash# mkdir tmp
root@EC2022v:/mnt/nandflash#

启动进程，报错需要运行mysql_install_db --force，但是运行继续报错~

root@EC2022v:/mnt/nandflash# /etc/init.d/mysqld enable
root@EC2022v:/mnt/nandflash# /etc/init.d/mysqld start
/etc/init.d/mysqld: Error: I didn't detect a privileges table, you might need to run mysql_install_db --force to initialize the system tables

root@EC2022v:/mnt/nandflash# mysql_install_db --force
/usr/bin/mysql_install_db: line 249: /usr/bin/my_print_defaults: not found

FATAL ERROR: Could not find /usr/lib/mysqld

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

emm……

修改了路径，还是不行……

root@EC2022v:/usr/bin# find / -name  mysqld
/etc/init.d/mysqld
/usr/bin/mysqld
/overlay/usr/bin/mysqld
/overlay/etc/init.d/mysqld

root@EC2022v:/usr/bin# cat /etc/my.cnf
[client]
port		= 3306
socket		= /var/run/mysqld.sock

[mysqld]
user		= root
socket		= /var/run/mysqld.sock
port		= 3306
basedir		= /usr/bin

直接复制~

root@EC2022v:/usr/bin# cp /usr/bin/mysqld /usr/lib
root@EC2022v:/usr/bin# mysql_install_db --force 
/usr/bin/mysql_install_db: line 249: /usr/bin/my_print_defaults: not found
Installing MySQL system tables...
/usr/bin/mysql_install_db: line 423: /usr/lib/mysqld: not found

Installation of system tables failed!  Examine the logs in
/var for more information.

You can try to start the mysqld daemon with:

    shell> /usr/lib/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 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 mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

还是不行……

垃圾板子，毁我青春~！！！！

小盼你最萌哒
关注
专栏目录
详细记录linux安装mysql8过程以及踩过的坑
TTDZS的博客
03-19 1929
这玩意儿俺装了两次，第一次因为啥也不懂扑街了…… （前面的内容都是失败案例，没有耐心的看官可以直接跳过） 在你想要的目录下，创建mysql文件夹： mkdir mysql 当前目录下，进入mysql目录 cd /mysql 在mysql官网下载linux系统下的mysql8版本，通过xftp远程连接阿里云服务器传输这个压缩包，然后解压： 解压之后，安装mysql，由于了解到mysql的各个压缩包之间有一定的依赖关系，我又懒得一条条写命令，索性一次性全部安装： rpm文件命令 sudo yum loca
mysql使用存储过程插入记录并返回自增id踩坑
qq_37900736的博客
08-14 3746
mysql使用存储过程插入记录并返回自增id踩坑（由于不同表中相同字段导致的错误 1. 附上mysql插入记录后返回自增id的方法链接 mysql插入数据后返回自增ID的方法. 2. 出问题的存储过程 CREATE PROCEDURE `proc_test`(IN tname VARCHAR(255),IN tpwd VARCHAR(255),OUT reid INT) BEGIN INSER...
OpenWRT 安装netspeedtest
cuilingji的专栏
06-29 1427
以下文件均上传至tmp目录中。
PackagesNotFoundError:The following packages are not available from current channels:-mmcv-full
最新发布
lzm_hkedu的博客
09-30 298
在下载mmcv-full 1.7.0的时候就遇到这个弱智的问题。更难受的是在一个小时之前是可以下载的，但是过了一会一用conda下载就出现这个问题，但是我翻了在服务器上的output我执行的是一模一样的代码， 虽然sources可能有点不太一样，但应该default source就可以下载的。注意，mmcv-full 1.7.0和1.7.2是很有可能发生不匹配的error的。
MySQL安装步骤
qq_43034019的博客
08-22 479
CentOS下安装MySQL步骤： 地址：http://www.linuxidc.com/Linux/2015-01/112583.htm 第一、 http://www.mysql.com/downloads/mysql-4.0.html下载MySQL-client-5.0.96-1.glibc23.x86_64.rpm和 MySQL-server-5.0.96-1.glibc23.x86_...
OpenWrt的ipk包安装
weixin_34121304的博客
05-03 2172
2019独角兽企业重金招聘Python工程师标准>>> ...
【ROS问题记录】
qq_35892287的博客
10-30 368
直接删除那个多余的文件夹，担心出问题可以先备份一下，但是不要包含和包一样的名，不然还是会出错。如 mv rqt_virtual_joy bakfolder。参考https://github.com/qboticslabs/mastering_ros/issues/1。
mysql 创建游标报错_一次使用存储过程游标遇到的坑
weixin_28870939的博客
02-27 1104
一次使用存储过程游标遇到的坑有这样一个需求：统计某省某市某区前6个月的数据，直接sql查询效率很低，于是打算做定时任务，用定时器执行存储过程的方式在每月初统计上月的相关数据。使用存储过程就要用到游标了，之前很少写存储过程，对游标也不是熟悉，咋办呢，现学现用啦。创建存储过程1 CREATE2 [DEFINER = { user | CURRENT_USER }]3 　PROCEDURE sp...
MySQL学习记录
M_try的博客
07-10 561
MySQL增删改查语句，视图、存储过程等
MySQL主从不一致问题相关处理
热门推荐
企业实战系列集 ●●● https://ximenjianxue.blog.csdn.net
09-26 1万+
某业务采取mysql的主从架构，但因为存储的问题，导致备库一直无法存储，数据同步一致性问题一直也未恢复，某次安全检查要求完成主备倒换演练，必须限期恢复主备，但是在恢复过程中，同步显示正常一段时间后，便会出现sql线程异常，主备数据不一致导致的同步错误情况。主数据库上面设置的max_allowed_packet比从数据库大，当一个大的sql语句，能在主数据库上面执行完毕，从数据库上面设置过小，无法执行，导致的主从不一致。根据上面的NR行数，查看附近的行，定位数据不一致的地方，后续手动补全。
我的云服务器
qq_35451217的博客
03-10 1429
我的云服务器 申请了一华为云服务器HECS(云耀云服务器) 选择安装Ubuntu 16.04 当状态为运行中时，即可执行操作 1.重置密码 2.远程登录 cloudshell(华为云提供) VNC 这里使用cloudshell 此时进入了熟悉的Ubuntu命令行界面，用户为root 创建新用户 sudo adduser USERNAME 此时可以发现/home目录下多出了用户目录 切换用户为普通用户 suUSERNAME 切换至用户目录 cd ~/ 主机安全设置 ...
SO version
farmwang的专栏
10-22 827
Running new applications on old glibc Glibc (short for GNU Libc, or GNU C Library) is a library that provides the interface between application programs and the Linux kernel. Although its officia
怎么在Openwrt中开发自己的ipk固件
caofengtao1314的专栏
07-24 4968
之前写过一篇日志，是关于如何搭建自己的OpenWRT开发环境。经过最近一段时间的开发学习和实践，对OpenWRT环境的开发有了一定的了解。在这里将我的开发心得做个整理。 1、搭建开发环境 首先，我们需要一个为路由器定制的开发环境，具体可以参考我的另一篇日志：《搭建自己的OpenWrt开发环境》。这里只做一个简单的补充，在执行make menuconfig后，会出现下图： 其中，图中红框部分是我...
opkg php7,求助：openwrt opkg安装php7 php7-cgi ，运行出错。
weixin_42109545的博客
03-13 1675
root@ccbcfan:/usr/bin# opkg updateDownloading http://openwrt.proxy.ustclug.org/snapshots/targets/ramips/mt7620/packages/Packages.gzUpdated list of available packages in /var/opkg-lists/openwrt_coreDow...
路由器php7安装,小米路由器3G建站折腾笔记4 - 安装opkg和onmp
weixin_40005437的博客
03-21 1381
本节是路由器建站的重头戏，挂好U盘，安装好opkg和onmp，后面就简单了。六、挂载U盘路由器内的存储空间有限，仅仅128M，在我装Go程序的时候，100来M的压缩包都不能顺利解压，所以必须通过U盘来扩展空间，把要装的程序、数据、文档都撞到U盘上，这样以后想进行数据迁移和备份都很方便。1、首先格式化U盘。前面刷机用的是FAT格式，但是在Linux下使用的时候，不能创建符号链接，安装opkg时出现问...
CentOS7下解决yum install mysql-server没有可用包的问题
破风
01-17 2276
如上图所示，CentOS下yum方式安装mysql-server经常出现这种情况，解决办法如下： 1 手动获取rpm文件(建议放在opt文件下) # wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 正在解析主机 repo.mysql.com (repo.mysql.com)... 23.4.241.142 正在...
CentOS7下解决yum install mysql-server 异常：No package mysql-server available.问题
Fanrncho的博客
09-08 7532
yum安装mysql-server没有可用包问题解决方法： step 1: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm step 2: rpm -ivh mysql-community-release-el7-5.noarch.rpm 经过以上两个步骤后再次执行：yum install mysql-s
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值