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.