Jump to content


Photo

ERROR #1047 no answers anywhere?


  • Please log in to reply
3 replies to this topic

#1 gostly

gostly
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 13 February 2006 - 03:48 AM

Ok so this is what i did, i logged into my linux server through ssh...and i used this command "safe_mysqld --skip-grant-tables &" so that it'll put aside all privileges...and i use phpmyadmin to look at privileges of databases...so i select the user for the database im wanting to change the host for...because what i am trying to do is set it so that it isnt "localhost" anymore and instead it'll be a set IP address...so i try to continue and i get "ERROR 1047 - Unknown command"...this is when phpmyadmin attempts to use the GRANT command...so i really dont understand why it says unknown command...

So i searched everywhere and this problem seems to happen to people often and it's like no one has the answer to how to fix it...so im hoping that asking here someone will know and be able to help me out...please

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 February 2006 - 05:13 PM

Have you tried "FLUSH PRIVILEGES"?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 gostly

gostly
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 14 February 2006 - 04:38 AM

[!--quoteo(post=345410:date=Feb 13 2006, 12:13 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 13 2006, 12:13 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Have you tried "FLUSH PRIVILEGES"?
[/quote]

what exactly happens when you flush privileges, i read about it, i think so anyways, but kind of afraid to use it...since i dont want to mess anything up because i have several databases but i only want to change the grant options on one...

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 14 February 2006 - 08:33 PM

It just makes sure any GRANT changes are up-to-date for the database in question. It can't "do" anything.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users