Mac install and open mysql using terminal

(Updated for 2017)

When you installed MySQL it generated a password for the root user. You can connect using

/usr/local/mysql/bin/mysql -u root -p

and type in the generated password.

Previously, the root user in MySQL used to not have a password and could only connect from localhost. So you would connect using

/usr/local/mysql/bin/mysql -u root

Related Posts:

  1. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
  2. Installing Homebrew on OS X
  3. You don’t have write permissions for the /Library/Ruby/Gems/2.3.0 directory. (mac user)
  4. Terminal error: zsh: permission denied: ./startup.sh
  5. You don’t have write permissions for the /Library/Ruby/Gems/2.3.0 directory. (mac user)
  6. brew install mysql on macOS
  7. mvn command not found in OSX Mavrerick
  8. How to install Java 8 on Mac
  9. Install Visual Studio 2015 on mac
  10. Change default title in mac terminal window
  11. mvn command not found in OSX Mavrerick
  12. How to use vim in the terminal?
  13. -bash: export: `=’: not a valid identifier
  14. How to use vim in the terminal?
  15. OS X cp command in Terminal – No such file or directory
  16. Can’t connect to MySQL server on ‘127.0.0.1’ (61) on Mac
  17. psql: FATAL: role “postgres” does not exist
  18. Reset MySQL root password using ALTER USER statement after install on Mac
  19. Run script on mac prompt “Permission denied”
  20. Finding text inside a folder using terminal
  21. cannot download, $GOPATH not set
  22. gdb debugging in Terminal OS X (10.8.5) with zsh
  23. How do you stop MySQL on a Mac OS install?
  24. How can I display the current branch and folder path in terminal?
  25. How to navigate to to different directories in the terminal (mac)?
  26. Open Sublime Text from Terminal in macOS
  27. Unable to access MySQL after it automatically generated a temporary password
  28. How do I install pip on macOS or OS X?
  29. Git is not working after macOS Update (xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)
  30. Git is not working after macOS Update (xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)
  31. How can I run python in terminal on a mac?
  32. Where to place $PATH variable assertions in zsh?
  33. Enable OpenMP support in clang in Mac OS X (sierra & Mojave)
  34. How to view / open a calculator in mac OS X?
  35. How to uninstall Python 2.7 on a Mac OS X 10.6.4?
  36. VirtualBox NS_ERROR_FAILURE (0x80004005) macOS
  37. How do I upgrade to Python 3.6 with conda?
  38. pip or pip3 to install packages for Python 3?
  39. How to install JQ on Mac on the command line?
  40. SocketException: Address already in use MONGODB
  41. Why is the apt-get function not working in the terminal on Mac OS X v10.9 (Mavericks)?
  42. OS X: equivalent of Linux’s wget
  43. ImportError: No module named sklearn (Python)
  44. What’s a good hex editor/viewer for the Mac?
  45. OS X: equivalent of Linux’s wget
  46. How to switch Python versions in Terminal?
  47. How to change default Python version?
  48. What version of Python is on my Mac?
  49. How do you update Xcode on OSX to the latest version?
  50. Mongod complains that there is no /data/db folder
  51. How can I open the Atom editor from the command line in OS X?
  52. How to uninstall Docker completely from a Mac?
  53. How to easily install and uninstall docker on MacOs
  54. How to install wget in macOS?
  55. Maven Install on Mac OS X
  56. editing PATH variable on mac
  57. keep getting “? Something is already running on port 3000” when I do npm start on react app
  58. How to update Ruby with Homebrew?
  59. Upgrade Node.js to the latest version on Mac OS
  60. Recursively find all files that match a certain pattern
  61. Installing cgdb on a mac os x
  62. How do I update the password for Git?
  63. How can I install a previous version of Python 3 in macOS using homebrew?
  64. What is the “Illegal Instruction: 4” error and why does “-mmacosx-version-min=10.x” fix it?
  65. Xampp MySQL not starting – “Attempting to start MySQL service…”
  66. How can I Remove .DS_Store files from a Git repository?
  67. Shared folder between MacOSX and Windows on Virtual Box
  68. VirtualBox: mount.vboxsf: mounting failed with the error: No such device
  69. Installing GCC on macOS Catalina
  70. gdb fails with “Unable to find Mach task port for process-id” error
  71. How do I edit $PATH (.bash_profile) on OS X?
  72. matplotlib: RuntimeError: Python is not installed as a framework
  73. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  74. Arduino IDE is not showing any port macOS
  75. gcloud command not found – while installing Google Cloud SDK
  76. boto3 python 2.7 ImportError: No module named boto3 USER_BASE USER_SITE site packages doesn’t exist
  77. Python: source code string cannot contain null bytes
  78. Python can’t find module NLTK
  79. Making sure /usr/local/bin is in my $PATH on mac
  80. Why does cURL return error “(23) Failed writing body”?
  81. Command not found go — on Mac after installing Go
  82. How to install pip for Python 3 on Mac OS X?
  83. Updating php version on mac
  84. Reading syslog output on a Mac
  85. Failed to launch macOS app built in Xcode
  86. Testing web application on Mac/Safari when I don’t own a Mac
  87. What is the best/safest way to reinstall Homebrew?
  88. How to completely uninstall Android Studio on Mac?
  89. SQL Client for Mac OS X that works with MS SQL Server
  90. How to stop mysqld
  91. Is there an equivalent of lsusb for OS X
  92. How do I install pip on macOS or OS X?
  93. How to install latest version of openssl Mac OS X El Capitan
  94. How to restart a node.js server
  95. What specific database privileges does WordPress need?
  96. What is the most secure way to set up the MySQL user in WPMU?
  97. Create a quick start wordpress installation [closed]
  98. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  99. How can I fix WordPress installation errors?
  100. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)

Leave a Comment