Cannot Edit User

[spoowiz]

Hi,

I just started using sqlyog. Logs in fine to the remote database using user “vantag2_test” with all permissions. However when I try to “edit user”, it gives “error 1142 … “. Please note the weird qualifying string after the user name. Attached is the screen shot of the err msg.

btw, “add user” also does the same thing.

The mysql db is on a web host (lunarpages.com).

“Edit User” seems to work fine for a local mysql db.

What can I do to fix the problem?

thank you,

phil

[CalEvans]

Quote:

Please note the weird qualifying string after the user name.

That's your machine name.

From your root account, either add a user for that user with that as the 'New Host' or add a user with '%' in the 'New Host' field. (Or change your existing record to '%' in 'New Host.')

I'm not sure if it's true anymore but I used to (MySQL v3.x) have to add each user in twice. Once with localhost and once with %.

HTH,

=C=

[spoowiz]

CalEvans wrote on Mar 19 2004, 02:01 PM:

From your root account, either add a user for that users with that as the 'New Host' or add a user with '%' in the 'New Host' field. (Or change your existing record to '%' in 'New Host.')

I'm not sure if it's true anymore but I used to (MySQL v3.x) have to add each user in twice. Once with localhost and once with %.

HTH,

=C=

hi,

“root account”? how do I get there?

from any of the users, i cannot access “edit user” or “add user”.

/pt

[CalEvans]

If you run this server then you should have the root account and password info. Check the mysql docs for more info.

If this server is run by your ISP then you most likely won't be able to get to teh root account but you can ask them to perform the tasks.

[spoowiz]

Thanks. Basically what I'm findins is that I cannot manage the users from fron-end programs. I have to do it from the hosting control panel.

thanks.

[Shadow]

Then do as Cal has suggested from the hosting control panel!

[Author]

Posts