From: Date: June 20 2009 9:39am Subject: Re: Error logging in to mysql List-Archive: http://lists.mysql.com/php/96 Message-Id: <262846110906200039j5f51a95g1f55e04e2767ccae@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd146d43df762046cc2bc8b --000e0cd146d43df762046cc2bc8b Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Vinay, Type : mysql -u root -p this will prompt you for password Enter password: If login successful A welcome note will appear ... you can try GUI interface to manage mysql PHPMyAdmin. Please let me know if this was helpful. Regards, On Fri, Jun 19, 2009 at 2:53 AM, Vinay Nagrik wrote: > Dear list, > > I have downloaded and installed mysql database and finding difficulty in > the > very first step. I am logged on as 'administrator' on my machine and have > a > password assigned to me. > > I can ensure through 'Microsoft services' that mySQL database is running > and > I do get the prompt on 'mysql' after typing in the same command. > > However when I type > > mysql > mysql -p > > The screen does not show > > "Enter Password" > > Also when I type the command ' show databases'. It shows following > databases "Without my being logged in" > > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | test | > +--------------------+ > 2 rows in set (0.00 sec) > > Can someone please take me pass the logging in command. I, as an > administrator want to create more users for mysql database. > > For some this must be a trivial problem. Thanks in advance. > > -- > Thanks > > Nagrik > --000e0cd146d43df762046cc2bc8b--