accesing Mysql on local machine

Discussion in 'MySQL' started by RootShell, Jul 12, 2007.

0
  1. #1
    've installed mysql on my local win xp with Apache and php5. I'm trying to learn php and mysql.

    The book I am using expects me to know a little more than I do. I've looked around and have found so solution to my problem. I think it's too simple.

    How do I access mysql? From the cmd I have:
    C:\MySQL\data>mysql>CREATE DATABASE test;
    (which returns only)
    C:\MySQL\data>
    (I then try accessing 'test')
    C:\MySQL\data>mysql>USE test;
    (this gives me)
    ERROR 1045 <28000>: Access denied for user 'ODBC'@'localhost' <using password:NO>

    Am I just using the cmd wrong here?

    In the my.ini file I have:
    #Path to the database root
    datadir="C:/MySQL/Data/"

    I'll be glad when I'm out of the #*$! stage of this learning process....
     
    RootShell, Jul 12, 2007 IP
  2. vinxxv

    vinxxv Well-Known Member

    Messages:
    506
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    118
    #2
    looks like you need to enter a password...

    try connecting again (make sure the mysql running) using this command

    mysql -u [B]your_mysql_username[/B] -p
    Code (markup):
    press Enter

    then a password field will appear... enter the password.. then Press enter again.

    then try creating a database again and connect to the database using the "USE" command.

    hope this helps...
     
    vinxxv, Jul 13, 2007 IP
  3. Doskono

    Doskono Peon

    Messages:
    153
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I suggest you to disinstall that crap and use WAMP.

    WAMP supports MYSQL apache and is a virtual server, it is easy to use as a beguiner and has phpmyadmin to edit and create tables within a mysql database.

    search wamp in google. if you are a linux user search LAMP if Mac user search MAMP.
     
    Doskono, Jul 13, 2007 IP
  4. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #4
    I wont call Mysql CRAP! if Mysql is crap then also WAMP is crap, since WAMP is also based on mysql server.

    If RootShell wants to play just with mysql, then it's his choice. Let him learn.
     
    gibex, Jul 13, 2007 IP
  5. RootShell

    RootShell Well-Known Member

    Messages:
    855
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    130
    Digital Goods:
    1
    #5
    Thanks vinxxv For The solution
     
    RootShell, Jul 13, 2007 IP
  6. webdezzi

    webdezzi Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    applications like wamp will not let ppl learn, it makes we developers lazy.
     
    webdezzi, Jul 18, 2007 IP
  7. mixtmobile

    mixtmobile Peon

    Messages:
    159
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I suggest you to disinstall that crap and use WAMP.
    very good for newbs.
     
    mixtmobile, Jul 18, 2007 IP
  8. RootShell

    RootShell Well-Known Member

    Messages:
    855
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    130
    Digital Goods:
    1
    #8
    Thanks Good Solution
     
    RootShell, Aug 4, 2007 IP
  9. ewriter

    ewriter Banned

    Messages:
    590
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #9
    I use mysqladmin its a good software too.
     
    ewriter, Aug 4, 2007 IP
  10. RoyalSeo

    RoyalSeo Peon

    Messages:
    560
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Can you suggest me a book or ebook for php.

    Thanks in advance.
     
    RoyalSeo, Aug 4, 2007 IP
  11. RootShell

    RootShell Well-Known Member

    Messages:
    855
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    130
    Digital Goods:
    1
    #11
    RootShell, Aug 5, 2007 IP