I just installed mysql5. Compiling it went fine, and running it seems to be no problem using the supplied launchd item.
However, I am unable to connect to the database: ; mysql5 -h localhost -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) After messing around a bit (actually, several hours went down the drain doing this), finally running the server using the extra flag --skip-grant-tables, I found out that the table mysql.user had no rows at all. Adding data to this table by hand I now finally have a root user, hopefully with all the necessary privileges (time will show). Surely, this is not how the mysql setup is supposed to go. I must have done something wrong somewhere, but can't figure out where. This is basically what I did: #; port -v install mysql5-server [...] #; launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist #; /opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password' [... produced an access denied error like the one below ... but I seem to have closed that terminal window, so no copy ...] ; mysql5 -h localhost -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It did not seem to make any difference whether or not I ran ; sudo -u _mysql mysql_install_db5 (as recommended at the end of installation) before launchctl load. FWIW: This is macports version 1.8.2 on OS X 10.5.8 (intel). - Harald _______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
