Home » 2014 » December

Monthly Archives: December 2014

Installing and Running mySQL

This tutorial will teach you how to install and run MySQL through your terminal in  Windows, Ubuntu, or Mac.

Windows:

First make sure you have Microsoft’s .NET Framework 4 installed. If it is not you can get it here.

Go to the MySQL download page. Select the mysql-installer-web-community-5.6.21.1.msi download.

 

Install:

  1. On the following page scroll down and click: “No thanks, just start my download”.
  2. Run the MSI file accepting any permission prompts.
  3. Click accept on the license agreement: 
  4. Select Developer Default and hit next.
  5. You will most likely have some warnings on the Check Requirements page, that is okay. Select “Next” and then confirm the warning.
  6. Your Installation page should look similar to this: Select Execute.
  7. When the install is done it should look similar to this: The failed status on Connector/ODBC is okay.
  8. Next the installer walks you through configuring your MySQL server. On “type and Networking” page leave everything as is:
  9. Give the account a root password. You can also create a new user here, or leave it empty and use root when you login.
  10. On the following page “Windows Service”  you can once again leave everything in the default state:
  11. On the “Apply server Configuration” page select Execute, then select Finish once the configuration is done.
  12. Next the installer will configure Samples and Examples:
  13. User and Password should be filled in for you on the Connect To Server page, select check, and  then next:
  14. Select Execute and then finish, then next, and then Finish. MySQL should now be Installed.

Running:

  1. From the start menu run MySQL 5.6 Command Line Client -Unicode:                                                   
  2. Type in your root password and you are now in mySQL.

Mac OSX (Yosemite):

From the mysql site Download Mac OS X 10.9(x86, 64-bit), DMG Archive:

and on the following page select “No thanks, just start my download” at the bottom of the page.

  1. Open the dmg and double click on the package and you should get this dialogue box: 
  2. Press continue twice, and agree to the license
  3. Do the standard install, or change the location to your preferred directory, and click install. 
  4. Once you run the installation, you may get a pop up saying the install failed.  Don’t worry the install worked.
  5. To start the server run the following command  in your terminal:
    sudo /usr/local/mysql/support-files/mysql.server start
  6. You now want to edit you PATH to make it easier to open mySQL  use your preferred text editor to edit your .bash_profile from your home directory and add:
    export PATH="/usr/local/mysql/bin:$PATH"
  7. Then in a terminal source the file:
    source .bash_profile
  8. You can now run mysql in a terminal with the command:
    mysql -v
  9. And you can set the root password with:
    /usr/local/mysql/bin/mysqladmin -u root password 'yourpasswordhere'
  10. And now you can log in to mysql as root with:
    mysql -u root -p

Ubuntu 14.04

  1. In your terminal run sudo apt-get update:
    sudo apt-get update
  2. run:
    sudo apt-get install mysql-server-5.6
  3. Enter “Y” when prompted and shortly you will see this configuration box, select ok:
  4. Type in the root password you would like to use for the new mysql root account:
  5. And confirm the password in the next prompt.
  6. You should now be able to run mysql with the following command:
    mysql -u root -p