Spring boot Part 3 : MySQL Installation
#mysql #installation #springboot #JpaRepository
Installation of MySQL server
Visual C++ download:
https://download.visualstudio.microso...
MySQL downloading path:
https://cdn.mysql.com//Downloads/MySQ...
Step 1:
create a file with name mysql-init.txt
Step 2:
copy the given line inside the file
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Step 3:
run the command
mysqld --init-file="location of file created in step 1 i.e. `mysql-init.txt`" --console
Step 4:
Once the server comes up then open another cmd from bin folder
then try to connect with mysql:
mysql -u root -p
password : root
It should be connected.
Step 5:
Then close the command prompt opened in step 3.
Step 6:
Run the below command:
mysqld --install
mysqld --initialize