Getting started with MySQL using wamp server

After installing the wamp server on your computer follow the below steps.

Step 1 : Run the command prompt. 

Step 2 : Copy the path of the bin folder of the wamp server. usually it is,

C:\wamp64\bin\mysql\mysql5.7.19\bin

Step 3 : Go back to the command prompt and change the directory to the path you copied

C:\Users\admin>cd C:\wamp64\bin\mysql\mysql5.7.19\bin

Step 4 : Then type the command "mysql -u root -p", then press enter.

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -u root -p

Step 5 : Then it will request the password, just enter because there isn't a password.

Enter password:

Step 6 : If you have successfully connected following message will be prompted.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Now you can start typing MySQL commands here onwards. To quit the wamp server simply type "quit".

mysql> quit
Bye

Comments

Post a Comment

Popular posts from this blog

Supporting code snippets for OOP take home assignment

Open a file and read data line by line. You're given a text(.txt) file as the input and not allowed to do manual user inputs. So you have to read the text file using your program. It can be done in the following way. Here the line is taken into a String called 'line'. To read lines you have to use the library 'fstream' #include <fstream> string line; ifstream myfile ("yourfilename.txt"); if (myfile.is_open()){ while(getline(myfile,line)){ // Enter your code here } myfile.close(); } src :  http://www.cplusplus.com/doc/tutorial/files/ Spliting string into two with blank space Method 1 Here 'line' is the String which we read from the file. To store the two sub strings we use a vector called tokens of type String. If you use this method after splitting the string into two parts you have to cast it into int. #include <vector> #include <string> #include <sstream> #include <it...
Read more

Java ADF surfing through pages using buttons

Image
Open 'Oracle JDeveloper Studio' by double clicking on the icon. Select Studio Developer (All Features) and press 'Ok'.  Press 'Finish' We need to create a folder before creating page fragments. Select from gallery Add a folder name and press 'Ok'.  Then create page fragments. Here we are studying the connection between two pages therefore we need to create two page fragments. Change the file name and press 'Ok'. At the components panel search 'panel box' then drag and drop a panel box onto the page fragment.  Then drag and drop a button from the panel 'General Controls'. You can change the names of the button and the panel box at the 'Common' tab. Then go to page flow in web content (in Applications tab) and create a ADF Task Flow. ...
Read more