Connect MySQL Database Tutorial Example

How To Connect MySQL Database Tutorial Example

Open your MySQL Client tools then copy & paste the below code to Connect to MySQL database server

   -- mysql.exe location: c:\xampp\mysql\bin\mysql.exe
   -- host: localhost
   -- username: root
   -- password: ***

   -- modify your host location, username, password accordingly.
   -- i am using dos prompt as client. you can use phpmyadmin or anything else you like.

   -- just copy & paste the bellow code in ms-dos prompt
 

   c:\xampp\mysql\bin\mysql -hlocalhost -uroot -p

      -- that's it!! we are connected to mysql database using the mentioned credentials
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Connect MySQL Database Tutorial Example - Result in MySQL Client Tools

 

Related Tutorial Examples

1. MySQL NULL Date value Example using PHP
2. MySQL NULL values in arithmetic expressions SQL Statements Example
3. MySQL NULL or NOT NULL value check Example using PHP
4. MySQL NULL value check Example using PHP
5. MySQL NULL value Example using PHP
6. How to Modify Column From MySQL Existing Table Example
7. MySQL Stored Procedure: Creating Table using Stored Procedure Example
8. 20 steps to make CakePHP Blog Project