Adminer – Database management in a single PHP file
Sponsored Link
Features
Connect to a database server with username and password
Select an existing database or create a new one
List fields, indexes, foreign keys and triggers of table
Change name, engine, collation, auto_increment and comment of table
Alter name, type, collation, comment and default values of columns
Add and drop tables and columns
Create, alter, drop and search by indexes including fulltext
Create, alter, drop and link lists by foreign keys
Create, alter, drop and select from views
Create, alter, drop and call stored procedures and functions
Create, alter and drop triggers
List data in tables with search, aggregate, sort and limit results
Insert new records, update and delete the existing ones
Supports all data types, blobs through file transfer
Execute any SQL command from a text field or a file
Export table structure, data, views, routines, databases to SQL or CSV
Print database schema connected by foreign keys
Show processes and kill them
Display users and rights and change them
Display variables with links to documentation
Manage events and table partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
Extensive customization options
Why is Adminer better than phpMyAdmin?
phpMyAdmin is one of the most famous tools for managing the MySQL database. However, it is not perfect which is the reason why Adminer has been created. In which areas is Adminer a better alternative to replace phpMyAdmin? The list is quite long and some points may be insignificant for you. The most important differences are:
User experience
Supported MySQL features
Performance
Security
Install adminer in ubuntu server
Open the terminal and run the following commands
sudo apt-get install adminer
After the installation you need to restart your webserver using the following command
sudo service apache2 restart
Using Adminer
You can access adminer using http://mysqlserverip/adminer
Screenshots
Thanks a lot! But i cant import a mssql db?
I been so stupid to install Nginx and i can’t fine a way to make it work so i can access it trough my website as i have no idea how i should create a symlink to the excisting configuration so if anyone can help me i will appreciate thanks