[wendy k. walker]

Hi Michael,

I downloaded --> MySQL 5.0 -- Generally Available (GA) release for production use > Windows Essentials (x86) from "Here".

I stuck it in C:\MySQL but this is where its properties say it's hiding out at;
"C:\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\MySQL\MySQL Server 5.0\my.ini" MySQL

I'm just about ready to uninstall it and start over just in case I did something wrong.

So what does that path tell you? Hey isn't '\bin\mysqld-nt' supposed to have a '.exe' after it?

Wendy

[Advertisements]

does

"C:\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\MySQL\MySQL Server 5.0\my.ini"

running that create any errors from the command line?

No you don't need the .exe it is assumed.

[Michael]

does

"C:\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\MySQL\MySQL Server 5.0\my.ini"

running that create any errors from the command line?

No you don't need the .exe it is assumed.

[wendy k. walker]

Hi Michael,

Yep, it sure did. I don't remember if it was 'too many augments' [or something like that] or if it was the one that told me that it wasn't an internal or external command function or batch file.

I'm starting to wonder if I might be getting one bad install after another because as I read through the documentation and manual I'm seeing references to files that I either don't have or that me search feature just can't find for some reason.

The first several times that I installed it I let it use its chosen default location to install its self. I had also done the same thing with Apache, PHP and phpMyAdmin.

Then I had read something [and received advice] about one of those things not liking any spaces like the one in 'C:\Program Files\' so thinking that that might be causing my problem I uninstalled everything from their chosen defaults and reinstalled everything to its very own folder on 'C:\'.

That doesn't seem to have helped any either, so right now I'm just sitting here with a blank look on my face while I stare at my monitor screen.

OK, so going with my gut feeling that I might have gotten a bad install I tried a couple of 'repairs' but that didn't seem to do any good either so I just uninstalled MySQL via the add\remove thing. I also deleted the MySQL folder. Then I reinstalled it, this time to its chosen default location.

I installed it as a windows service, checked the little box that lets you get to it in dos [I think] and it is currently running.

Now I need to know 'How to connect to the MySQL client'. So far I've seen several references to starting the server and then connecting to the client but I haven't recognized anything that tells me how to do that other than being able to start or stop the service in the windows service thingy.

I think that I have a file this time that I didn't have before, it's 'include' and is has a bunch of stuff in it that I don't remember having seen before so maybe I was right about having gotten a bad install before.

So right now I have MySQL installed in its chosen default location of 'C:\Program Files\MySQL\MySQL Server 5.0\' with all of its default settings set the way that it wanted to set them.

I did set the root password during installation and I'm not going to change anything until I hear from you.

Thanks for your help.

Wendy

[EDIT] I just did Start > run > cmd > then typed C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe at the C:\> prompt and hit enter. I got back a message saying --> 'C:\Program' is not recognized as an internal or external command operable program or batch file. <--

Then I re-entered the same command and enclosed it with " ", hit enter and got the following message back --> ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password"NO):

I don't know if I'm right about this but that seems to be telling me that there is a user account named 'ODBC' that might have a password associated with it.

Question: If that is the case wouldn't the required password be the password that I just set for root? and If that is the case then how do I enter that command [above] so that it would be accepted?

Thanks again Boo.

Wendy

Edited by wendy k. walker, 25 February 2007 - 03:48 PM.

[Michael]

Try using ODBC as the user name and what ever you set as the root password for the password in PHPMyAdmin and see if that works. Else try root again.

You should be able to find lots about using MySql from the command line on Google. It is a huge subject that I can't really cover in one post.

[wendy k. walker]

Hi Michael,

Thanks for the reply. Shoot! I've already tried it with every root password that I've used when setting up MySQL with no success. I also tried it with the password that I had put in blowfish_secret ''. None of them worked.

You said try it with the 'root password' that I had set for phpMyAdmin... were you talking about what I had put in blowfish_secret '' or something else? I don't remember setting anything like a 'root password' in phpMyAdmin.

I finally found the online manual for MySQL and have been going over all kinds of stuff trying to get things to work.

So far the only thing that wants to work as it it written are the commands NET START MySQL and NET STOP MySQL.

