SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict
    Join Date
    Sep 2000
    Posts
    230
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Win2K MySQL install ??

    I've insalled mysql on my win2K machine.

    Now..i can access the prompt and do things like:
    show databases;

    However, I have never been prompted for a password or a username. I never had to input one from the beginning.

    I'd like to establish an mysql_connect in php
    but i don't know my username or password.

    Any help would be great.

  2. #2
    purple monkey dishwasher scoates's Avatar
    Join Date
    Nov 2001
    Location
    Montreal
    Posts
    794
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to GRANT privileges to a user, and use that info to access the DB:

    http://www.mysql.com/doc/G/R/GRANT.html

    S

  3. #3
    SitePoint Addict
    Join Date
    Sep 2000
    Posts
    230
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I must disclaim here ** That this is my first installation and i'm a beginner at this.

    I will read the article on grants...but is this direction I should be going on in..

    The reason I ask is is because all of the tutorials I read (like Kev's ) he says before I even begin creating tables and databases that I should have to login through the command prompt.

    However, no where during my installation have I been asked for one...

  4. #4
    purple monkey dishwasher scoates's Avatar
    Join Date
    Nov 2001
    Location
    Montreal
    Posts
    794
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's not an article, it's a manual (-:

    And you already have a user, I'm sure, it's just defaulting to that user from the command prompt.

    S

  5. #5
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Put the username as root and no password

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  6. #6
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah, it's letting you connect w/o a name/password (which is the default config). if you want to change that, see my post(s) in this thread: http://www.sitepointforums.com/showt...threadid=44330 that should get you setup good.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


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
  •