Bug #17396 | cant assign user access | ||
---|---|---|---|
Submitted: | 14 Feb 2006 19:59 | Modified: | 5 Sep 2006 0:30 |
Reporter: | Andrew Stolarz | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Administrator | Severity: | S1 (Critical) |
Version: | 1.1.3 | OS: | MacOS (OSX 10.4.4 SERVER) |
Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
Tags: | User Management |
[14 Feb 2006 19:59]
Andrew Stolarz
[14 Feb 2006 20:00]
Andrew Stolarz
It also works on 10.3.9 Server.
[20 Feb 2006 21:13]
Andrew Stolarz
OK, I found the exact bug and how to repliacte it. First off I want to say I got it working on 10.4.4 server. (problem also happens in 10.4.4 client so its to do with the administrator module.) when creating a user, you CAN NOT press save on that window without adding a host (and entering your IP) which you can connect from. Then you select "schema priviliges" and it will tell you that you need to save, at this point you can save. and assign the priviliges. and then access the database with the newly created user. ----------- If you create a user and press save, then go and add a host for that user. and try to connect to the database. it says you dont have access priviliges. I can repeat this over and over. ----------- however, I do sometimes get the redraw issue when trying to select my privilages and transfering them over. sometime it works, sometimes the redraw of that image will not allow me to transfer the privilages becuase the button is being blocked. this happens much much more on 10.4.4 server rather then the 10.4 client. hope this helps!
[3 Mar 2006 13:15]
Domas Mituzas
a screenshot displaying unclickable region
Attachment: Picture 2.png (image/png, text), 125.60 KiB.
[3 Mar 2006 13:17]
Domas Mituzas
Verified with 1.1.3 on MacOSX 10.4.5 The error label captures all clicks to the region, even lists are refreshed over it.
[28 Apr 2006 18:24]
Alfredo Kojima
The problem of the big text blocking everything is solved, but I do not understand the other problem. If I add a user and click save, it will warn me that I have to "add at least one host from where it can connect from". If I then add a Host to that user and assign privileges, I can assign privileges and connect to the host, but only after Saving again. Can you confirm whether you are saving after making all changes?
[4 May 2006 19:23]
Andrew Stolarz
These are the exact steps I am doing. (please do not click anywhere else unless I specified in the writing) as this is a sequence of events issue. 1. I log into the administrator module using "localhost" and root. and press connect. 2. I go to the accounts option and press the add user button. I put "andrew" as the user name and password, after I type in my confirm password I select "save changes" it gives me a message saying "no hosts defined for user" 3. After pressing OK on that message, I dropdown the andrew user using the arrow option right next to it. I select ADD hosts and I used the following IP "192.168.1.%" and press ADD. 4. right away I select "schema privileges" tab, (as you can see its using "andrew@192.168.1.%" as the host). 5. I select my database and assign all the privileges to the user and press "save changes" 6. I quit the administrator module, and reopen it up again. 7. for the hostname, I use the server IP address which is, 192.168.1.140, username and password are "andrew" and press connect. 8. I get a message saying "connection error, could not connect to mysql instance at 192.168.1.140, error: access denied for user andrew@192.168.1.140 etc etc I know the working method around this, however its a really annoying little bug if you do it in this order.
[5 Sep 2006 0:30]
Alfredo Kojima
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html