logo
TOOLS TO HELP YOU LEARN
teachers, students, everyone
Tools | Blog | Account | Learn
Login Status

MySQL Database
How to install on your computer
Jan 4, 2017

  1. Download latest version
    http://dev.mysql.com/downloads/mysql/
    For MACs, double-clicking the .pkg file will launch the installer that will install MySQL on your system.

  2. During installation the following information should pop up
    temporary password is generated for root@localhost: Piu/TvwfA8wO

  3. The installer installs MySQL in the /usr/local/mysql-version directory.

  4. To start the MySQL database open up TERMINAL
    sudo /usr/local/mysql/support-files/mysql.server start
    You will be prompted to Enter your password. This will be password for your computer.

  5. At this point, MySQL should be running on your localhost (127.0.0.1) on port 3306.
    To use the database however, you now need to login to the server. To be able to access it you need to set the path.
    In terminal type the following
    nano .bash_profile

  6. To update the PATH variable update the bash_profile as such:
    PATH=/usr/local/mysql/bin:$PATH
    Exit and save (ctrl x or c)
  7. TYPE FOLLOWING COMMAND into terminal TO RESET
     . ~/.bash_profile
  8. You can now login using following command to login to mysql
     mysql -u root -p

    You will be prompted for password. Type in the password from step 2

  9. HOW TO CHANGE root PASSWORD for mysql:
     mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';

    (you’ll get an error) then type this line:
     SET PASSWORD = PASSWORD('your_new_password');
  10. try to create a database:
    at mysql prompt type: CREATE DATABASE coolData;

    Show Databases: show databases;

    START working with a database: use coolData;

    show tables: show tables;

  11. Download MySQL Workbench
    https://dev.mysql.com/downloads/workbench/

    Stop MySQL
    sudo /usr/local/mysql/support-files/mysql.server stop
    Restart MySQL
    sudo /usr/local/mysql/support-files/mysql.server restart

Comments:




No comments posted

blog

Past Posts

Dropbox Public Folder Alternative
Jun 4, 2017

Getting Started with NodeJS
May 1, 2017

Scratch Intro: Racing Game
Jan 15, 2017

Five Best Educational Tools For Teachers
Feb 3, 2017

Coding Gravity
Feb 22, 2017

Drones in Eduction
March 2, 2017

Javascript Intro
April 1, 2017

iPhone Streaming Audio App
April 15, 2017

Installing MySQL
May 15, 2017

 

 


 

Thank You!