Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

User ``@`localhost`

 User accounts overview

A user account allowing any user from localhost to connect is present. This will prevent other users from connecting if the host part of their account allows a connection from any (%) host.Documentation
User name Host name Password Global privileges Note: MySQL privilege names are expressed in English. User group Grant Action
% NoThe selected user was not found in the privilege table. USAGE No Edit privileges Edit privilegesExport Export
localhost No USAGE No Edit privileges Edit privilegesExport Export
% Yes USAGE No Edit privileges Edit privilegesExport Export
localhost NoThe selected user was not found in the privilege table. USAGE No Edit privileges Edit privilegesExport Export
localhost Yes USAGE No Edit privileges Edit privilegesExport Export
localhost Yes USAGE No Edit privileges Edit privilegesExport Export
127.0.0.1 Yes ALL PRIVILEGES Yes Edit privileges Edit privilegesExport Export
::1 Yes ALL PRIVILEGES Yes Edit privileges Edit privilegesExport Export
localhost Yes ALL PRIVILEGES Yes Edit privileges Edit privilegesExport Export
localhost Yes USAGE No Edit privileges Edit privilegesExport Export
% Yes REPLICATION SLAVE, REPLICATION CLIENT No Edit privileges Edit privilegesExport Export
% Yes REPLICATION SLAVE, REPLICATION CLIENT No Edit privileges Edit privilegesExport Export
% Yes REPLICATION SLAVE No Edit privileges Edit privilegesExport Export
With selected: With selected:
New  Add user account
 Remove selected user accounts

(Revoke all active privileges from the users and delete them afterwards.)

Note: phpMyAdmin gets the users’ privileges directly from MySQL’s privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.