Monday, 12 February 2018

Installing mysql in mac

https://www.youtube.com/watch?v=UcpHkYfWarM




https://dev.mysql.com/downloads/mysql/



------

2018-02-13T05:51:10.814358Z 1 [Note] A temporary password is generated for root@localhost:



If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.


-----------------------


Goto mac icon

system preferences . --> . You will see mysql

click on start server

-------------

2 ways connect to mysql server



1) terminal
2) mysql workbench

https://dev.mysql.com/downloads/workbench/

------------------

How to add MySQL to $PATH variable: cd to your home folder $ open -t .bash_profile Try adding the following line to your .bash_profile file. export PATH=${PATH}:/usr/local/mysql/bin/ Setting the MySQL root user password on OS X $ mysql -u root -p mysql$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';



--------------------

check whether you are in home directory or not by pwd


---------

1) pwd
2) ls -al -> you willl see .bash_profile


------------
if it is not there then create by using



touch .bash_profile



export PATH=${PATH}:/usr/local/mysql/bin/

and save file
------------


connect using terminal


mysql -u root -p

and paste the password copied . ---> . EkiTLjSmg3=B



it will open mysql >

-----------------
change password

ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';


-----------

confirm by opening new terminal and check with new password

---------

1 comment:

  1. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.Ruby on Rails Online Course India

    ReplyDelete