MySQL: Grant **all** privileges on database

by 
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

This is how I create my “Super User” privileges (although I would normally specify a host).

IMPORTANT NOTE

While this answer can solve the problem of access, WITH GRANT OPTION creates a MySQL user that can edit the permissions of other users.

The GRANT OPTION privilege enables you to give to other users or remove from other users those privileges that you yourself possess.

For security reasons, you should not use this type of user account for any process that the public will have access to (i.e. a website). It is recommended that you create a user with only database privileges for that kind of use.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0
  2. how to delete data from table A besides the customer service and director data in table B?
  3. Trouble with UTF-8 characters; what I see is not what I stored
  4. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  5. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  6. Error: select command denied to user ”@” for table ”
  7. MySQL error 1064 syntax but everything seems fine
  8. MySQL/MariaDB – order by inside subquery
  9. Cast int to varchar
  10. How can I change MariaDB to MySQL in XAMPP?
  11. Higher cardinality column first in an index when involving a range?
  12. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  13. How to turn on/off MySQL strict mode in localhost (xampp)?
  14. MySQL – SELECT * INTO OUTFILE LOCAL ?
  15. Database corruption with MariaDB : Table doesn’t exist in engine
  16. CREATE command denied to user？
  17. django cannot connect mysql in docker-compose
  18. Rank function in MySQL
  19. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  20. MySQL query String contains
  21. Mysql localhost != 127.0.0.1?
  22. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  23. MySQL remote connection fails with “unknown authentication method”
  24. Import MySQL database into a SQL Server
  25. How create json format with group-concat mysql?
  26. MySql Query Replace NULL with Empty String in Select
  27. how to trim leading zeros from alphanumeric text in mysql function
  28. What are the max number of allowable parameters per database provider type?
  29. How to handle a query with special characters / (forward slash) and \ (backslash)
  30. mySQL query to search all tables within a database for a string?

Leave a Comment