In fact, the problem with sequel pro was the lack of a root password. Once I created one on the command line, I could log in as root without a problem.
Thanks again, ned Edward Blumenthal [EMAIL PROTECTED] On Sat, Nov 29, 2008 at 23:43, <[EMAIL PROTECTED]> wrote: > Thanks for the advice. It took me a while to respond because I can > only work on this on the weekends. > >>> 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 >> > In fact, my question was more how to run sequel pro as root (if this > is indeed the problem.) I hadn't had problems logging in from the > command line, but I'd like to be able to get to the database from the > gui. > > I can run > $ sudo /Applications/Sequel\ Pro.app/Contents/MacOS/Sequel\ Pro > which launches sequel, but I get the same error message when > connecting to the database. What I understand from you message is that > this is because I should be using mysql's root and not my computer's - > but I'm still not sure how to do that from within sequel pro. > > However I was able to log in as root as you suggested, and change the > password. In fact, I had been starting mysql from the command line > with sudo, but I guess this isn't necessary. > > regards, > > ned > > Edward Blumenthal > [EMAIL PROTECTED] > > > > On Mon, Nov 24, 2008 at 16:56, David Dooling > <[EMAIL PROTECTED]> 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 -~----------~----~----~----~------~----~------~--~---
