Couldn't he use the default Sites folder in ~/, or is that for something else?
Scott -- R. Scott Granneman [EMAIL PROTECTED] ~ www.granneman.com Full list of publications @ http://www.granneman.com/publications My new book: Linux Phrasebook @ http://www.granneman.com/books "I don't want to achieve immortality through my work ... I want to achieve it through not dying." ---Woody Allen On Nov 24, 2008, at 9:56 AM, David Dooling wrote: > > On Sun, Nov 23, 2008 at 09:11:16PM +0100, [EMAIL PROTECTED] wrote: >> I'm working on a mysql database for the first time - thanks to the >> help of some people on this list - and I've got a question about >> management front end software. I'm working on OS X, and the database >> is locally installed. >> >> I installed sequel pro, (formerly cocao mysql) and haven't been able >> to access the database because of permissions problems. The database >> is there - when I run SHOW DATABASES; at the mysql promp I can see >> it, >> but when I try to access with my user name and password (I have admin >> privileges) it says I'm not authorized. I also tried with root and my >> password, and it didn't work either. This is a known problem, but I >> have't found a solution: >> http://code.google.com/p/sequel-pro/wiki/FAQ >> I understand that there is a root user on os x, but I've never used >> it. Could anyone give me any pointers? > > To become root in Mac OS X, use sudo as an Adminstrative user. > > $ sudo bash > > then enter the user password. However, the MySQL root user is > different from the system root user. By default, MySQL creates a root > user with no password. You should be able to log in like this. > > $ mysql -u root > > You should change the password for security. > >> I would also like to install phpminadmin and phpmyadmin. The first >> one >> is much simpler to install and use - one php file - but I'm not sure >> where to install either one of them. The documentation says to >> install >> it on the server at the root level, but my database is local - should >> I install it to /usr/local/? /usr/local/mysql-xxxx? > > You would install them under the Apache httpd DocumentRoot. Look in > /etc/httpd/httpd.conf for the location. On my MacBook, its. > > $ grep '^DocumentRoot' /etc/httpd/httpd.conf > DocumentRoot "/Library/WebServer/Documents" > > -- > David Dooling > http://www.politigenomics.com/ > > > --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
