phpMyAdmin Access in Webuzo
phpMyAdmin is a web-based tool for managing MySQL databases through a graphical interface.
Accessing phpMyAdmin
Via Webuzo Panel
Databases > phpMyAdmin. Opens in a new tab, auto-logged in.
Direct URL
https://your-server-ip:2004/phpMyAdmin — log in with database credentials.
The Interface
- Left sidebar: Database and table list
- Main panel: Content, settings, and operations for selected items
- Tabs: Structure, SQL, Search, Query, Export, Import, Operations
Common Tasks
Viewing Data: Click database > table > Browse tab. Sort by clicking column headers.
Searching: Select table > Search tab > enter criteria > Go.
Editing Records: Browse table > click Edit (pencil) icon > modify values > Go.
Deleting Records: Click Delete (X) icon > confirm. Cannot be undone.
Running SQL Queries
Select database > SQL tab > enter query:
sql
-- Count records
SELECT COUNT(*) FROM table_name;
-- WordPress: reset admin password
UPDATE wp_users SET user_pass = MD5('NewPassword123!') WHERE user_login = 'admin';
-- WordPress: delete spam comments
DELETE FROM wp_comments WHERE comment_approved = 'spam';Exporting (Backup)
Select database > Export > Quick (default settings) or Custom (choose tables, format, compression) > Go to download.
Importing (Restore)
Select database > Import > choose .sql file > Go. Max upload typically 50-100 MB. For larger files, compress with gzip first or use command line.
Database Administration
Create Table: Select database > enter table name and column count > define columns (name, type, length, default, index) > Save.
Modify Structure: Select table > Structure tab > Change, Drop, or Add columns.
Rename Table: Select table > Operations tab > change table name > Go.
Security
- Never share phpMyAdmin credentials
- Use strong passwords
- Do not run SQL you do not understand
- Always back up before major changes
- Grant only needed privileges to application database users
Related Articles
Need help? Contact our support team at {{SUPPORT_URL}}/client/support.