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