[Resolved] My SQL nightmare

Davidc316

There's always something isn't there????

Just when I was starting to get to grips with some simple PHP scripts, I thought it was finally time to swing MySQL into action.

But (sure enough!), it doesn't work. Surprize surprize.

Anway...

I've installed and deleted and reinstalled MySQL about a billion times now and here's what happens (oh, by the way... did you notice how there's no option of UNinstalling MySQL? Obviously the developers were too cleaver to bother with that)...

Ok, so here's the scene...

I get the MySQL zipped file onto my computer.

I hit setup.exe and go through the setup procedure.

I install MySQL to C:/mysql (as is suggested by the setup.exe wizard)

Then I run WinMySQL admin as is recommended by the book I'm using. (it can be found in the new MySQL folder that I've just made, in a sub folder called "bin").

Then a little box comes up which talks about creating an "ini" file and it asks me to type in a username and password.

I do this.

Then I open up WinMySQL.

And NOW is where things start going wrong...

When I open WinMySQL, the admin panel just flashes up on the screen for about two seconds the vanishes leaving NOTHING BUT a little set of traffic lights in the bottom right hand corner of my computer screen.

Now according to all sources, I can right click this set of traffic lights and start MySQL that way.

But they stay red!!!!! They do NOT go green.

Aaaaaaaaaaaaaaarggggggghhhh!!!!

Actually, that's a lie cos earlier on they did go green but only for about half a second before going red again.

Anyway, the punchline is that I'm totally miserable and right now I just feel like giving up on this whole shabang.

I so sick of it.

I hope someone can help me out here. If not then I'll upload some screenshots from my computer to graphically show people what I'm looking at. If that doesn't work then I'm gonna give up and take up something else.

With lots of love and even more misery,

David x

the_myth

Do you have Apache or any other websever running locally?

Davidc316

Yes I do.

I have Apache running on the C drive and all is well on the Apache front.

FraXTC

I'm a n00b myself, so I can't help you too much, but I could give you an alternative: WinMySQL is unknown to me, I use the dos-based MySQL, so If winMySQL doesn't run, try the original version. It's kind of a bitch in the beginning, but you can download the manual from the MySQL homepage, and it runs like a charm here 🙂

Davidc316

Thanks Frank but I think the problem is not really to do with WinMySQLAdmin. I think the trouble is that MySQL simply will not start.

I've attempted to start MySQL via the DOS command promt (start>run>cmd brings it up) and I keep getting a message which says "system error 1067 has occurred".

I see that other people on the forums have had this same error message, but so far nobody seems to be able to offer a concrete solution.

drag0n

What I would do if I were you is to not to try install all these servers your self if you have no previous experience with them and go to this website:
http://software.inkblotresources.com/ibserver/
They have this program called IBServer and you can do alot with it, it includes PHPNUKE, MySQL alls setup, same with Apache and PHP.
I think that is the kind of software you need
But if you really weant to try the installation yourself, you should restart your computer 🙂 if you havent already done so, then you should check the my.ini file and try to debug it, sometimes when you install something without uninstalling it, you mess up the files. And yes they do have Uninstallation, depending on which OS you use its in Program, COntrol Panel, Add/Remove Programs, and find MySQL in there.

Bunkermaster

did you create the my.ini file as said in the manual?

btw the only interaction that having a webserver running on your computer could have is to conflict on port number...

You'll manage to have it working and then and only then will your problems begin 😃 (j/k)

the_myth

I'm also a n00b, so I don't know TOO much. However, I have been playing around with MySQL and have had similar problems. I'll let you know what I do to get MySQL running, this might help.

Go to dos and get into the mysql\bin directory

C:\mysql\bin>

type in

C:\mysql\bin>mysqld --standalone

I then have to close the current dos window. I'm not sure, but I think this get's mysql running in the background. Don't know! Don't quote me :p

Reopen dos and get back into the mysql\bin directory and type mysql

C:\mysql\bin>mysql
Welcome to MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.12-nt.

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>_

and your in. I really hope that helps. If not, I'm sorry. If anyone is reading this and knows a better way or sees something wrong please say so.

Davidc316

Thanks for the replies, especially to myth for typing out all that code.

Before I delve into your suggestion myth, I'd just like to answer Bunkermaster and see what he says:

Bunk: Yes. I have created the my.ini file as instructed by the manual.

It contains the following information:

[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

(PS- I'm using Windows XP. MySQL is installed at c:/mysql)

Davidc316

It's fixed!!!!!!!!! Hallelooooooooooooyaaaaaaa!!!!!!!!!!!!!!

Being a hopeless newbie I find it a little difficult to explain what happened, but basically in all the faffing about that I've been doing with mySQL over the past day or two SOMEWHERE ALONG THE LINE 2 "my" files were created!

One of them was called "my.ini" (the one I made myself which had
the good info)

The other was called "my.conf" (I don't have any idea how that one got there or what it contained).

Anway, both files were stored in the same location (ie, the C drive). So, when I tried to run MySQL it was reading the .conf files instead of the .ini file.

Thank you the help guys!!! The world isn't such a bad place and life for me can FINALLY go on!!!!!!!

Bunkermaster

:rolleyes:

good luck 🙂

You might want to read this :
http://www.mysql.com/doc/en/Windows_prepare_environment.html