How can you connect to the mysql server, Database Management System

How can you connect to the MySQL Server?

In order to connect to the MySQL server it is necessary to give the username and password so this be able to done with

The following

% mysql -h local host -p -u root

-h local host to connect to MySQL server running on the local host

-p to tell mysql to prompt for a password

-u root to connect as the MySQL root user


Posted Date: 7/31/2013 1:55:12 AM | Location : United States

Related Discussions:- How can you connect to the mysql server, Assignment Help, Ask Question on How can you connect to the mysql server, Get Answer, Expert's Help, How can you connect to the mysql server Discussions

Write discussion on How can you connect to the mysql server
Your posts are moderated
Related Questions
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.

Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c

Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Explain controlled redundancy? Controlled redundancy : The replication of data within the data warehouse for the purposes of improved data access or understand ability.

Define the notation for classes and atrributes The notation for class, attribute, and operations are shown below:     Figure: Class with attributes and operations A

Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

What is the difference between the function module and a normal ABAP/4 subroutine? In contrast to normal subroutines function modules have uniquely exact interface.  Declaring da