docker安装nextcloud,使用MySQL有问题

使用docker安装,
docker run -d -p 8000:80 --name nextcloud --restart=always -v /nas/nextcloud:/var/www/html/data -v /home/nextcloud/html:/var/www/html -v /home/nextcloud/apps:/var/www/html/custom_apps -v /home/nextcloud/config:/var/www/html/config -v /home/nextcloud/theme:/var/www/html/theme nextcloud
随后可以使用IP地址登录,但是在创建地址,使用MySQL后,无法登陆。
2021-10-31_20-17

我的MySQL使用docker安装,此处填写的是mysql在docker内部的IP地址。
还有就是图片中的远程地址,我的局域网中并没有这个地址的设备。
最后,当我使用sqlite完成安装时,可以正常成功。附上nextcloud日志:

{"reqId":"fGi1H3ZJqUXBxNifOdr7","level":2,"time":"2021-10-31T12:19:24+00:00","remoteAddr":"192.168.1.111","user":"--","app":"no app in context","method":"GET","url":"/index.php","message":"Host 192.168.1.2 was not connected to because it violates local access rules","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2"}
{"reqId":"1UMZ04weMUBxbzriHkoZ","level":3,"time":"2021-10-31T12:19:47+00:00","remoteAddr":"192.168.1.111","user":"spiritcoder","app":"index","method":"GET","url":"/index.php/apps/files/","message":"An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size","Code":1038,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1728,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1667,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1040,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT `share`.`id`, `share`.`share_type`, `share`.`share_with`, `share`.`uid_owner`, `share`.`uid_initiator`, `share`.`parent`, `share`.`item_type`, `share`.`item_source`, `share`.`item_target`, `share`.`file_source`, `share`.`file_target`, `share`.`permissions`, `share`.`stime`, `share`.`accepted`, `share`.`expiration`, `share`.`token`, `share`.`mail_send`, `share_circle`.`unique_id` AS `share_circle_unique_id`, `share_circle`.`name` AS `share_circle_name`, `share_circle`.`display_name` AS `share_circle_display_name`, `share_circle`.`sanitized_name` AS `share_circle_sanitized_name`, `share_circle`.`source` AS `share_circle_source`, `share_circle`.`description` AS `share_circle_description`, `share_circle`.`settings` AS `share_circle_settings`, `share_circle`.`config` AS `share_circle_config`, `share_circle`.`contact_addressbook` AS `share_circle_contact_addressbook`, `share_circle`.`contact_groupname` AS `share_circle_contact_groupname`, `share_circle`.`creation` AS `share_circle_creation`, `share_circle_owner`.`circle_id` AS `share_circle_owner_circle_id`, `share_circle_owner`.`member_id` AS `share_circle_owner_member_id`, `share_circle_owner`.`single_id` AS `share_circle_owner_single_id`, `share_circle_owner`.`user_id` AS `share_circle_owner_user_id`, `share_circle_owner`.`instance` AS `share_circle_owner_instance`, `share_circle_owner`.`user_type` AS `share_circle_owner_user_type`, `share_circle_owner`.`level` AS `share_circle_owner_level`, `share_circle_owner`.`status` AS `share_circle_owner_status`, `share_circle_owner`.`note` AS `share_circle_owner_note`, `share_circle_owner`.`contact_id` AS `share_circle_owner_contact_id`, `share_circle_owner`.`cached_name` AS `share_circle_owner_cached_name`, `share_circle_owner`.`cached_update` AS `share_circle_owner_cached_update`, `share_circle_owner`.`contact_meta` AS `share_circle_owner_contact_meta`, `share_circle_owner`.`joined` AS `share_circle_owner_joined`, `share_initiator`.`circle_id` AS `share_initiator_circle_id`, `share_initiator`.`member_id` AS `share_initiator_member_id`, `share_initiator`.`single_id` AS `share_initiator_single_id`, `share_initiator`.`user_id` AS `share_initiator_user_id`, `share_initiator`.`instance` AS `share_initiator_instance`, `share_initiator`.`user_type` AS `share_initiator_user_type`, `share_initiator`.`level` AS `share_initiator_level`, `share_initiator`.`status` AS `share_initiator_status`, `share_initiator`.`note` AS `share_initiator_note`, `share_initiator`.`contact_id` AS `share_initiator_contact_id`, `share_initiator`.`cached_name` AS `share_initiator_cached_name`, `share_initiator`.`cached_update` AS `share_initiator_cached_update`, `share_initiator`.`contact_meta` AS `share_initiator_contact_meta`, `share_initiator`.`joined` AS `share_initiator_joined`, `share_initiator_inheritedby`.`circle_id` AS `share_initiator_inheritedby_circle_id`, `share_initiator_inheritedby`.`member_id` AS `share_initiator_inheritedby_member_id`, `share_initiator_inheritedby`.`single_id` AS `share_initiator_inheritedby_single_id`, `share_initiator_inheritedby`.`user_id` AS `share_initiator_inheritedby_user_id`, `share_initiator_inheritedby`.`instance` AS `share_initiator_inheritedby_instance`, `share_initiator_inheritedby`.`user_type` AS `share_initiator_inheritedby_user_type`, `share_initiator_inheritedby`.`level` AS `share_initiator_inheritedby_level`, `share_initiator_inheritedby`.`status` AS `share_initiator_inheritedby_status`, `share_initiator_inheritedby`.`note` AS `share_initiator_inheritedby_note`, `share_initiator_inheritedby`.`contact_id` AS `share_initiator_inheritedby_contact_id`, `share_initiator_inheritedby`.`cached_name` AS `share_initiator_inheritedby_cached_name`, `share_initiator_inheritedby`.`cached_update` AS `share_initiator_inheritedby_cached_update`, `share_initiator_inheritedby`.`contact_meta` AS `share_initiator_inheritedby_contact_meta`, `share_initiator_inheritedby`.`joined` AS `share_initiator_inheritedby_joined`, `share_memberships`.`single_id` AS `share_initiator_inheritedby_memberships_single_id`, `share_memberships`.`circle_id` AS `share_initiator_inheritedby_memberships_circle_id`, `share_memberships`.`level` AS `share_initiator_inheritedby_memberships_level`, `share_memberships`.`inheritance_first` AS `share_initiator_inheritedby_memberships_inheritance_first`, `share_memberships`.`inheritance_last` AS `share_initiator_inheritedby_memberships_inheritance_last`, `share_memberships`.`inheritance_path` AS `share_initiator_inheritedby_memberships_inheritance_path`, `share_memberships`.`inheritance_depth` AS `share_initiator_inheritedby_memberships_inheritance_depth`, `share_initiator_basedon`.`unique_id` AS `share_initiator_basedon_unique_id`, `share_initiator_basedon`.`name` AS `share_initiator_basedon_name`, `share_initiator_basedon`.`display_name` AS `share_initiator_basedon_display_name`, `share_initiator_basedon`.`sanitized_name` AS `share_initiator_basedon_sanitized_name`, `share_initiator_basedon`.`source` AS `share_initiator_basedon_source`, `share_initiator_basedon`.`description` AS `share_initiator_basedon_description`, `share_initiator_basedon`.`settings` AS `share_initiator_basedon_settings`, `share_initiator_basedon`.`config` AS `share_initiator_basedon_config`, `share_initiator_basedon`.`contact_addressbook` AS `share_initiator_basedon_contact_addressbook`, `share_initiator_basedon`.`contact_groupname` AS `share_initiator_basedon_contact_groupname`, `share_initiator_basedon`.`creation` AS `share_initiator_basedon_creation`, `share_filecache`.`fileid` AS `share_filecache_fileid`, `share_filecache`.`path` AS `share_filecache_path`, `share_filecache`.`permissions` AS `share_filecache_permissions`, `share_filecache`.`storage` AS `share_filecache_storage`, `share_filecache`.`path_hash` AS `share_filecache_path_hash`, `share_filecache`.`parent` AS `share_filecache_parent`, `share_filecache`.`name` AS `share_filecache_name`, `share_filecache`.`mimetype` AS `share_filecache_mimetype`, `share_filecache`.`mimepart` AS `share_filecache_mimepart`, `share_filecache`.`size` AS `share_filecache_size`, `share_filecache`.`mtime` AS `share_filecache_mtime`, `share_filecache`.`storage_mtime` AS `share_filecache_storage_mtime`, `share_filecache`.`encrypted` AS `share_filecache_encrypted`, `share_filecache`.`unencrypted_size` AS `share_filecache_unencrypted_size`, `share_filecache`.`etag` AS `share_filecache_etag`, `share_filecache`.`checksum` AS `share_filecache_checksum`, `share_filecache_storages`.`id` AS `share_filecache_storages_id`, `share_share`.`id` AS `child_id`, `share_share`.`file_target` AS `child_file_target`, `share_share`.`permissions` AS `child_permissions` FROM `oc_share` `share` LEFT JOIN `oc_circles_circle` `share_circle` ON `share_circle`.`unique_id` = `share`.`share_with` LEFT JOIN `oc_circles_membership` `share_memberships` ON (`share_memberships`.`single_id` = ?) AND (`share_memberships`.`circle_id` = `share`.`share_with`) LEFT JOIN `oc_filecache` 

请问解决了吗?我也遇到同样的问题