clueless noob needs help

[netchicken]

Hi, I am trying to learn mysql and find myself stuck at the very beginning 🙂

Some kind people at phpfreeks pointed me here 🙂 and I downloaded your great program .. but still can't get it to work…

here is my story from the other board, I can see how this great program would be exactly what I want, if I could get the program to work locally. Thats all I need as I will teach it later in the year and the students wold use it locally as well.

Anyway, here's the story….

Hi, I really need some help on mysql.

I want to learn php and mysql yet I have spent the last 2 days trying to get the mysql loaded and running locally on my machine (win98v2) without success.

After installing the software the mysqld-opt dos window comes up and wants to be connected to the net, OK I do it, the kernal processor goes to 100% and the machine slows to an unusable crawl.

The winmysqladmin 1.4 window comes up (only after disconnecting from the net cause the machine runs so slowly) and its unusable. The database window won't accept any input and I can't open, make, or do ANYTHING with the freekin program.

Is there an input interface, a place to create and make databases, surely this is not the end of mysql?

Any help would be gratefully recieved, I am confident i can use the program if I can only get it to run locally on a win98v2 machine first. later I will need to run it on NT2000 machines locally as well.

Might zonealarm be the problem? Even though technically I only want it running on the machine?

[Ritesh]

Hello

It looks like that you are not able to start your MySQL Server on localhost . MySQL Docs will be of great help to you 😀

Use WinMySQLAdmin tool. Its for new users like you wherein it creates the default my.ini and puts it in the correct place so that you can start MySQL for the first time without the advance options ofcourse 🙂

After you start WinMy…. for the first time, it will sit in the tray. Right click on it and select Start Server…. The lamp will go to GREEN. Thats means MySQL is up 🙂

Start SQLyog, give MySQL Host address as localhost, username as root and you will be able to connect. 🙂

HTH

[netchicken]

Yeah! Thats it, its driving me nuts! I have uninstalled and tried a second time to no help…

I ran this

C:mysqlbin> mysqld-max –standalone

and nothing happened except the kernal processer went to 100%, no output at all otherwise

so I tried

C:> C:mysqlbinmysqld

zilch

and

C:> C:mysqlbinmysqld –standalone –debug

got nothing, not outputs at all, just spinning its wheels.

I would LOVE any suggestions on it I have read everything I can find on the topic.

:ph34r:

more …

doing this

C:> C:mysqlbinmysqlshow

I got the first response yet…

Can't connect to mysql server on localhost .. sigh

[CalEvans]

Have you checked your log files?

mysql generates some fairly complete log files.

I've not personally had this happen but I've not tried it on Win98. (yet) If this were Linux (where the bulk of my experience lies) I would say that your InnoDB table handler is trying to re-sync with it's logs or create it's initial DB space. The First time you bring mysql up it does this.

Is there a switch for turning InnoDB off? I would try that and see if it helps. (NOTE: I do not advocate doing this permanently as the InnoDB table handler is one of the great features of mysql.)

Keep us informed of your progress.

=C=

[netchicken]

Well, things have moved on, one of my students (!!) told me to download phptriad, and so I have installed that. Its working but I am still feeling around at what I have got. I was expecting an MS access type interface to use but don't see anything I recognise yet 🙂

I am working through this excellent article.

http://www.databasejournal.com/features/ms…10898_1558731_2

is there anything more you can recommend to work with this?

Thanks

[Ritesh]

Quote:

was expecting an MS access type interface to use but don't see anything I recognise yet

We have tried to keep the interface simple and non cluttered ( unlike MS Access ).

The mentioned article is a good place to start off ( probably the best introduction to SQLyog I have seen ). Once you become comfortable with SQLyog you can browse thru the features of SQLyog using the various menu.

If you have any problem..feel free to ask them in the board 😀

HTH

[netchicken]

Thanks, I will.

😀

[himagain]

Hello Fellows,

What a good job this program is!

HOWEVER, what is really needed out in the Cyberbog is a newby-newby introduction to thewhole sequence of building a database, which covers the “gotchas” along the way.

E.G. I went nutz 😮 trying to install and run a program paid for in hard cash! (and VERY badly written) in Delphi and feeding MySQL and outputting to MS XL.

The first real “gotcha” was that I didn't know that you had to reboot XP every time you altered anything in the install/setup process of MySQL. Thus, nothing SEEMED to work, especially any of the suggested fixes!

THEN XP user permissions came into it and was another can of worms! (Or gotchas)

But really, getting into programs at this level is rather like trying to replace the engine in your auto – seems simple enough to do………….

We do have to expect a big learning curve and as someone who suffered for years from the BSOD – no – not blue screen of death – THAT was predated by the Black Screen Of Disaster. When Manuals ran to 800 pages and didn't tell you anything at all that a Geek didn't already know and nothing useful at the SUI ( Simple User Installer) end.

I'm still looking for a simple explanation of how-to-build-a-simple-useful-database which covers the elementary “gotchas”.

Even to why have separate fields for firstname, middle, lastname. SEEMS a waste when you first start out……….. 😀

So we really need a REALLY Newby forum………………..

Cheers,

Him

[Author]

Posts