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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
