Help with mySQL

Warren Samples warren at warrensweb.us
Mon Mar 7 13:04:58 EST 2011


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






More information about the use-livecode mailing list