Professional Web Applications Themes

Access denied for user 'root''localhost' - Dreamweaver AppDev

hi: MacOS 10.4.1 MySQL standard-4.1.14 (MySQL site installer package) phpMyAdmin 2.6.3-pl1 bash shell after installing MySQL i tried the tests in the manual Mac-G4:~ manager$ mysqladmin version - OK Mac-G4:~ manager$ mysqladmin variables - OK Mac-G4:~ manager$ mysql (no password) - OK then i tried to secure the Initial MySQL Accounts according to point 2.9.3 in the manual w/o success: Mac-G4:~ manager$ mysql -u root ERROR 1045 (28000): Access denied for user 'root''localhost' (using password: NO) ================================================== ================== Mac-G4:~ manager$ mysql or Mac-G4:~ manager$ mysql -u manager SET PASSWORD FOR '''localhost' = PASSWORD('newpwd'); ERROR 1044 (42000): Access denied for user ...

  1. #1

    Default Access denied for user 'root''localhost'

    hi:

    MacOS 10.4.1
    MySQL standard-4.1.14 (MySQL site installer package)
    phpMyAdmin 2.6.3-pl1
    bash shell

    after installing MySQL i tried the tests in the manual

    Mac-G4:~ manager$ mysqladmin version - OK
    Mac-G4:~ manager$ mysqladmin variables - OK
    Mac-G4:~ manager$ mysql (no password) - OK

    then i tried to secure the Initial MySQL Accounts according to point
    2.9.3 in the manual w/o success:

    Mac-G4:~ manager$ mysql -u root
    ERROR 1045 (28000): Access denied for user 'root''localhost' (using
    password: NO)
    ================================================== ==================
    Mac-G4:~ manager$ mysql or Mac-G4:~ manager$ mysql -u manager
    SET PASSWORD FOR '''localhost' = PASSWORD('newpwd');
    ERROR 1044 (42000): Access denied for user '''localhost' to database
    'mysql'
    ================================================== ==================
    http://localhost/~manager/phpMyAdmin-2.6.3-pl1/

    #1045 - Access denied for user 'root''localhost' (using password: NO)
    ================================================== ==================

    MySQL manual: "If you install MySQL on Mac OS X using a PKG
    distribution, the installer runs mysql_install_db". so, the grant tables
    are set up. if i tried to chech in the data directory:

    cd /usr/local/mysql/data
    -bash: Permission denied

    i posted in MySQL Install forum but no answers. curiously, there're a
    lot of people with the same error but very few answers and not very helpful

    i've been thinking to move to my PC but i can't believe this can be so hard!

    TIA,

    John
    John Guest

  2. #2

    Default Re: Access denied for user 'root''localhost'

    Like I told the guy below you, you have to grant permissions to the root
    user in MySql. There are good directions for this with windows at
    http://www.dreamweavermxsupport.com .. but I have no idea if they apply to
    Mac or not.


    --
    Nancy Gill
    Team Macromedia Member: Dreamweaver MX/UltraDev
    http://www.macromedia.com/go/team/
    Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
    Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
    Guide, Mastering Macromedia Contribute
    Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

    "John Doe" <net> wrote in message
    news:dfqp9u$t7u$macromedia.com... 
    helpful 
    hard! 


    Nancy Guest

  3. #3

    Default Re: Access denied for user 'root''localhost'

    John Doe wrote: 

    I have installed and uninstalled MySQL dozens of times on both Mac and
    Windows while testing for my books, and have never run into any
    problems. I'm not familiar with the tests you mention. I don't know
    whether they have resulted in some unusual change. There is, however, a
    very comprehensive list of troubleshooting methods for Access denied
    problems here:

    http://dev.mysql.com/doc/mysql/en/access-denied.html

    --
    David Powers
    Author, "Foundation PHP for Dreamweaver 8" (foED - forthcoming)
    Author, "Foundation PHP 5 for Flash" (friends of ED)
    http://computerbookshelf.com
    David Guest

  4. #4

    Default Re: Access denied for user 'root''localhost'

    thanks Nancy & David

    just using:

    mysql --user=root mysql (MySQL manual: 5.7.2)

    instead of:

    mysql -u root (MySQL manual: 2.9.3)

    i could log as root an access mysql.usr table to add the passwords. i
    can't believe i've spent so many hours fighting with it!

    any overflowing charity soul can explain me why the first option doesn't
    work?

    TIA,

    John

    David Powers wrote: 
    >
    >
    > I have installed and uninstalled MySQL dozens of times on both Mac and
    > Windows while testing for my books, and have never run into any
    > problems. I'm not familiar with the tests you mention. I don't know
    > whether they have resulted in some unusual change. There is, however, a
    > very comprehensive list of troubleshooting methods for Access denied
    > problems here:
    >
    > http://dev.mysql.com/doc/mysql/en/access-denied.html
    >[/ref]
    John Guest

Similar Threads

  1. Access denied for user
    By Ray Muforosky in forum MySQL
    Replies: 2
    Last Post: April 13th, 09:33 PM
  2. MySQL Access denied for user - Plesk / FC 2
    By rossn8tor@hotmail.com in forum Coldfusion Server Administration
    Replies: 1
    Last Post: November 9th, 04:31 PM
  3. 401 Access Denied, but only for one user
    By Jeff Stewart in forum ASP.NET Web Services
    Replies: 3
    Last Post: April 4th, 10:13 PM
  4. Replies: 4
    Last Post: February 7th, 08:26 PM
  5. Replies: 14
    Last Post: December 12th, 07:55 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