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 |
What is identity in mysql?
Why do we use views instead of tables?
What is mysql cursor?
What is cursor in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
How to find the unique values if the value in the column is repeated?
How many tables we can create in mysql database?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Does mysql case matter?
Where is mysql data stored?
What is the latest mysql?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
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)