SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist Caesar's Avatar
    Join Date
    May 2000
    Location
    On some harddisk
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi guys,

    I just downloaded a copy of mySQL and installed it on my computer.

    Let's assume that my shell account username is "abc" and my password is "xyz".

    At the dos prompt, I navigated to c:\mysql\bin. After that, I tried typing "mysql -uabc -pxyz -hKELVIN" and also ""mysql -uabc -pxyz -hlocalhost" but I received an error 1045: "Access denied for user ....... ".

    What did I do wrong? What should I do next?

  2. #2
    SitePoint Zealot p2ranger's Avatar
    Join Date
    Jan 2001
    Location
    Colorado, USA
    Posts
    149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I may be wrong here, but I think it matters the order that you type them in and where you put spaces. Try this:

    mysql -h KELVIN -u abc -pxyz

    you need a space after the -h and -u, but after pasword, you don't use a space

    Jason
    ><>

  3. #3
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure whether order matters, but I'm pretty sure you don't need a space. But here's one thing you may need to do: instead of typing the password in that line, just do -p and it will prompt for your password. So:
    mysql -uUSERNAME -p -hKELVIN
    would/should produce:
    Enter password:
    then you type your password. Also, you may not need the host name.
    Kevin

  4. #4
    SitePoint Evangelist Caesar's Avatar
    Join Date
    May 2000
    Location
    On some harddisk
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Those didn't help. Anyone else have any suggestions?

  5. #5
    SitePoint Member
    Join Date
    Feb 2001
    Location
    El Paso, TX
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you just installed it, try typing just mysql, without any username or password parameters, if it starts and you can access/change the databases you don't have your permissions set up right. I got mine working the way I wanted it to, but it was trial and error, and I'm not sure I remember the exact steps. So you might be better off asking someone else for help, if that's the case.


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
  •