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
---------
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
---------
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