RE: Newbie at a terrible loss to connect to local instance

RE: Newbie at a terrible loss to connect to local instance

 

  

The server name is the name of the computer on which MySQL (mysqld.exe)
is running.


Sincerely,
Noel Cruz
Programmer Analyst, Human Resources Systems Fairview Information
Management Services


-----Original Message-----
From: John Sposato
[mailto:mysqldba-ezmlmshield-x65520638.[Email address protected]
Sent: Wednesday, December 07, 2005 11:52 AM
To: LazyDBA Discussion
Subject: Re: Newbie at a terrible loss to connect to local instance

Your username is 'root' for the password you entered during
installation.

John A DAVIS wrote:

>I installed mySQL on my home computer and now I want to connect to it
>locally for some of my testing to avoid my roundtrips to ISP database.
>However, I can't figure out how to set up my mySQL Adminsitrator to
>make a database or tables! It asked me for a password during the
>install but besides that, I don't know what my username is or the
>server's name or anything to put into the connection screen of the
>mySQL Administrator (which works for my ISP database)! Same for an ODBC
driver.
>
>Any ideas? I can't believe they don't explain this somewhere in mySQL.
>For my ISP's mySQL/PHP account they sent me all the information.
>Someone out there knows this answer!
>
>Someone posted that By default MySQL installs with a root account.
>So, I type "root account" into the username window? I'm thinking not. I

>don't even understand what a root account is. During the install I
>disabled anonymous login and chose to give it a password. But I don't
>know what my server is called, I don't know what my username is, and I
>don't know what a root account is or the default for referencing it.
>Scratching head. Concepts and terms supposedly everyone is familiar
>with are greek to me. It would seem very easy and obvious, but not for
>this geek.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
>unsubscribe, e-mail: mysqldba-[Email address protected] Website :
>http://www.LazyDBA.com
>
>
>
>

--
John Sposato
Unit Director, Information Technology Group Department of Pathology,
College of Medicine University of Florida [Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com

MySQL LazyDBA home page