Skip to content

Default installation target does not work for existing databases

For a current setup I am working on, I am provided with an existing databases that will be used for the setup of caosdb.

I set up the options in .config, but during running make install I get:

A database with with the name '...' exists already.
Call 'make drop-...' to delete that database or change the database
name in your .config file 
./utils/make_db grant
Granting admin privileges to '...'@'localhost'
ERROR 1227 (42000) at line 1: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
make: *** [Makefile:44: _grant] Error 1

Is there an automated way to set up the existing database for this use case?

DoD

  • There is a configuration option in the mysqlbackend config, that allows an installation in an existing database.

Known problems

  • SUPER privileges on the existing database are required to be able to create functions and procedures.
Edited by Daniel Hornung
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information