Thanks, you guys. I can't wait to get home tonite and try it. So, where
do I create the database itself? I think mySQL calls it a "schemata".


>>> "Cruz Noel I "
<mysqldba-ezmlmshield-x79836779.[Email address protected] 12/7/2005
9:54:41 AM >>>

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


---------------------------------------------------------------------
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