[Gambas-user] is it gambas or is ti mysql

[Charlie Reinl]

Salut,

pleas try the following:
- open a mysql - connection 
- use the gambas-database-manger and create a user which is NOT Admin
- open for this user a connection
- go to the mysql database and open the request

-copy this to the request window and start it ( change the user in the Where 
contition to you user)

Update  user SET  user.Select_priv = 'Y', user.Insert_priv = 'Y' , 
user.Update_priv = 'Y' , user.Delete_priv  = 'Y', user.Create_priv = 'Y' , 
user.Drop_priv = 'Y'  Where  user.User ='<user>'

- I that works that user is Admin now

On mysql 4.0.16 it is not a problem to do that.

Amicalement
Charlie