![]() It is common practice, for example, for each unique MySQL database on a server to have its own unique user associated with it, such that only one single user has authentication access to one single database and vice-versa. The newer Debian release has MariaDB as default in their repositories. In most cases, you’ll be granting privileges to MySQL users based on the particular database that account should have access to. As today, Debian Buster is the latest release available for the Debian operating systems. ![]() Let’s download and install mysql repository set up package on Debian 11 and Debian 10. ![]() There are a wide range of flags and options available to the command, so you may wish to familiarize yourself with what GRANT can actually do by browsing through the official documentation. Step 1: Add MySQL Repository on Debian 11 / Debian 10. The GRANT command is capable of applying a wide variety of privileges, everything from the ability to CREATE tables and databases, read or write FILES, and even SHUTDOWN the server. Now that you are at the mysqlcli prompt, you need only issue the GRANT command with the necessary options to apply the appropriate permissions.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |