Help with mySQL

Peter Haworth pete at mollysrevenge.com
Mon Mar 7 21:21:35 EST 2011


Thanks thatt did it.  t filled in root as the user but default and I guess I was hung up with root needing a password.

Pete Haworth

On Mar 7, 2011, at 10:04 AM, 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
> 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> 





More information about the use-livecode mailing list