Greetings... In windows, in general the settings are done by default so that you can start it with the default case.
To start the server go to the bin directory and just enter mysqld. I dont think you need to enter --standalone or something like that. By default a root user is created with 'root' password or it is blank ( i dont remember exactly ). When you start mysqld....it wont close the command prompt...it will be just there showing you the information of the process. Either you can close the command window by clicking on the X or you can just keep it there. In another command window, goto the bin directory and start with mysql -hlocalhost -uroot -p If the password is root then type root as password or press Enter if its blank. After you get connected you can start executing querties. If you are adverse to command line then try using SQLyog, its a GUI to MySQL for Windows. http://www.sqlyog.com Insane SQLyog - The Definative MySQL GUI for MySQL http://www.sqlyog.com ----- Original Message ----- From: "Nikki Mason" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 19, 2002 7:46 PM Subject: Which files to download/install - problems running MySQL > Hi, > > I wish to learn SQL, and as some of my friends already use MySQL, they > recommended that I too use it. Please can you tell me what I need to > download and install to get me going. > > I have: > Pentium III 450Mhz, 256Mb Ram > Windows 98 > I don't have a C or C++ compiler installed. > My PC is not connected to a network - it is standalone. > > I had earlier downloaded just the zip file for version 4.0.4-beta (Windows). > I unzipped it and ran the 'setup' program. > > Once setup had completed I tried the test on the server - at no point had I > run the Admin program or created the my.cnf or my.ini. > > I opened a dos window and from the directory c:\mysql\bin entered: > mysqld --standalone > > No other text was shown in the dos window and it appeared to hang. The > whole computer also seemed to 'hang'. I had to use ctrl C to kill the > application and get back normal operation to my PC. > > I then tried manually creating the file c:\my.cnf and populated with the > information given in the installation instructions. The server still hung. > > I then tried using the admin program with the similar results - the green > traffic light was showing, but the dos window that was displayed appeared > 'hung' and again the PC itself seemed to have hung - it operated extremely > slowly. The task manager showed the admin tool as 'not responding'. > > What have I/am I doing wrong? > > Regards, > Nikki Mason > mailto:nikki_mason@;btopenworld.com > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php