MySQL installation question

Discussion in 'OT Technology' started by dtfromep, Dec 2, 2003.

  1. dtfromep

    dtfromep New Member

    Joined:
    Oct 11, 2003
    Messages:
    1,674
    Likes Received:
    0
    Location:
    Saint Paul, MN
    Hey, new to SQL here, have everything set up properly but I cannot seem to access the root account to change PW or utilize the DB in any programming.

    Anyone know how to change it or what the default user/pw might be? (I have searched, but cannot seem to locate the info I am in need of)

    Thanks in advance.
     
  2. frinky23

    frinky23 Bangle Sackrider

    Joined:
    Sep 10, 2002
    Messages:
    11,246
    Likes Received:
    0
    Location:
    Prestigious Cook County
    Have you tried starting it with this command:
    bin/safe_mysqld --user=mysql &?

    Also, if you do have a root user (you may need to use the above command to get into it and add root, it defaults to no password. You should set that right away.
     
  3. dtfromep

    dtfromep New Member

    Joined:
    Oct 11, 2003
    Messages:
    1,674
    Likes Received:
    0
    Location:
    Saint Paul, MN
    Just tried that here, there is no safe_mysqld anywhere in the bin directory...is it a script?
     
  4. frinky23

    frinky23 Bangle Sackrider

    Joined:
    Sep 10, 2002
    Messages:
    11,246
    Likes Received:
    0
    Location:
    Prestigious Cook County
    What OS are you using? Maybe that went away with the newer versions as well. I don't know, but have you tried starting it as root with no password?
     
  5. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    root has no password by default, you can set it using the command line:

    mysqladmin -u root password "yourpassword"
     
  6. dtfromep

    dtfromep New Member

    Joined:
    Oct 11, 2003
    Messages:
    1,674
    Likes Received:
    0
    Location:
    Saint Paul, MN
    got her figured out guys, thanks for the help!
     

Share This Page