Thx, I'm further now through: sudo chown -R mysql:mysql /opt/local/var/db/mysql5 sudo chmod u+rwx,go= /opt/local/var/db/mysql5
But now I can't set the password. Is this related to the initial problem ? I started mysql... sudo /opt/local/share/mysql5/mysql/mysql.server start and now I struggle with... allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password' /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' or allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password' /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root -h allisones-mac.fritz.box password 'new-password' /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'allisones-mac.fritz.box' failed error: 'Host 'localhost' is not allowed to connect to this MySQL server' I remember this steps to be straight forward, what is happening now that this doesn't work out of the box ? 2010/12/5 Jasper Frumau <[email protected]> > Maybe a file/folder permissions issue. See also > http://forums.freebsd.org/showthread.php?s=0d9db79ab2a610ba86748801aa3c0565&t=19807&page=2(page > two of similar thread @ BSD) Using DiskUtilities you can check disc > file permissions as well for the whole disc. But none of my > suggestions/solutions are warranted. I just use MAP for web development.. > > On Sun, Dec 5, 2010 at 7:25 AM, Sebastian Wojtowicz < > [email protected]> wrote: > >> Forgot to say, that error comes on >> sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql >> >> 2010/12/5 Sebastian Wojtowicz <[email protected]> >> >> Has someone found a solution to this problem ? Cause I see posts, but no >>> working solution in the internet. >>> This night I have reinstalled Mac OSX Snow Leopard, updated to the newest >>> version 10.6.5, Installed XCode newest Version 3.2.5, installed newest >>> macports, did a selfupdate and then did a "sudo port install mysql5".... all >>> that TWICE >>> Tried "unset TMPDIR" >>> tried to set "tmpdir = /tmp/" in "/opt/local/etc/mysql5/my.cnf" >>> >>> I always get the same error message. >>> >>> Thanks for the help >>> >> >> >> _______________________________________________ >> macports-users mailing list >> [email protected] >> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users >> >> >
_______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
