Professional Web Applications Themes

Mac OS X Newbie - Having difficulty setting a pw for root - MySQL

Hi, *Please assist a unix/Mac OS X newbie ~ I just installed the MySQL 5.0.27 binary package for Mac OSX 10.4 and am having a lot of difficulty with the post-installation processes.  root user since, by default, the root account initially has no password. Using a bash shell on Mac OS X 10.4.8, I've tried setting the password using this command: /usr/local/mysql/bin/mysqladmin -u root password mynewpassword Nothing happens after I press enter. However, when I try to login to mysql as the root user like this: /usr/local/mysql/bin/mysql -u root I get the following error message: ERROR 1045 (28000): Access denied ...

  1. #1

    Default Mac OS X Newbie - Having difficulty setting a pw for root

    Hi,

    *Please assist a unix/Mac OS X newbie ~
    I just installed the MySQL 5.0.27 binary package for Mac OSX 10.4 and
    am having a lot of difficulty with the post-installation processes. 
    root user since, by default, the root account initially has no
    password. Using a bash shell on Mac OS X 10.4.8, I've tried setting
    the password using this command:

    /usr/local/mysql/bin/mysqladmin -u root password mynewpassword

    Nothing happens after I press enter. However, when I try to login to
    mysql as the root user like this:

    /usr/local/mysql/bin/mysql -u root

    I get the following error message:

    ERROR 1045 (28000): Access denied for user 'root''localhost' (using
    password: NO)

    I'm extremely new to all of this and installed MySQL to follow along
    with a book I'm reading. I'm trying to familarize myself with creating
    fast and efficient databases for my company.

    Any assistance would be greatly appreciated~
    Thank you~

    - a MySQL newbie

    lee.hogan@gmail.com Guest

  2. #2

    Default Re: Mac OS X Newbie - Having difficulty setting a pw for root

    On 19 Feb, 16:13, com wrote: 
     
    No you don't. If you're just using it on your own local machine for
    test purposes and no one else has netrowk access to it then you can
    quie happily run with no PW.

    Captain Guest

  3. #3

    Default Re: Mac OS X Newbie - Having difficulty setting a pw for root

    But when I run mysql using this command:

    /usr/local/mysql/bin/mysql

    and then try creating a database:

    mysql> create database mydatabase;

    I get the following error msg:

    ERROR 1044 (42000): Access denied for user '''localhost' to database
    'mydatabase'

    On Feb 19, 11:24 am, "Captain Paralytic" <com>
    wrote: 










    >
    > No you don't. If you're just using it on your own local machine for
    > test purposes and no one else has netrowk access to it then you can
    > quie happily run with no PW.[/ref]


    lee.hogan@gmail.com Guest

Similar Threads

  1. Upgraded to MX - Setting the root folder
    By thecontractorsgroup.com in forum Macromedia Dreamweaver
    Replies: 4
    Last Post: August 2nd, 12:25 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