469,090 Members | 1,252 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Resetting permissions on Windows

If I am using Win98 SE (yes yes, I agree...), will underneath still
work:
http://www.mysql.com/doc/en/Resetting_permissions.html ?
I have tryed to follow above and similar advices, but haven't had a
lot of luck.
I will try again soon, but I was wondering wether there was an easier
way
(e.g. if there was a "reset" command I could run that also works on
Win98).

The long story is:

OK, so I have a MySql (4.0.15) server running
on a Win98 SE (for testing against over LAN).

We had 2 accounts set up.
1) Our "admin": root@localhost [+ password]
2) Our "normal": MyUserName%ChosenHosts [+ password]

I was using MySqlFront and discovered that "MyUserName"
did not have *Select* priviledges.. "OK (that is really odd)" I
thought
(even more so since using "SELECT" had shown to work).

Then I took a look (from the admin account - localhost) on the admin
account..
It did not have *Grant*. Now... That was probably stupid, but I
decided to
try give it *Grant* (I know, seems odd, how to grant without having
grant,
but.. "Worth a try" I figured) from MySqlFront (I did not see/save the
SQL
it generated)...

And now.. I am locked out...I can no longer connect to it with the
"root" account....
I get "access denied for user " (bla bla). Error 1045.
I can however still connect from the "MyUserName" account

best regards
Thomas
Jul 19 '05 #1
3 1949
> (e.g. if there was a "reset" command I could run that also works on
Win98).


OK, I have it working now. From memory:

Mysqld --skip-grant-tables
Start MySqlFront, log in, modify user tables (create root)
Log out/in and set password.
thanks
Thomas Schulz
Jul 19 '05 #2
> (e.g. if there was a "reset" command I could run that also works on
Win98).


OK, I have it working now. From memory:

Mysqld --skip-grant-tables
Start MySqlFront, log in, modify user tables (create root)
Log out/in and set password.
thanks
Thomas Schulz
Jul 19 '05 #3
> (e.g. if there was a "reset" command I could run that also works on
Win98).


OK, I have it working now. From memory:

Mysqld --skip-grant-tables
Start MySqlFront, log in, modify user tables (create root)
Log out/in and set password.
thanks
Thomas Schulz
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Thomas | last post: by
1 post views Thread by Jeff | last post: by
2 posts views Thread by Ryan Ternier | last post: by
10 posts views Thread by John Salerno | last post: by
2 posts views Thread by Budhi Saputra Prasetya | last post: by
reply views Thread by Budhi Saputra Prasetya | last post: by
3 posts views Thread by Simon Watkins | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.