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 -~----------~----~----~----~------~----~------~--~---
