I chowned everything under /usr/local to mysqld:mysqld and now it actually starts, but I'm not out of the woods yet. Here is what happens now: # mysqld --user=mysqld --basedir=/usr/local/ --datadir=/usr/local/var/mysql --skip-grant --verbose 110204 13:45:04 InnoDB: Started; log sequence number 0 44233 110204 13:45:04 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 110204 13:45:04 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 110204 13:45:04 [Note] mysqld: ready for connections. Version: '5.1.53' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
I can connect as root and create a database, which is good. I have run mysql_install_db, and mysql_secure_installation successfully, but when I attempt to run mysql_upgrade: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments Running 'mysqlcheck with default connection arguments Running 'mysql_fix_privilege_tables'... ERROR 1049 (42000): Unknown database 'mysql' FATAL ERROR: Upgrade failed Thanks! Eric On Fri, Feb 4, 2011 at 1:39 PM, Jeff Schroeder <[email protected]> wrote: > Eric: > >> I did run mysql_install_db and it did appear to succeed.. I didn't >> see any errors, anyway. I then proceeded to run >> mysql_secure_installation as recommended by mysql_install_db, and it >> threw errors about not being able to connect through >> /var/lib/mysql/mysql.sock. > > Right, because mysql_secure_installation requires that the database be > running. So before you run that, you'll need to start the MySQL > process itself. That's why you don't see the socket file. > >> 110204 13:28:08 [ERROR] mysqld: Can't find file: >> './mysql/time_zone_leap_second.frm' (errno: 13) >> 110204 13:28:08 [Warning] Can't open and lock time zone table: Can't >> find file: './mysql/time_zone_leap_second.frm' (errno: 13) trying to >> live without them >> 110204 13:28:08 [ERROR] mysqld: Can't find file: >> './mysql/servers.frm' (errno: 13) >> 110204 13:28:08 [ERROR] Can't open and lock privilege tables: Can't >> find file: './mysql/servers.frm' (errno: 13) > > All of these errors indicate that MySQL is expecting the database files > to be in the current directory (./mysql). I wonder why it's not > looking in /var/lib/mysql or something instead. Perhaps one of your > compile directives set the default data path? > > To test this, go into /var/lib and THEN start MySQL-- if this is the > problem, it should actually work because it'll look for a sub-directory > called mysql (which now exists where you are). > > Jeff > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ > /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
