{"action":"opened","issue":{"number":8063,"created_at":"2011-10-11T03:55:50Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"Hello,\r\n\r\nI just realized that even after I have set up mysql using the command below, it refuses to start saying that mysql.host is missing. I can see it inside ~/mysql but mysql.server looks for the datadir where it usually is: /usr/local/var/mysql.\r\n\r\n```bash\r\nmysql_install_db --verbose --user=`whoami` --basedir=\"$(brew --prefix mysql)\" --datadir=/Users/macpro/mysql --tmpdir=/tmp\r\nInstalling MySQL system tables...\r\nOK\r\nFilling help tables...\r\nOK\r\n\r\n```\r\n\r\nHere's the log entry\r\n<pre>\r\n111010 23:46:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql\r\n111010 23:46:33 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive\r\n/usr/local/Cellar/mysql/5.5.15/bin/mysqld: Table 'mysql.plugin' doesn't exist\r\n111010 23:46:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.\r\n111010 23:46:33 InnoDB: The InnoDB memory heap is disabled\r\n111010 23:46:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n111010 23:46:33 InnoDB: Compressed tables use zlib 1.2.5\r\n111010 23:46:33 InnoDB: Initializing buffer pool, size = 128.0M\r\n111010 23:46:33 InnoDB: Completed initialization of buffer pool\r\n111010 23:46:33 InnoDB: highest supported file format is Barracuda.\r\nInnoDB: Log scan progressed past the checkpoint lsn 48941\r\n111010 23:46:33  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Restoring possible half-written data pages from the doublewrite\r\nInnoDB: buffer...\r\nInnoDB: Doing recovery: scanned up to log sequence number 1595675\r\n111010 23:46:33  InnoDB: Starting an apply batch of log records to the database...\r\nInnoDB: Progress in percents: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 \r\nInnoDB: Apply batch completed\r\n111010 23:46:34  InnoDB: Waiting for the background threads to start\r\n111010 23:46:35 InnoDB: 1.1.8 started; log sequence number 1595675\r\n111010 23:46:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist\r\n111010 23:46:35 mysqld_safe mysqld from pid file /usr/local/var/mysql/macpro.local.pid ended\r\n</pre>\r\n\r\nThanks\r\n\r\nPS: markdown stinks.","comments":0,"title":"mysql 5.5.15 mysql_install_db ignores \"--datadir\"","updated_at":"2011-10-11T03:55:50Z","url":"https://api.github.com/repos/mxcl/homebrew/issues/8063","id":1870542,"assignee":null,"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/86dc53894eecfe53cc093d1bf3980e11?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/aicm","id":527855,"login":"aicm"},"html_url":"https://github.com/mxcl/homebrew/issues/8063","labels":[],"state":"open"},"legacy":{"number":8063,"action":"opened","issue":1870542}}