What are some good ideas regarding user security in MySQL?
Answers were Sorted based on User's Feedback
Answer / guest
There is no user without a password. There is no user
without a user name. There is no user whose Host column
contains % (There are as few users as possible (in the
ideal case only root) who have unrestricted access
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amita
u can use grant command for security. assigned access to the
user according to the requirement
| Is This Answer Correct ? | 0 Yes | 0 No |
How many TRIGGERS are allowed in MySql table?
How to rename an existing table in mysql?
What is the difference between truncate and delete?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How to Change a users password from unix shell.
what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 Answers Infosys, Sierra Atlantica,
Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..
What is a scalar function?
Where is mysql used?
What is DML in MySQL?
How do I install the latest mysql on ubuntu?
If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)