Jump to content
  • 0

SQL schema previleges


bazerald

Question


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  2
  • Reputation:   0
  • Joined:  10/29/12
  • Last Seen:  

Hello i did all the guide lines. However when i log in to the MySQL adminstrator and choose User administrtor then select ragnarok (user account) the schema privileges. HEre is the problems. It suppose to be show all the data that we did in MySQL Query Browser but all those executed main and logs do not show in available priveleges. so i cannot select "<<" from available to assinged privileges.

I did check in the catalog and all the executed is there.

I know i must did something wrong but i just dun quite know where i make error.

i dun know why but i keep on failling on uploading the image

thx for the help

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   593
  • Joined:  10/26/11
  • Last Seen:  

i dun know why but i keep on failling on uploading the image

Try uploading the image to: http://imgur.com/

then copy the code below BBCode (message boards & forums).

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  2
  • Reputation:   0
  • Joined:  10/29/12
  • Last Seen:  

ok thx. Btw is there any guide for renewal RO but offline? coz if the offline is working then making it online is even easier

ok here is the link. 9jX5n.png.

and this is the second image. The first image is the catalog this one is suppose to set all that in the catalog to be availabe but i just cannot set it

jAyMg.png

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   174
  • Joined:  12/14/11
  • Last Seen:  

login using your query browser / phpmyadmin, then put this on the SQL execution box:

mysql> GRANT ALL ON ragnarok.* TO ragnarok@'%' IDENTIFIED BY '<your password here>';

then, do

FLUSH PRIVILEGES;

and it should do the tricks.

and the method of making the server is always offline then online. it's always.

Link to comment
Share on other sites

Join the conversation

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

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  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...