openwrt 安装mysql环境出错，请大佬们看一下怎么办

siscool

安装了 如下包  

1. opkg install libpthread libncurses libreadline mysql-server

复制代码

该错误是执行数据库初始化发生的

1. root@OpenWrt:~# mysql_install_db --force
   
2. 
   
3. FATAL ERROR: Could not find ./bin/my_print_defaults
   
4. 
   
5. If you compiled from source, you need to either run 'make install' to
   
6. copy the software into the correct location ready for operation.
   
7. If you don't want to do a full install, you can use the --srcdir
   
8. option to only install the mysql database and privilege tables
   
9. 
   
10. If you compiled from source, you need to either run 'make install' to
    
11. copy the software into the correct location ready for operation.
    
12. If you don't want to do a full install, you can use the --srcdir
    
13. option to only install the mysql database and privilege tables
    
14. 
    
15. If you are using a binary release, you must either be at the top
    
16. level of the extracted archive, or pass the --basedir option
    
17. pointing to that location.
    
18. 
    
19. The latest information about mysql_install_db is available at
    
20. https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
    
21. root@OpenWrt:~# sed -i 's,^datadir.*,datadir         = "/srv/mysql",g' /etc/my.c
    
22. nf
    
23. sed: /etc/my.cnf: No such file or directory
    
24. root@OpenWrt:~# sed -i 's,^tmpdir.*,tmpdir          = "/tmp",g' /etc/my.cnf
    
25. sed: /etc/my.cnf: No such file or directory
    
26. root@OpenWrt:~# /etc/init.d/mysqld start
    
27. root@OpenWrt:~# /etc/init.d/mysqld enable
    
28. root@OpenWrt:~# mysqladmin -u root password '123456'
    
29. -ash: mysqladmin: not found
    
30. root@OpenWrt:~# /etc/init.d/mysqld start
    
31. root@OpenWrt:~# /usr/bin/mysqladmin -u root password 123456
    
32. -ash: /usr/bin/mysqladmin: not found
    

复制代码

请不要胡乱输入以及粘贴、复制等方式灌水

请尊重作者、并共同维护网站的正常阅读，否则账户将会被限制发帖、回帖，并且积分可能会被清零，站内短信以及阅读权限等都会受到影响，谢谢。 具体限制方式：https://www.right.com.cn/forum/thread-8307840-1-1.html

99010

新版本MySQL安装完就自动运行了。需要先停止运行再创建数据库

siscool

99010 发表于 2018-12-5 18:31
新版本MySQL安装完就自动运行了。需要先停止运行再创建数据库

请问新版本的mysql包名是啥？

kangdei

