mysql install db失败_错误:mysql_intinstall_db时权限被拒绝

我尝试将Mariadb安装在位于TurrisOS上的LXC容器中的空白AlpineLinux3.6上(OpenWrtOmnia15.05R47055)。

安装失败,出现“许可被拒绝”错误。我改变了特权,但Instalataror还是失败了。

root@alpinelxccontainer:~# DB_DATA_PATH="/var/lib/mysql"

root@alpinelxccontainer:~# DB_ROOT_PASS="heslo"

root@alpinelxccontainer:~# DB_USER="mariadb_user"

root@alpinelxccontainer:~# DB_PASS="heslo"

root@alpinelxccontainer:~# MAX_ALLOWED_PACKET="200M"

root@alpinelxccontainer:~# mysql_install_db --user=mysql --datadir=${DB_DATA_PATH}

WARNING: The host 'alpinelxccontainer' could not be looked up with /usr/bin/resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MariaDB version. The MariaDB 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 MariaDB privileges !

Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...

2018-07-25 22:14:30 3069281488 [Note] /usr/bin/mysqld (mysqld 10.1.32-MariaDB) starting as process 1876 ...

2018-07-25 22:14:30 3069281488 [ERROR] mysqld: Can't create/write to file '/var/lib/mysql/aria_log_control' (Errcode: 13 "Permission denied")

2018-07-25 22:14:30 3069281488 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/var/lib/mysql/aria_log_control'

2018-07-25 22:14:30 3069281488 [ERROR] Plugin 'Aria' init function returned error.

2018-07-25 22:14:30 3069281488 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2018-07-25 22:14:30 3069281488 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-07-25 22:14:30 3069281488 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2018-07-25 22:14:30 3069281488 [Note] InnoDB: The InnoDB memory heap is disabled

2018-07-25 22:14:30 3069281488 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-07-25 22:14:30 3069281488 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-07-25 22:14:30 3069281488 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-07-25 22:14:30 3069281488 [Note] InnoDB: Using Linux native AIO

2018-07-25 22:14:30 3069281488 [Note] InnoDB: Using generic crc32 instructions

2018-07-25 22:14:30 3069281488 [ERROR] mysqld: Can't create/write to file '/tmp/ibXXXXXX' (Errcode: 13 "Permission denied")

2018-07-25 22:14:30 b6f184d0 InnoDB: Error: unable to create temporary file; errno: 13

2018-07-25 22:14:30 3069281488 [ERROR] Plugin 'InnoDB' init function returned error.

2018-07-25 22:14:30 3069281488 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2018-07-25 22:14:30 3069281488 [ERROR] Unknown/unsupported storage engine: InnoDB

2018-07-25 22:14:30 3069281488 [ERROR] Aborting

root@alpinelxccontainer:~# ls -la /var/lib/mysql/

total 0

drwxr-sr-x 1 mysql mysql 48 Jul 25 22:14 .

drwxr-xr-x 1 root root 36 Jul 25 22:09 ..

drwx------ 1 mysql mysql 0 Jul 25 22:14 mysql

-rw-rw---- 1 mysql mysql 0 Jul 25 22:14 mysql-bin.index

drwx------ 1 mysql mysql 0 Jul 25 22:14 test

root@alpinelxccontainer:~# chmod -R 777 /var/lib/mysql/

root@alpinelxccontainer:~# ls -la /var/lib/mysql/

total 0

drwxrwxrwx 1 mysql mysql 48 Jul 25 22:14 .

drwxr-xr-x 1 root root 36 Jul 25 22:09 ..

drwxrwxrwx 1 mysql mysql 0 Jul 25 22:14 mysql

-rwxrwxrwx 1 mysql mysql 0 Jul 25 22:14 mysql-bin.index

drwxrwxrwx 1 mysql mysql 0 Jul 25 22:14 test

root@alpinelxccontainer:~# mysql_install_db --user=mysql --datadir=${DB_DATA_PATH}

Still same error: [ERROR] mysqld: Can't create/write to file '/var/lib/mysql/aria_log_control' (Errcode: 13 "Permission denied")

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值