manajemen pengguna

User management is the process of controlling which users are allowed to connect to the MySQL server and what permissions they have on each database. phpMyAdmin does not handle user management, rather it passes the username and password on to MySQL, which then determines whether a user is permitted to perform a particular action. Within phpMyAdmin, administrators have full control over creating users, viewing and editing privileges for existing users, and removing users.

Within phpMyAdmin, user management is controlled via the User accounts tab from the main page. Users can be created, edited, and removed.

Menciptakan pengguna baru

To create a new user, click the Add user account link near the bottom of the User accounts page (you must be a "superuser", e.g., user "root"). Use the textboxes and drop-downs to configure the user to your particular needs. You can then select whether to create a database for that user and grant specific global privileges. Once you've created the user (by clicking Go), you can define that user's permissions on a specific database (don't grant global privileges in that case). In general, users do not need any global privileges (other than USAGE), only permissions for their specific database.

Mensunting pengguna yang sudah ada

To edit an existing user, simply click the pencil icon to the right of that user in the User accounts page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.

Menghapus pengguna

From the User accounts page, check the checkbox for the user you wish to remove, select whether or not to also remove any databases of the same name (if they exist), and click Go.

Memberikan akses ke penguna untuk sebuah database khusus

Users are assigned to databases by editing the user record (from the User accounts link on the home page). If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.

Menu- menu dan grup- grup pengguna yang dapat dikonfigurasikan

By enabling $cfg['Servers'][$i]['users'] and $cfg['Servers'][$i]['usergroups'] you can customize what users will see in the phpMyAdmin navigation.


This feature only limits what a user sees, they are still able to use all the functions. So this can not be considered as a security limitation. Should you want to limit what users can do, use MySQL privileges to achieve that.

Dengan fitur ini diaktifkan, label gui: Antarmuka manajemen 'Akun pengguna' mendapatkan sebuah tab kedua untuk mengelola :label gui: 'Grup pengguna', di mana Anda dapat mengatur apa yang akan dilihat oleh setiap grup (lihat gambar di bawah) dan kemudian Anda dapat menempatkan setiap pengguna ke salah satu grup ini. Pengguna akan mempresentasikan dengan sebuah antarmuka simpel, yang mungkin akan berguna untuk pengguna tidak berpengalaman yang bisa kesulitan dengan semua fitur phpMyAdmin sediakan.