SEO

Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it.

The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do.

Any thoughts?

Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it.

Have you reported a bug to bugs.mysql.com ?


kind regards

--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Mobile: +614 12 593 292 / Skype: colincharles
Web: http://www.bytebot.net/blog/

MySQL Forge: http://forge.mysql.com/

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it.
>
> The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do.
>
> Any thoughts?
>
Hello! I think, that you haven't chosen a host for user. Choose it and
user options will be enabled to edit.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFrwYIn6e/N0YuRmcRAmJuAJ4u50WeNgr+fuTudhwXNk0mvi7VsACgpk1b
sNzrOlk/rpVfD8ssw6hukUo=
=Z2sQ
-----END PGP SIGNATURE-----

I don't have any way of selecting a host. I only have one host on my system and I don't see anything in the program that explicitly shows me where to select the host.

>>> Igor Alexandrov <alexandrov@tversu.ru> 1/17/07 9:30 PM >>>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it.
>
> The problem is that when you select a user in the user list of the prog the user's detail don't appear on the right side so that they can be edited. If I right click on the user in the list then the only enabled options are Add, Refresh and Show Hosts. If I add a user, there's nothing else I can do it. The new user shows up in the list but I can't modify it or delete it. I'm logged in a root. I don't know what else to do.
>
> Any thoughts?
>
Hello! I think, that you haven't chosen a host for user. Choose it and
user options will be enabled to edit.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org ( http://enigmail.mozdev.org/ )

iD8DBQFFrwYIn6e/N0YuRmcRAmJuAJ4u50WeNgr+fuTudhwXNk0mvi7VsACgpk1b
sNzrOlk/rpVfD8ssw6hukUo=
=Z2sQ
-----END PGP SIGNATURE-----

Are you working on a Mac? If so, logging in as root is not good
enough. You must have set up and log into the root user account of
your Mac computer or server. This, if anything is a Apple problem and
advantage. The Administrator is opening to the account you are in,
the login in window will accept any correct password combination
under ShadowHash or other authorising protocol, but you will still be
working in the account you are in with those privileges. HTH
Daniel Culver
danielculver@mac.com



On Jan 17, 2007, at 4:49 PM, Ed Reed wrote:

> Unable to manage user accounts through MySQL Administrator 1.2.8.
> I've found that I'm not the only one with this problem but no one
> seems to have an answer for it.
>
> The problem is that when you select a user in the user list of the
> prog the user's detail don't appear on the right side so that they
> can be edited. If I right click on the user in the list then the
> only enabled options are Add, Refresh and Show Hosts. If I add a
> user, there's nothing else I can do it. The new user shows up in
> the list but I can't modify it or delete it. I'm logged in a root.
> I don't know what else to do.
>

Thanks for the reply Daniel,

This is not on a Mac. I'm running MySQL Administrator 1.2.8 on a XP/SP2 machine and I'm connecting to a MySQL 5.1.9 server running on Netware6.5.

- Still looking for help.

>>> Daniel Culver <culver@rapidcable.com> 1/19/07 9:52 AM >>>
Are you working on a Mac? If so, logging in as root is not good
enough. You must have set up and log into the root user account of
your Mac computer or server. This, if anything is a Apple problem and
advantage. The Administrator is opening to the account you are in,
the login in window will accept any correct password combination
under ShadowHash or other authorising protocol, but you will still be
working in the account you are in with those privileges. HTH
Daniel Culver
danielculver@mac.com



On Jan 17, 2007, at 4:49 PM, Ed Reed wrote:

> Unable to manage user accounts through MySQL Administrator 1.2.8.
> I've found that I'm not the only one with this problem but no one
> seems to have an answer for it.
>
> The problem is that when you select a user in the user list of the
> prog the user's detail don't appear on the right side so that they
> can be edited. If I right click on the user in the list then the
> only enabled options are Add, Refresh and Show Hosts. If I add a
> user, there's nothing else I can do it. The new user shows up in
> the list but I can't modify it or delete it. I'm logged in a root.
> I don't know what else to do.
>

On 1/19/07, Daniel Culver <culver@rapidcable.com> wrote:
> Are you working on a Mac? If so, logging in as root is not good
> enough. You must have set up and log into the root user account of
> your Mac computer or server.

The OP is talking about managing MySQL accounts with MySQL
Administrator. MySQL Administrator does not in any way allow you to
login to a host with a shell account, root or otherwise.

--
Kevin.

Actually on my Mac; 10.4.6 ppc the MySQL Administrator will only open
to a connection through localhost. The localhost connection will
accept any authorised user to connect, but, MySQL Administrator will
only assume the privileges of the account I am working from (I have
several). It has been this way for a couple of years and through a
few upgrades; it very well could be that I have something configured
or installed wrong. What do you think?
Daniel Culver
danielculver@mac.com



On Jan 20, 2007, at 7:04 PM, Kevin Spencer wrote:

> On 1/19/07, Daniel Culver <culver@rapidcable.com> wrote:
>> Are you working on a Mac? If so, logging in as root is not good
>> enough. You must have set up and log into the root user account of
>> your Mac computer or server.
>
> The OP is talking about managing MySQL accounts with MySQL
> Administrator. MySQL Administrator does not in any way allow you to
> login to a host with a shell account, root or otherwise.
>
> --
> Kevin.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=culver@rapidcable.com
>

Dear all,

I exactly have the same problem as Ed Reed.
I can add new users but I'm unable to edit them afterwards.

I'm using Mysql 6.0.3 and Mysql Administrator 1.2.12.
Mysql 6.0.3 running on a Windows 2003 Server machine.
Mysql Administrator 1.2.12 running on Vista x32 Ultimate.

Do you have any further suggestions or did you already solve the problem (if yes, how?)?

Thank you and br
Thomas