mySQL install help

CHiLLaXen

hypnotika
Joined
6 Jan 2004
Messages
107
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.
 

GMeagle86

OSNN Addict
Joined
6 Jan 2004
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.
 

j79zlr

Glaanies script monkey
Political Access
Joined
16 Feb 2003
Messages
2,725
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');
 

Geffy

OSNN Veteran Addict
Joined
18 Mar 2002
Messages
7,805
yeah you gotta run mysql-nt and make the my.ini or my.cnf in C:\
 

vern

Dominus
Political Access
Joined
2 Mar 2002
Messages
1,572
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...

su mysql
mysql_install_db

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

Members online

No members online now.

Latest profile posts

Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?

Forum statistics

Threads
62,007
Messages
673,466
Members
5,598
Latest member
Larry Chris