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

Ask an Expert

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

Write your message here..

Related Questions

Nested queries, Nested Queries Let us see some more complex queries in ... Nested Queries Let us see some more complex queries in this section. Sub-queries: Some of the basic concerns of sub-queries are: A sub-query is a SELECT statemen

Explain weak and strong entity sets, Explain weak and strong entity sets? ... Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d... Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Describe the most important classes of parallel machines, Question 1 Discu... Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

Data definition language, Data Definition Language It organises the dat... Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Explain saving derived attributes to avoid re-computation, Saving Derived A... Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

ER diagrams, explain exhaustively the problems associated with ER diagrams.... explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Fds in relationships and teaches relationship, FDs in Relationships:  E... FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

Concurrency control, define lock conversion define lock conversion

Explain generalization and aggregation in e_r diagram, Explain the concept ... Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug