Skip to main content

Posts

Showing posts with the label MySQL

JAVA SCRIPT

 OVERVIEW

DATA BASE - MySQL Server

What is SQL? - SQL stands for Structured Query Language. DATA BASE - A database is a collection of data that is organized in a manner that facilitates easy access, as well as efficient management and updating. - A database is made up of tables that store relevant information. Let's See How can we connect with the database using CLI. - Here I am using an XMPP server so I am going to connect the MySQL server through XAMPP. - Before we proceed make sure your Apache and MySQL services must be started. - You can see the web view of the server  - " http://localhost:8080/phpmyadmin/ ". Let's started  - 1.    Open CMD Prompt and type cd\ to come to parent drive i.e C:\ 2.    Type " cd xampp/mysql/bin " to come to the SQL folder to run MySQL. 3.     T o execute the server type the command: " mysql -u root -p "     Here, "mysql" is the server (data management). -u means username and root is the user's name. -p for password   ...