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';

What is sqlyog?

0 Answers  

---

Is Mysql query is case sensitive?

0 Answers  

---

How to enable or disable a row of a table using MySQL in struts?

0 Answers  

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

How do I install the latest mysql on ubuntu?

0 Answers  

---

What is strict mode in mysql?

0 Answers  

---

How can we change the name and data type of a column of a table?

9 Answers   Google,

---

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

0 Answers  

---

How to create a table?

0 Answers  

---

What is data type for image in mysql?

0 Answers  

---

What are the functions of commit and rollback statements?

0 Answers  

---

how can you test for null values in a database? : Mysql dba

0 Answers  

---