Help with mySQL

[Warren Samples]

On Mon, 2011-03-07 at 12:04 -0600, Warren Samples wrote: 
> On Mon, 2011-03-07 at 08:53 -0800, Peter Haworth wrote: 
> > Folks,
> > Thanks for the pointers on mySQL admin tools.  I'm trying out a couple, Workbench and Sequel Pro and having a problem getting off the ground.  I've been using SQLite so far so connecting to a server is a new thing.
> > 
> > Here's the problem.  I can't build a mySQL database until I define a connection but I can't figure out how to set up that first connection.  I'm logged in to my Mac as an administrator but any connections I try to define are rejected by the server because I don;t have the rights to set one up.  And I can't give myself whatever rights I need because I don;t have a connection to the server!
> > 
> > Grateful for any guidance.
> > 
> > Thanks,
> > 
> > Pete Haworth
> > 
> > 
> > 
> > 
> 
> 
> Have you tried logging in as user "root" leaving password empty? This
> may be necessary the very first time you log in. Then, you can set up a
> more normal and secure account with admin privileges and delete the
> unsecure root account, or give it a password if that idea bothers you. 
> 
> http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html
> 
> Good luck!
> 
> Warren
> 


To be more clear, this is the login credentials you supply as you set up
a connection in your GUI tool. I used the predecessor to SequelPro and
liked it. It's a good tool and I add my recommendation :)

Warren