Professional Web Applications Themes

Privileges problems - MySQL

I'm having trouble with Mysql privileges. If I type mysql from my default account, 'markus', I get the access denied error 1045 for user 'markus''localhost' (using password:YES) To my knowledge, I don't have a password on that account. I run su and run mysql -u root mysql to look at the user table. There I have an account for 'markus''localhost' and 'markus''%'. To make sure these accounts are properly privileged, I delete them from the table and then run 'grant all privileges on *.* to 'markus''localhost' with grant option;. I also run it for '%'. I try running mysql from ...

  1. #1

    Default Privileges problems

    I'm having trouble with Mysql privileges. If I type mysql from my
    default account, 'markus', I get the access denied error 1045 for user
    'markus''localhost' (using password:YES)

    To my knowledge, I don't have a password on that account. I run su and
    run mysql -u root mysql to look at the user table. There I have an
    account for 'markus''localhost' and 'markus''%'. To make sure these
    accounts are properly privileged, I delete them from the table and then
    run 'grant all privileges on *.* to 'markus''localhost' with grant
    option;. I also run it for '%'. I try running mysql from 'markus'
    again, and it fails.

    What am I missing regarding the privileges system?

    Thanks

    mailpitches@email.com Guest

  2. #2

    Default Re: Privileges problems

    >I'm having trouble with Mysql privileges. If I type mysql from my 

    If you don't have a password on the account, don't try to log in
    with one.
     


    If you don't have a password on the account, don't try to log in
    with one.

    Gordon Guest

  3. #3

    Default Re: Privileges problems


    Gordon Burditt wrote: 
    >
    > If you don't have a password on the account, don't try to log in
    > with one.[/ref]

    I'm trying to login _without_ a password on an account that was created
    without a password, but it still requires a password. If I login with
    mysql -p and hit enter at the password prompt, it works. For some
    reason it's assigning a blank password instead of not requiring a
    password at all.

    Any ideas on how to fix this?

    mailpitches@email.com Guest

Similar Threads

  1. adminstrator privileges
    By kygirl74 in forum Macromedia Shockwave
    Replies: 2
    Last Post: December 4th, 07:37 PM
  2. Privileges question
    By Michael in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: February 14th, 11:38 PM
  3. User Privileges
    By RG in forum Windows Server
    Replies: 1
    Last Post: June 2nd, 06:26 PM
  4. No Grant Privileges
    By Marc in forum PHP Development
    Replies: 3
    Last Post: January 4th, 11:49 AM
  5. Different types of privileges
    By Peter in forum Oracle Server
    Replies: 1
    Last Post: June 26th, 10:13 AM

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