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

[ron]

On Friday 27 February 2004 20:59, Charlie Reinl wrote:
> 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
>

I think I miss something ?
I follows your instructions and after making the new connection I see 
mydell at ...40... (mysql) in the tree. Clicking on the + before it I got a 
error message.

What strange is for me is there are no users/dbs on the second connection.
When I let the database/user/password empty I get the second connection ok.

I think this new user should not be able to open the mysql database at all.
After the mydell as user is made, I see in the DB table is there a record for 
this user at database mysql, all priv's at N.
Not as admin created and have access to db.mysql ?

Using the delete record does not work. Open another database table and try it 
there. Did also not work. Had to use Save first. Back to the mysql db and try 
again to delete the record and save. The record stay's, no delete performed.
With phpadmin it can be done.
Recreate the user mydell doesn't pass, it exists already.

Your 4'th point. do you mean the db.mysql in the new connection? I can't.
In the orginal opened db?. yes shure that is me, a admin and I can pass
every stupid sql line to give everyone the most stupid right's. Biggg smileee.

That the not admin user is Admin now isn't true. He was it already but without 
rights. The Update you provide gives him only the privilege to do something, 
he could not do as user, with global rights and because he is already admin 
(acces in the db table to mysql) he is now full admin too.

The wrong thing is he has a record in the db table to the mysql db.
Any way I can create a new connetion but when I give a user name it can't be 
opened.

Ron



-------------- next part --------------
A non-text attachment was scrubbed...
Name: snap1.png
Type: image/png
Size: 9788 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20040228/ed4c0207/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: snap2.png
Type: image/png
Size: 15945 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20040228/ed4c0207/attachment-0001.png>