[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

[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

How to Choose a Technology Stack for Web Application Development

Image
What’s the most important thing to consider when you’re developing a top-notch web application? No doubt it’s the technology stack your app will be based upon.  The choice of a relevant tech stack is particularly challenging for small businesses and startups, since they usually have limited budgets and, thus, need a technology stack that provides the most bang for the buck to get their projects off the ground. The right tech stack is, to a great extent, the key to your project’s success, while the wrong choice of web development technologies may be a reason for failure. We’ve decided to give you a helping hand and reveal the criteria for choosing the most appropriate tech stack for your web application. WHAT IS A TECHNOLOGY STACK FOR WEB DEVELOPMENT Before moving on to the criteria for choosing a modern web technology stack, you should clearly understand what comprises the process of web development. Without going too deep into details, there are two sides to we...
Read more

[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