MySql Lite Administrator

MySql Lite Administrator is a php web application that will help you insert and update stuff in your MySQL Database.

MySql is probably the most used database for web application. There are many web tools that interact with MySQL, PHPMyAdmin is a great example. But the problem is they are very complex for non expert user. That is why I decided to create user friendly web application for basic management of MySQL.

How to use this application?

Just copy files on your server were is your MySQL database placed.

Go to index.php and login with your database username and password.

How this application works?

For now you can do Insert and Update, inserting can be done only in tables with primary key(auto generated progressive number or GUID).

I also use TinyMCE and table sorter (jquery plugin) for better user experience.

Security considerations

Change your folder name

Don’t link directly to the application from your web site (we want to be hidden from search engines)

Change the $key value inside cookie.php and setcookie.php

Don’t give root access to your client. Make new profile with only select, insert and update. You may also limit access to some database tables.

This application uses HTML Purifier for preventing xss attacks and cleaning HTML code , the cookies are encrypted with MCRYPT_RIJNDAEL_256 and MCRYPT_RIJNDAEL_128 algorithm also all the pages have “Do not follow” for the search engines.

For more info see: http://code.google.com/p/mysql-lite-administrator/