not sure about the Administrator. I use SQLyog for my stuff. I love it.

www.webyog.com



John A DAVIS wrote:

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


MySQL LazyDBA home page