Answer / rajan vardawaj

The generic syntax for GRANT is as following GRANT [rights]
on [database] TO [username@hostname] IDENTIFIED BY
[password] Now rights can be: a) ALL privilages b)
Combination of CREATE, DROP, SELECT, INSERT, UPDATE and
DELETE etc. We can grant rights on all databse by usingh *.*
or some specific database by database.* or a specific table
by database.table_name.

Answer / kamal

GRANT ALL on *.databasename to root identified by 123456

Answer / sandeep kumar

GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON mydb.mytbl TO 'someuser'@'somehost';

Write a query to fetch common records between two tables using mysql?

0 Answers  

---

how we can use more then one primary key in Single Table

9 Answers   Systematix,

---

Write a query to find duplicate rows in table?

0 Answers  

---

Can a table have multiple primary keys?

0 Answers  

---

How to get full name of monthname ?

4 Answers  

---

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  

---

If you wish to encrypt the username and password using php, how will you do that?

0 Answers  

---

How do you prevent MySQL from caching a query?

1 Answers  

---

How do I clear a mysql database?

0 Answers  

---

How triggers can be used in mysql?

0 Answers  

---

What is the insert?

0 Answers  

---

what is the default port for mysql server? : Mysql dba

0 Answers  

---