Jump to content
  • 0

SQL schema previleges


Question

Posted

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

3 answers to this question

Recommended Posts

Posted

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

Posted

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.

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...