Professional Web Applications Themes

Permissions issues? - MySQL

Hi, I'm using MySQL 5.0. I have several databases on localhost, all accessed by the same user/password. However, when I am in one db, SUPER_USER, and try to access a table from another db, with this statement SELECT * FROM USER1.SUMMARY_DAILY_TOTALS I get this error: #1142 - SELECT command denied to user 'myuser''localhost' for table 'SUMMARY_DAILY_TOTALS' What do I do to overcome this problem? Thanks, - Dave...

  1. #1

    Default Permissions issues?

    Hi,

    I'm using MySQL 5.0. I have several databases on localhost, all
    accessed by the same user/password. However, when I am in one db,
    SUPER_USER, and try to access a table from another db, with this
    statement

    SELECT *
    FROM USER1.SUMMARY_DAILY_TOTALS

    I get this error:

    #1142 - SELECT command denied to user 'myuser''localhost' for table
    'SUMMARY_DAILY_TOTALS'

    What do I do to overcome this problem?

    Thanks, - Dave

    laredotornado@zipmail.com Guest

  2. #2

    Default Re: Permissions issues?

    com wrote: 

    here's what you need to do:
    while logged in to the database with "myuser" run this:

    show grants current_user();

    if you don't see that myuser has select, insert, update, (blah ..)
    access to user1.* and all other databases you want him to have access to
    , then you need to grant access to myuser for the ones that are missing.

    to grant access run something like this:
    GRANT ALL ON scooby.* TO 'myuser''localhost' IDENTIFIED BY 'dooby'


    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  3. #3

    Default Re: Permissions issues?

    On May 3, 11:25 am, lark <net> wrote: 






    >
    > here's what you need to do:
    > while logged in to the database with "myuser" run this:
    >
    > show grants current_user();
    >
    > if you don't see that myuser has select, insert, update, (blah ..)
    > access to user1.* and all other databases you want him to have access to
    > , then you need to grant access to myuser for the ones that are missing.
    >
    > to grant access run something like this:
    > GRANT ALL ON scooby.* TO 'myuser''localhost' IDENTIFIED BY 'dooby'
    >
    > --
    > lark -- net
    > To reply to me directly, delete "despam".[/ref]

    Hi,

    I'm using phpMyAdmin set up at the hosting company to give some
    context. I switched to the USER1 db, and ran the "show grants
    current_user()" statement and got this error:

    #1064 - You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near 'current_user()' at line 1

    While in that DB, I also tried the statement:

    GRANT ALL ON USER1.* TO 'myuser''localhost' IDENTIFIED BY
    'mypassword'

    and got this error:

    #1044 - Access denied for user 'remanr''localhost' to database
    'USER1'

    What should I try now? - Dave

    laredotornado@zipmail.com Guest

  4. #4

    Default Re: Permissions issues?

    com wrote: 
    >> here's what you need to do:
    >> while logged in to the database with "myuser" run this:
    >>
    >> show grants current_user();
    >>
    >> if you don't see that myuser has select, insert, update, (blah ..)
    >> access to user1.* and all other databases you want him to have access to
    >> , then you need to grant access to myuser for the ones that are missing.
    >>
    >> to grant access run something like this:
    >> GRANT ALL ON scooby.* TO 'myuser''localhost' IDENTIFIED BY 'dooby'
    >>
    >> --
    >> lark -- net
    >> To reply to me directly, delete "despam".[/ref]
    >
    > Hi,
    >
    > I'm using phpMyAdmin set up at the hosting company to give some
    > context. I switched to the USER1 db, and ran the "show grants
    > current_user()" statement and got this error:
    >
    > #1064 - You have an error in your SQL syntax; check the manual that
    > corresponds to your MySQL server version for the right syntax to use
    > near 'current_user()' at line 1
    >
    > While in that DB, I also tried the statement:
    >
    > GRANT ALL ON USER1.* TO 'myuser''localhost' IDENTIFIED BY
    > 'mypassword'
    >
    > and got this error:
    >
    > #1044 - Access denied for user 'remanr''localhost' to database
    > 'USER1'
    >
    > What should I try now? - Dave
    >[/ref]
    ok! to see all permissions run this:
    show grants
    in phpMyAdmin and see what the output is!



    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  5. #5

    Default Re: Permissions issues?

    com wrote: 
    >> here's what you need to do:
    >> while logged in to the database with "myuser" run this:
    >>
    >> show grants current_user();
    >>
    >> if you don't see that myuser has select, insert, update, (blah ..)
    >> access to user1.* and all other databases you want him to have access to
    >> , then you need to grant access to myuser for the ones that are missing.
    >>
    >> to grant access run something like this:
    >> GRANT ALL ON scooby.* TO 'myuser''localhost' IDENTIFIED BY 'dooby'
    >>
    >> --
    >> lark -- net
    >> To reply to me directly, delete "despam".[/ref]
    >
    > Hi,
    >
    > I'm using phpMyAdmin set up at the hosting company to give some
    > context. I switched to the USER1 db, and ran the "show grants
    > current_user()" statement and got this error:
    >
    > #1064 - You have an error in your SQL syntax; check the manual that
    > corresponds to your MySQL server version for the right syntax to use
    > near 'current_user()' at line 1
    >
    > While in that DB, I also tried the statement:
    >
    > GRANT ALL ON USER1.* TO 'myuser''localhost' IDENTIFIED BY
    > 'mypassword'
    >
    > and got this error:
    >
    > #1044 - Access denied for user 'remanr''localhost' to database
    > 'USER1'
    >
    > What should I try now? - Dave
    >[/ref]

    You probably don't have GRANT authority on the database. This is
    generally the case with shared hosting. You have to use their control
    panel to grand authorities.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

Similar Threads

  1. Permissions issues?
    By ArtGekko in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: February 7th, 08:15 AM
  2. Contribute permissions vs. network permissions
    By ghope in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: February 21st, 08:18 PM
  3. Permissions Issues With ASPNET Account
    By Yogesh Pancholi in forum ASP.NET Security
    Replies: 4
    Last Post: April 25th, 11:18 PM
  4. Issues, ohhh I have issues
    By mrnaturl in forum Macromedia Fireworks
    Replies: 19
    Last Post: November 28th, 08:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139