[SQL] permissions, or lack there of. - Tilted Forum Project Discussion Community

Dilbert1234567 · 05-14-2004, 10:10 AM

ok so i messed some things up seriously wiht my SQL server, i was changing the permissions (to get IIS up and running properly) and i removed the a user that needed to be there and when i try to start the server it says access denied, how can i fix this, or am i compleatly screwed. it does not contain much info and is not a nessesity to get back, but it would save me a lot of time.

thanks

Fallon · 05-14-2004, 11:05 AM

If you accidentally just deleted the user (how'd you accomplish that? Did you delete the user, or the whole user table?) regrant them the permissions.

PHP Code:


			
grant all <put all the permissions here> on <databasename>.<tablename> TO <user you deleted>@<host where they should be connecting from> IDENTIFIED BY "password";

For myself on my MySQL server, I'd do

PHP Code:


			
GRANT ALL ON mud.* TO fallon@localhost IDENTIFIED BY "temp123";

Dilbert1234567 · 05-14-2004, 02:55 PM

not on a data base, but the entire server.

i removed a user (the wrong user) from the users part of the data base. i ment to do the IIS one but removed the wrong one.

Fallon · 05-14-2004, 03:35 PM

k, then do

PHP Code:


			
GRANT ALL ON *.* TO <user>@<host> IDENTIFIED BY "temp123";

Just be careful though because if you give them all the permissions, you know what can happen.

Dilbert1234567 · 05-14-2004, 03:53 PM

where can i run this command, i cant even get the server started.

Fallon · 05-14-2004, 03:58 PM

What environment are you running it in. I'm assuming you're running it in Windows cause you said IIS.
What SQL server are you running, MS SQL or MySQL?
if you are running MS SQL, gonna need someone elses help, if it's MySQL then just check the config and restart the server.

Fallon · 05-14-2004, 04:03 PM

Dilbert, if you need quicker help then thru here, you can message me in AIM at CyphirX or on MSN at MrCyphir(at)hotmail.com

Dilbert1234567 · 05-14-2004, 04:52 PM

thanks fallon, im running ms sql

im just going to uninstall it all and re install it. it will be much easier, the data is not important.

Fallon · 05-14-2004, 06:00 PM

Ahh, that's no fun =p
Why go the easy way when you can try to learn it.

I'm also restraining myself not sayin you should try MySQL...=p

Dilbert1234567 · 05-15-2004, 08:06 AM

ok i finaly got it:

i copyied the 2 data base files and moved them from the directory, then i removed ms SQL server, reinstalled it, removed all the servers, created new server, created a data base named the same, halted the server, switched the files, and restarted the server.

and it works fine now.

Fallon · 05-15-2004, 04:48 PM

Holy crap...
Woah...
I woulda just gotten a visual program to create a backup of the server and store a copy on the comp, reinstalled if you had to or just created a new user via the visual program and then restored the backup...

Dilbert1234567 · 05-17-2004, 07:26 PM

i could not even start the server to back it up.

05-14-2004, 10:10 AM	#1 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	[SQL] permissions, or lack there of. ok so i messed some things up seriously wiht my SQL server, i was changing the permissions (to get IIS up and running properly) and i removed the a user that needed to be there and when i try to start the server it says access denied, how can i fix this, or am i compleatly screwed. it does not contain much info and is not a nessesity to get back, but it would save me a lot of time. thanks __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-14-2004, 11:05 AM	#2 (permalink)
Fallon Junkie Location: RI	If you accidentally just deleted the user (how'd you accomplish that? Did you delete the user, or the whole user table?) regrant them the permissions. PHP Code: `grant all <put all the permissions here> on <databasename>.<tablename> TO <user you deleted>@<host where they should be connecting from> IDENTIFIED BY "password";` For myself on my MySQL server, I'd do PHP Code: `GRANT ALL ON mud.* TO fallon@localhost IDENTIFIED BY "temp123";`

05-14-2004, 02:55 PM	#3 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	not on a data base, but the entire server. i removed a user (the wrong user) from the users part of the data base. i ment to do the IIS one but removed the wrong one. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-14-2004, 03:35 PM	#4 (permalink)
Fallon Junkie Location: RI	k, then do PHP Code: `GRANT ALL ON . TO <user>@<host> IDENTIFIED BY "temp123";` Just be careful though because if you give them all the permissions, you know what can happen.

05-14-2004, 03:53 PM	#5 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	where can i run this command, i cant even get the server started. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-14-2004, 03:58 PM	#6 (permalink)
Fallon Junkie Location: RI	What environment are you running it in. I'm assuming you're running it in Windows cause you said IIS. What SQL server are you running, MS SQL or MySQL? if you are running MS SQL, gonna need someone elses help, if it's MySQL then just check the config and restart the server. Last edited by Fallon; 05-14-2004 at 04:01 PM..

05-14-2004, 04:03 PM	#7 (permalink)
Fallon Junkie Location: RI	Dilbert, if you need quicker help then thru here, you can message me in AIM at CyphirX or on MSN at MrCyphir(at)hotmail.com

05-14-2004, 04:52 PM	#8 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	thanks fallon, im running ms sql im just going to uninstall it all and re install it. it will be much easier, the data is not important. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-14-2004, 06:00 PM	#9 (permalink)
Fallon Junkie Location: RI	Ahh, that's no fun =p Why go the easy way when you can try to learn it. I'm also restraining myself not sayin you should try MySQL...=p

05-15-2004, 08:06 AM	#10 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	ok i finaly got it: i copyied the 2 data base files and moved them from the directory, then i removed ms SQL server, reinstalled it, removed all the servers, created new server, created a data base named the same, halted the server, switched the files, and restarted the server. and it works fine now. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-15-2004, 04:48 PM	#11 (permalink)
Fallon Junkie Location: RI	Holy crap... Woah... I woulda just gotten a visual program to create a backup of the server and store a copy on the comp, reinstalled if you had to or just created a new user via the visual program and then restored the backup...

05-17-2004, 07:26 PM	#12 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	i could not even start the server to back it up. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen