Problem setting user priveleges while configuring greensql

1 reply
aureliano
aureliano's picture
Joined: 01/30/2010
User offline. Last seen 6 days 15 hours ago.

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

aureliano
aureliano's picture
Joined: 01/30/2010
User offline. Last seen 6 days 15 hours ago.

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

Back to top