我也遇到了这个问题，解决方法是ln -s /usr/bin/mysql** /bin/*
但是这步解决了，下一步就遇到了

1. Installing MariaDB/MySQL system tables in '/mnt/sda1/data/mysql' ...
   
2. 2018-12-21 15:48:25 2012630296 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
   
3. 2018-12-21 15:48:25 2012630296 [Warning] InnoDB: Linux Native AIO disabled.
   
4. 2018-12-21 15:48:25 2012630296 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
   
5. 2018-12-21 15:48:25 2012630296 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
   
6. 2018-12-21 15:48:26 2012630296 [ERROR] Plugin 'InnoDB' init function returned error.
   
7. 2018-12-21 15:48:26 2012630296 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
   
8. 2018-12-21 15:48:26 2012630296 [ERROR] Unknown/unsupported storage engine: InnoDB
   
9. 2018-12-21 15:48:26 2012630296 [ERROR] Aborting
   
10. 
    
11. 
    
12. Installation of system tables failed!  Examine the logs in
    
13. /mnt/sda1/data/mysql for more information.
    
14. 
    
15. The problem could be conflicting information in an external
    
16. my.cnf files. You can ignore these by doing:
    
17. 
    
18.     shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
    
19. 
    
20. You can also try to start the mysqld daemon with:
    
21. 
    
22.     shell> /usr/bin/mysqld --skip-grant-tables --general-log &
    
23. 
    
24. and use the command line tool /usr/bin/mysql
    
25. to connect to the mysql database and look at the grant tables:
    
26. 
    
27.     shell> /usr/bin/mysql -u root mysql
    
28.     mysql> show tables;
    
29. 
    
30. Try 'mysqld --help' if you have problems with paths.  Using
    
31. --general-log gives you a log in /mnt/sda1/data/mysql that may be helpful.
    
32. 
    
33. The latest information about mysql_install_db is available at
    
34. https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
    
35. You can find the latest source at https://downloads.mariadb.org and
    
36. the maria-discuss email list at https://launchpad.net/~maria-discuss
    
37. 
    
38. Please check all of the above before submitting a bug report
    
39. at http://mariadb.org/jira
    

复制代码

原因是我安装的东西变成了mariadb了，，

liunaijie

kangdei 发表于 2018-12-21 23:49
我也遇到了这个问题，解决方法是ln -s /usr/bin/mysql** /bin/*
但是这步解决了，下一步就遇到了

你好，我现在也是遇到了这个问题。请问你解决了吗？ liunaijie1996@163.com这是我的邮箱

kangdei

liunaijie 发表于 2019-1-5 13:14
你好，我现在也是遇到了这个问题。请问你解决了吗？ 这是我的邮箱

我没有解决问题，你解决了php7的配置了没有

liunaijie

kangdei 发表于 2019-1-5 17:54
我没有解决问题，你解决了php7的配置了没有

我没有打算用php，所有没有安装

dot1x

这一步在命令后面加一个,这个意思是指定mysql的安装目录，那个目录不一定是usr，每个人可能不同

1. --basedir=/usr

复制代码

完整的命令如下：

1. /etc/mysql# mysql_install_db --basedir=/usr --force

复制代码

但是，后面又来新问题了，提示不支持本地AIO接口。这问题我就不会了。还请大佬帮忙看看。

1. root@OpenWrt:/etc/mysql# mysql_install_db --basedir=/usr --force
   
2. Installing MariaDB/MySQL system tables in '/overlay/mnt/data/mysql' ...
   
3. 2019-01-20 15:37:34 2013162776 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
   
4. 2019-01-20 15:37:34 2013162776 [Warning] InnoDB: Linux Native AIO disabled.
   
5. 2019-01-20 15:37:34 2013162776 [ERROR] InnoDB: mmap(136183808 bytes) failed; errno 12
   
6. 2019-01-20 15:37:34 2013162776 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
   
7. 2019-01-20 15:37:34 2013162776 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
   
8. 2019-01-20 15:37:34 2013162776 [ERROR] Plugin 'InnoDB' init function returned error.
   
9. 2019-01-20 15:37:34 2013162776 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
   
10. 2019-01-20 15:37:34 2013162776 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
    
11. 2019-01-20 15:37:34 2013162776 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
    
12. 2019-01-20 15:37:34 2013162776 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
    
13. 2019-01-20 15:37:34 2013162776 [ERROR] Unknown/unsupported storage engine: InnoDB
    
14. 2019-01-20 15:37:34 2013162776 [ERROR] Aborting
    
15. 
    
16. 
    
17. Installation of system tables failed!  Examine the logs in
    
18. /overlay/mnt/data/mysql for more information.
    
19. 
    
20. The problem could be conflicting information in an external
    
21. my.cnf files. You can ignore these by doing:
    
22. 
    
23.     shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
    
24. 
    
25. You can also try to start the mysqld daemon with:
    
26. 
    
27.     shell> /usr/bin/mysqld --skip-grant-tables --general-log &
    
28. 
    
29. and use the command line tool /usr/bin/mysql
    
30. to connect to the mysql database and look at the grant tables:
    
31. 
    
32.     shell> /usr/bin/mysql -u root mysql
    
33.     mysql> show tables;
    
34. 
    
35. Try 'mysqld --help' if you have problems with paths.  Using
    
36. --general-log gives you a log in /overlay/mnt/data/mysql that may be helpful.
    
37. 
    
38. The latest information about mysql_install_db is available at
    
39. https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
    
40. You can find the latest source at https://downloads.mariadb.org and
    
41. the maria-discuss email list at https://launchpad.net/~maria-discuss
    
42. 
    
43. Please check all of the above before submitting a bug report
    
44. at http://mariadb.org/jira
    

复制代码

先说一下我的openwrt，是先把优盘作为了软件的安装目录，不知道这个会不会有影响。之前没这样才做，直接安装在flash里面的话，用mysql_install_db创建表的时候会提示储存空间不足。


luci里面也能检测到