Professional Web Applications Themes

Newbie help needed - MySQL

Duncan <com> wrote:  Default after install is 'root' without password for most windows flavours afaik. -- Rik Wasmus...

  1. #1

    Default Re: Newbie help needed

    Duncan <com> wrote: 

    Default after install is 'root' without password for most windows flavours
    afaik.
    --
    Rik Wasmus
    Rik Guest

  2. #2

    Default Re: Newbie help needed

    On Feb 23, 11:19 pm, "Duncan" <com> wrote: 

    FWIW, this is what i type to access mysql

    mysql -u myusername -p
    mypassword

    I use windows but I guess the command line interface is similar.

    strawberry Guest

  3. #3

    Default Re: Newbie help needed

    On Feb 24, 1:32 am, "Duncan" <com> wrote: [/ref]
    > [snip] [/ref]

    >
    > F*** me that worked, I was missing out the -u
    > So simple
    > When you say you use windows do you go in via a graphical front end?
    > I'm using windows.
    > thanks a load
    >
    > Duncan[/ref]

    No - I meant Windows vs Mac. I just didn't read your post very
    thoroughly.
    Although I do also use phpmyadmin

    strawberry Guest

  4. #4

    Default Newbie help needed

    Hi All,

    I'm learning SQL and the book that I'm reading suggested mySQL as a good DB
    to use, it also uses it in the examples.

    This is good because I want to learn a bit more about Databases.

    So I tried to install the Apple Mac version and although it seemed to
    install ok I can't start it or even find it. (I'm not a wizz at the BASH
    terminal window).
    So I though I'd use the Windows version (using Windows XP on the Mac) this
    also seemed to install ok but when I try to start it from the command line
    using: > mysql [username] [password]
    I get a screen full of stuff starting:-
    mysql Ver 14.12 Distrib5.0.27, for Win32 (ia32)
    Copyright (C) 2002 MySQL AB
    it them lists a load of what I assume are options and then goes back to the
    prompt it was before:

    If I type: >mysql [username] -p
    it asks me for the password and then brings up the message:

    I get a message saying that ERROR 1045 (2800): Access denied for user
    'ODBC''localhost' (using password: YES)

    I am certain I'm using the correct password.

    I also tried using Toad for MySQL as a front end but this gave the same
    password error message

    If someone could help with getting either the Windows or the Mac (or both)
    working I'd be most grateful

    Duncan


    Duncan Guest

  5. #5

    Default Re: Newbie help needed

    "Rik" <com> wrote: [/ref]
     

    No, I've just tried root and same thing with or without the password I
    stipulated at install

    thanks for replying though
    Duncan




    Duncan Guest

  6. #6

    Default Re: Newbie help needed


    "strawberry" <com> wrote in message
    news:googlegroups.com... [/ref]
    [snip] 
    >
    > FWIW, this is what i type to access mysql
    > mysql -u myusername -p
    > mypassword[/ref]
     


    F*** me that worked, I was missing out the -u
    So simple
    When you say you use windows do you go in via a graphical front end?
    I'm using windows.
    thanks a load

    Duncan



    Duncan Guest

  7. #7

    Default Re: Newbie help needed


    "strawberry" <com> wrote in message
    news:googlegroups.com... 
    >
    > No - I meant Windows vs Mac. I just didn't read your post very
    > thoroughly.
    > Although I do also use phpmyadmin[/ref]


    I'll give that a look

    Thanks again
    Duncan


    Duncan Guest

Similar Threads

  1. CF Web Servies help needed - newbie
    By jl in forum Coldfusion Component Development
    Replies: 0
    Last Post: February 14th, 02:06 PM
  2. Newbie Here, Advice Needed
    By george in forum PHP Development
    Replies: 6
    Last Post: April 11th, 10:47 AM
  3. Newbie.....all help needed!
    By Myles in forum Linux Setup, Configuration & Administration
    Replies: 10
    Last Post: November 5th, 12:34 PM
  4. newbie help needed
    By jayjwa in forum Linux Setup, Configuration & Administration
    Replies: 0
    Last Post: July 18th, 06: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