I acedently deletet my oc_admin user

Hello this is my first Post so how i said i deltet my oc_admin sql user .
If i am runnig sudo -u www-data php occ statusi am getting this massage An unhandled exception has been thrown: Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'oc_admin'@'localhost' (using password: YES) in /var/www/html/nextcloud/lib/private/DB/Connection.php:67 Stack trace: #0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(889): OC\DB\Connection->connect() #1 /var/www/html/nextcloud/lib/private/DB/Connection.php(194): Doctrine\DBAL\Connection->executeQuery() #2 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(200): OC\DB\Connection->executeQuery() #3 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(216): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /var/www/html/nextcloud/lib/private/AppConfig.php(331): OC\DB\QueryBuilder\QueryBuilder->execute() #5 /var/www/html/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues() #6 /var/www/html/nextcloud/lib/private/AppConfig.php(287): OC\AppConfig->getApps() #7 /var/www/html/nextcloud/lib/private/legacy/OC_App.php(883): OC\AppConfig->getValues() #8 /var/www/html/nextcloud/lib/private/Server.php(665): OC_App::getAppVersions() #9 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}() #10 /var/www/html/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet() #11 /var/www/html/nextcloud/lib/private/Server.php(1704): OC\ServerContainer->query() #12 /var/www/html/nextcloud/lib/private/Server.php(856): OC\Server->getMemCacheFactory() #13 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}() #14 /var/www/html/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet() #15 /var/www/html/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query() #16 /var/www/html/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}() #17 /var/www/html/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet() #18 /var/www/html/nextcloud/lib/private/Server.php(1894): OC\ServerContainer->query() #19 /var/www/html/nextcloud/lib/private/legacy/OC_App.php(347): OC\Server->getAppManager() #20 /var/www/html/nextcloud/lib/private/legacy/OC_App.php(114): OC_App::getEnabledApps() #21 /var/www/html/nextcloud/lib/base.php(648): OC_App::loadApps() #22 /var/www/html/nextcloud/lib/base.php(1095): OC::init() #23 /var/www/html/nextcloud/console.php(49): require_once('/var/www/html/n...') #24 /var/www/html/nextcloud/occ(11): require_once('/var/www/html/n...')

How can i getting the user back without reinstall nextcloud ?

You can’t just re-create the MySQL user?

1 Like

I dont kwno wat permissions it shut get and the correct name and host and password