Database Security. Database Auditing. Database Caching. Database Masking. Get it nowProblem setting user priveleges while configuring greensql
Hey there,
I hope you can help me with this thing I consider not a big deal. I run dpkg-reconfigure greensql-fw and this is what I get. Does anybody know, how I can give "green_admin" the correct rights to set up the user "green"?
Thanks a lot for any efforts. Greets, aureliano.
> dpkg-reconfigure greensql-fw
Stopping GreenSQL Database Firewall: greensql-fw.
mysql binary file located: /usr/bin/mysql
mysqladmin binary file located: /usr/bin/mysqladmin
Configuring mysql database
/etc/greensql/greensql.conf created according to dpkg information. See greensql.conf(5) for details.
A backup of the old config file is at /etc/greensql/greensql.conf.dpkg-old.
Values were preserved, and database settings reexamined.
Database type: mysql
Dropping database...
Database "green_db" dropped
Creating database green_db...
Setting User green privileges...
ERROR 1044 (42000) at line 1: Access denied for user 'green_admin'@'%' to database 'green_db'
Failed to grant permissions
run dpkg-reconfigure greensql-fw to change the settings
G
Comments
Hey guys, I got it. I do not
Hey guys,
I got it. I do not know how it works exactly but I started the script greensql-create-db directly, then everything worked fine on Debian 5.0.
greets
aureliano