While playing around with those commands one of them had given me a message saying something like this --> Access denied for user 'GBC'@'localhost' (using password"NO): There again I tried those letters with all kinds of passwords, all to no avail.

This is all very discouraging to say the least. I've been Googling so much that Google sent me a bill for excess use of their services. I've found a lot of stuff to read trouble is that none of it seems to work when I try it but I'm not giving up.

Thanks for your help.

Wendy

[Michael]

Well I going to admit defeat. I can't see what is wrong.

Did you know there are packages like xampp that are suposed to work out the box, and contain Apache, PHP, MySql and more? You could try using one of them.

Also one good place to go for help if you use IRC is irc.freenode.org#mysql they might be able to help.

[Major Payne]

Hi Michael:

The Xampp package seems to be very good and free. Hope Wendy tries it, but I've bookmarked it for future use. Thanks for the tip on this.

Wendy, still got some aspirins left for you.

Ron

[Michael]

Yeah it is great if you can't set it up yourself.

I will be install Apache/PHP/MySql as soon as I get my computer back from Dell. It is having its 4th bit of hardware replaced in two months. Good thing it has 2 years of warranty left.

Wendy if I were you I would try xampp, after your used to looking after the server for awhile try installing it all yourself again.

[wendy k. walker]

Hi Michael,
Hi Major Payne,

First I want to say "Thanks" to both of you guys for having given it a try. I'm figuring that what ever it is is actually awfully darned simple and that its just sitting there right under my nose laughing at me for not being able to see it.

I know that Apache works right, and that PHP works with Apache. Well at least when I did the recommended test it put up a big long list of all kinds of PHP stuff like it was supposed to.

Question: Is there anyway to use the MySQL Server by its self?

And one other thing that keeps nagging at me is that statement in the MySQL Server 5.0 installation that said --> if you have uninstalled a previous installation of MySQL the uninstall DID NOT automatically remove 'THE PASSWORD' and stated that that had to be done manually in some file that is supposed to be hiding out somewhere in the Windows directory.

Do either of you have any idea where to look for that little bugger? I'll have to uninstall and reinstall MySQL to get the exact message again and I'm not thinking that it named the file that needed to be edited anyway.

Question: Can I download and install that xampp thing without ripping out Apache, PHP, MySQL, and phpMyAdmin?

Thanks,
Wendy

[Michael]

I think the password file is called my.cnf

I also think you don't need to uninstall Apache and PHP to try xampp.

You normally use some programing language to access mysql. Though it can be done from the command line I think.

[wendy k. walker]

Hi Michael,

Thanks for the reply. My little search dog said that I don't have a file called my.cnf on my machine so I don't know what to do about manually editing out the old password.

I've been reading the MySQL reference manual about how to do things with MySQL from the command line but the only thing that will work for me is NET START MySQL and NET STOP MySQL. Those two commands will start and stop MySQL but I haven't found anything else in the manual that will work.

I'm wondering if I might ought to try using the .zip download of MySQL and see if that makes any difference in the way it works.

Thanks again for your help.

Wendy

[Michael]

Instead of NET START MySQL try CREATE DATABASE funny_name does that work?

I would guess your password file has been deleted. So I would forget about it.

The zip just has the exe in it

[wendy k. walker]

Hi Michael,

Nope it didn't work with MySQL started or stopped. Hum... I thought it might have more in it than the windows essentials download cause it's size. I mean the .zip download weighs in at 40.3M whereas the Essentials download is only 16.8M.

I have to figure this thing out before those guys in white come to fit me for one of those new fangled tie behind sports jackets.

I've tried several of the commands in the MySQL reference manual and none of those buggers wanna work. So I'm really wondering if I over looked something during setup. I never have seen any place to put in a user name during setup in MySQL or in phpMyAdmin either one and it doesn't seem to matter what password I put in for 'root' it doesn't want to work.

Hey, I know that phpMyAdmin requires MySQL to be able to operate... so is that true the other way around? I mean will the MySQL Server work without phpMyAdmin?

How would I check the MySQL Server to see if it's working before I installed phpMyAdmin?

Thanks for your time.

Wendy

OK I wrote that a couple of days ago but the server went down before I could post it so I just hung onto it. I have since uninstalled MySQL and phpMyAdmin.

Then I reinstalled MySQL WITHOUT using a root password this time and don't you know that I have been able to get a couple of commands to work so far.

I went with the .zip download this time and it does have a gang of files that the other download doesn't have. Anyway now I have to find the time to start playing with it and get it secured.

If I can get it working right then I'll try adding phpMyAdmin again. I still don't have a my.cnf file. Is there a chance that it might have a different name that I might need to change before I can use it?

Thanks,

Wendy