Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think one can end up in this position with older versions of mysql already installed. I had the same problem and none of the above solutions worked for me. I fixed it thus:</p> <p>Used brew's <code>remove</code> &amp; <code>cleanup</code> commands, unloaded the <code>launchctl</code> script, then deleted the mysql directory in <code>/usr/local/var</code>, deleted my existing <code>/etc/my.cnf</code> (leave that one up to you, should it apply) and launchctl plist</p> <p>Updated the string for the plist. Note also your alternate security script directory will be based on which version of MySQL you are installing.</p> <p>Step-by-step:</p> <pre><code>brew remove mysql brew cleanup --force launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist sudo rm -rf /usr/local/var/mysql </code></pre> <p>I then started from scratch:</p> <ol> <li>installed mysql with <code>brew install mysql</code></li> <li><p>ran the commands brew suggested: (see note: below)</p> <pre><code>unset TMPDIR mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp </code></pre></li> <li><p>Start mysql with <code>mysql.server start</code> command, to be able to log on it</p></li> <li><p>Used the alternate security script:</p> <pre><code>/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation </code></pre></li> <li><p>Followed the <code>launchctl</code> section from the brew package script output such as,</p> <pre><code>#start launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist #stop launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist </code></pre></li> <li><p>Boom.</p></li> </ol> <p>Hope that helps someone!</p> <p><strong>Note:</strong> the <code>--force</code> bit on <code>brew cleanup</code> will also cleanup outdated kegs, think it's a new-ish homebrew feature.</p> <p><strong>Note the second:</strong> a commenter says step 2 is not required. I don't want to test it, so YMMV! </p>
    singulars
    1. This table or related slice is empty.
    1. PObrew install mysql on mac os
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USLorin Rivers
    1. USLorin Rivers
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PObrew install mysql on mac os
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, worked like charm!
      singulars
      1. PO
      1. USMario Uher
    2. COThank you for your detailed instruction! Installing mysql in mac all night long had almost killed me.
      singulars
      1. PO
      1. USCMinus
    3. COGreat answer, thanks! One thing to add: Though it is mentioned in the answer, I missed it and in so doing lost about 6 hours trying to get set up on Lion OSX. Make absolutely sure that you delete the old mysql directory at /usr/local/var/mysql if you have a previous version of MySql before you reinstall. Otherwise you will not be able to log in as root initially to set the password and you will spend a lot of time yelling at your computer.
      singulars
      1. PO
      1. UStronbabylove
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload