Helpful Information
 
 
Category: MySQL
Error during MySQL Setup... (Whackaxe?)

I'm going through the PHP/MySQL tutorial on Webmonkey, and I got to the part where we create a DB - I'm getting this error though...

C:\MYSQL\BIN>mysqladmin -u root create mydb
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (
Check that mysqld is running on localhost and that the
You can check this by doing 'telnet localhost 3306'


what do I do now??

help please

~Quack

You need to make sure mySQL is running before you can connect to it. Look in the folder where you installed it and find the startup file as it mentioned in the error.

now I get this error...

C:\MYSQL\BIN>mysqladmin -u root create mydb
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (Using password: NO)'

when I use a password I get this

C:\MYSQL\BIN>mysqladmin -u root -p[root] create mydb
MYSQLADMIN: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (Using password: YES)'

help please?

~Quack

yes i think i had the same problem with my mysql. the thing is i hadnt set the password i think (i really dont want to go back and remeber that again :p) anyways to set the password (under windoze if thats what your using quack)

mysqladmin -u root password 'mynewpassword'

after that you should be set. another thing is that when you start up the mySQL server use the winmysqladmin executable: it will open a managemnt system and also start up the mysl server executable (mysqld) it wil then show up as a set of traffic lights in the systray (red if the mysqld exec is not running and green if it is meaning your servers up!)

also get the mysqlGUI from the mySQL site (its hideous and garish but its beter than command line) this is a perfect alternative to the countless different command lines execs there are in the /bin
hope that does you. i found installing mySQL the hardest part because it is sooooooooo badly documented. hey jeewhiz couldnt you put a tutorial on how to install mysql on a mindows 9x system or i could do one if you want

Thanks - I still got an error from Dos, but I downloaded the GUI and it seemed to work for me to change my password.

How do I create a DB from MySQL GUI ??

thanks all help is MUCH appreciated!!! :thumbsup:

~Quack

k, I figured out how to make a DB from MySQL GUI, but I get the same error.... :mad: :mad: :mad:

can someone post some decent step by step directions of how to install MySQL and PHP ??

This is really starting to bug me...

thanks

~Quack

Unless you actually want to learn how to set up and configure all these I would just download phpdev4. It installs all of that already configured for you. Plus using phpMyAdmin is much easier to work with mySQL.

What spook forgot to say was the url

www.firepages.com.au

Enjoy :)

Jee

p.s., spook, don't worry dude, just getting old ;)

phpdev4 - is this compatible with IIS ???

Like I've said - I'm really new to this, so I don't really know what I'm doing :rolleyes:

~Quack

Originally posted by Jeewhizz
What spook forgot to say was the url

www.firepages.com.au

Enjoy :)

Jee

p.s., spook, don't worry dude, just getting old ;)

Yeah im getting forgetful in my old age. :p

phpdev has it's own obviously superior web server Apache. If all you want to do is develop PHP/mySQL stuff and practice with it I would download that as it is all set up and configured for you. PHP and mySQL can run with IIS but you have to go through all the trouble of installing each of those and configuring them. If you want to learn how to do that then that's okay. But if you just want to be able to get started learning to write PHP and working with mySQL db's then I would just install phpdev.

The thing is that I need to keep my current configuation active .. is it possible to run both of them side by side?

~Quack

I've run both of them before. I used phpdev for devoping php, mysql, perl stuff and used the other for asp stuff.

Ok, well I think I'd like to see some instructions on doing it the other way - I tried in stalling phpdev but it didn't work...

:(

~Quack

Ok to install each component individually as you intend you should read the documentation and installation instructions that comes with each one.

As for phpdev it works just fine. If you give a better explanation than it don't work than we can help you get up and running.

When I first installed phpdev I simply ran the install file and executed the batch file that starts Apache and MySQL and everything ran just fine. You did start everything right?

yeah, I started everything properly, but it didn't link up to the right file (broken link on the start page...)

Anyways, I think I'm just gunna give up on my PHP endevour.. :(

thanks for all your help though...

~Quack

no you cant! PHP rules! if it is still messing up with mySQL try sending a message to the guy who did the mySQL on webmonkey and being the friendly people they are, one might give you some good help (and i thought i had a hard time setting up) also make sur that you have a) the my.cnf file in your mysql directory OR the mysql.ini (or my.ini, cant remeber) file in your windows directory

whack,

are you running php/MySQL on Windows machine with IIS?

it's tough stuff... :(

~Quack










privacy (GDPR)