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