After successfully setting up PostgreSQL and better understanding the user and permission problems I attempted to reinstall mySQL which had been running but b/c of permission stuff i could only access databases that began with "test". I installed the OS X bundle with Startup module and then got the server up and running no problem but as soon as I tried to get the mysqladmin i got the infamous "ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
later i tried again and it seems to have gotten worse, i looked into the .err file after the server wouldn't start up after i aborted the first time and this was what it had: 030922 16:37:52 mysqld started 030922 16:37:53 Can't start server: Bind on TCP/IP port: Address already in use 030922 16:37:53 Do you already have another mysqld server running on port: 3306 ? 030922 16:37:53 Aborting I tried to "kill 3306" and it claimed there was "no such process" I have a GUI fronted called MacSQL already installed that i was using before when I could only edit test_... db's in mySQL but I doubt that could be causing a problem since it didn't for PostgreSQL so i really don't know what is going on with this. Sorry to be bothering the list again but i followed the directions the best I could and this really shouldn't be this problematic, hopefully if i can get it work I can help clarify the documentation with my experiences. Thanks again -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]