mySQL install help

Discussion in 'Web Design & Coding' started by CHiLLaXen, Jan 16, 2004.

  1. CHiLLaXen

    CHiLLaXen hypnotika

    Messages:
    107
    Location:
    Minnesota
    OK, I just installed apache, php, and mySQL in a partition on my hard drive. PHP works but I cannot get mySQL to work. I"m at the point where I must create a admin password. I go to the command line, get to the mysql\bin folder. I type "mysqladmin -uroot password blahblah" <- not the real password. It says:

    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to MySQL server on 'localhost' (10061)'
    Check that mysqld is running on localhost and that the port is 3306.
    You can check this by doing 'telnet localhost 3306'

    I have no idea what it is talking about. I'm very new to this server stuff. I just wanted to install it so I could test out my website before putting it online.
     
  2. GMeagle86

    GMeagle86 OSNN Addict

    Messages:
    144
    Try not using a password unless you set one up. and/or try not using a username. Those were my problems. I did not set one to begin with, so I didn't give it one and it worked. I only use mine for local testing though so it doesn't have to be really secure.
     
  3. GMeagle86

    GMeagle86 OSNN Addict

    Messages:
    144
    um, do you have windows or linux?
     
  4. CHiLLaXen

    CHiLLaXen hypnotika

    Messages:
    107
    Location:
    Minnesota
    wondows XP
     
  5. j79zlr

    j79zlr Glaanies script monkey Political User

    Messages:
    2,725
    Location:
    Chicago
    MySQL is not running, I haven't used it on Windows, but I think you need a my.ini config file in, well you need to figure out where it goes, and then start it up.

    Once you get it running use this to set the password

    mysql>SET PASSWORD FOR username@"%"=PASSWORD('your password');
     
  6. GMeagle86

    GMeagle86 OSNN Addict

    Messages:
    144
  7. Geffy

    Geffy Moderator Folding Team

    Messages:
    7,805
    Location:
    United Kingdom
    yeah you gotta run mysql-nt and make the my.ini or my.cnf in C:\
     
  8. vern

    vern Dominus Political User Folding Team

    Messages:
    1,571
    Location:
    Minnesota, USA
    The initial DB for MySQL was not setup. That needs to be setup first before you can connect to MySQL. I run MySQL on Linux, I would have to...

    to setup the initial DB. Someone else might be able to help you setting up the initial database in Windows.
     
  9. CHiLLaXen

    CHiLLaXen hypnotika

    Messages:
    107
    Location:
    Minnesota
    Yea, I had to create a DB first, it works now. Thanks for all the help