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 to install mysql?
What is the difference between unix timestamps and mysql timestamps?
Create table employee (eno int(2),ename varchar(10)) ?
How can you change the name of any existing table by using the sql statement?
What are the ways in which you can retrieve data in the result set of mysql using php?
A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
How do I create a new database in mysql?
What is mysqladmin flush hosts?
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
What is mysqli_result?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
In which language mysql has been written?
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)