[MySQL with MAMP] Using MySQL with MAMP in a Terminal

 

To use the MySQL command line with MAMP or MAMP PRO, perform the following steps:
  1. Start MAMP or MAMP PRO
  2. Start the server
  3. Open Terminal (Applications -> Utilities)
    Type in: (one line)
    
/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot
Now you can use the MySQL command line. For exmaple to show all your databases with show databases;.

Comments

Post a Comment

Popular posts from this blog

[Mac OS X] Creating a .bash_profile on your Mac Terminal

Image
Look & Feel of the Terminal window can be modified in two ways: First by opening the Preferences option available under Terminal Menu --> Preferences and make modifications to the layout settings of my choice. Other option is using a .bash_profile. When you want to run functions from your command line, this is a must-have. Following steps will create a .bash_profile under the home directory. Start up Terminal Type "cd ~/" to go to your home folder Type "touch .bash_profile" to create your new file. Edit .bash_profile with your favorite editor (or you can just type "open -e .bash_profile" to open it in TextEdit. Type d following in my .bash_profile file: # Make ls use colors export CLICOLOR=1 alias ls='ls -Fa' # define colors C_DEFAULT="\[\033[m\]" C_WHITE="\[\033[1m\]" C_BLACK="\[\033[30m\]" C_RED="\[\033[31m\]" C_GREEN="\[\033[32m\]" C_YELLOW="\[\033[33m\]" C_BLUE=...
Read more

[Advance Java] Difference Between Apache and Tomcat

Image
The most prevalent use of the internet today is browsing. People all around the world find information by accessing data from other computers through their browser; but beyond that, people know very little. In order to communicate with the host computer, the browser would need to request pages from a http server that is run on the host computer. It would then be responsible for finding and providing you with the right pages. An excellent and very popular web server around today is the Apache web server. It allows people who want to set-up their own web server to do so with very little trouble. Installing the Apache web server is the most basic thing you can do to support html and other related software. The next step is to install more software that complements the web server like PHP or Tomcat. Tomcat is another piece of software that is meant to enhance the usability and interactive experience that users experience with your website. Because Tomcat is also a serv...
Read more

Setting ESLint on a React Typescript project

Image
  Introduction After struggling a lot trying to install and understand ESLint on my React Typescript project, I decided to create a definitive guide to setting ESLint to a React Typescript project. The main goal of this tutorial is to set up step-by-step and explain every line added or executed, instead of just giving you a bunch of files with a lot of configurations and expecting that you will be able to understand what and how things are happening. So, let’s start! Prerequisites Note: You need Node version >= 10 installed. So, if you don’t have it, please go to the NodeJS website, and download and install it on your local machine. ( https://nodejs.org/en/ ) Step 1: Create a React Project with Typescript The following command will create a project inside a folder  my-app . On the terminal, run: npx create-react-app my-app --template typescript Step 2: Removing the pre-set ESLint configuration from React project React comes with an eslint configuration pre-setted. Let’s rem...
Read more