Jump to content

ERROR #1047 no answers anywhere?


gostly

Recommended Posts

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
Link to comment
Share on other sites

[!--quoteo(post=345410:date=Feb 13 2006, 12:13 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 13 2006, 12:13 PM) [snapback]345410[/snapback][/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...
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.