mysql

[Mysql Basic] Create Database Username Password Tables

Basic Commands of Mysql to create a database, create a table, create a user with password and give privilages to the table. These commands can be used in a Mariadb terminal without modification. Because Mariadb is compatible with Mysql also. Mysql command line is used for managing linux servers in remote hosting. These commands are …

[Mysql Basic] Create Database Username Password TablesRead More »

Slick jQuery Datagrid Plugin – Open JS Grid

Open JS Grid is a slick jQuery Data Grid Plugin with all the features loaded. With simple code you can have a complete data grid with all the essential features. Sorting, Searching, Complex queries etc.. Open JS Grid is complete Open Source Plugin to jQuery. Open JS Grid comes with builtin Bootstrap styling so it …

Slick jQuery Datagrid Plugin – Open JS GridRead More »

WordPress : Add an admin user to database and Reset User Roles

In wordpress when some hacking occures or some illegal activity and want to restore the fuctionality then the default admin user may not work. If the default admin user deleted from the database also then you cannot login into the wp-admin backend of wordpress blog. To solve this problem you must manually add a new …

WordPress : Add an admin user to database and Reset User RolesRead More »

Install LAMP – Apache, PHP, Mysql on Ubuntu 12.04

The LAMP stands for Linux, Apache, Mysql, PHP or Pearl etc.. Installing the LAMP Server in Ubuntu 12.04 is very easy now. Just run one or two commands on sudo mode will solve the problem. With PHP you probably need some additional packages to manage your web applicaiton. Some libraries like mcrypt, mbstring, gd, imagemagic,curl …

Install LAMP – Apache, PHP, Mysql on Ubuntu 12.04Read More »

Installing Apache Mysql PHP in Ubuntu 11.10

LAMP [Linux,Apache,Mysql,PHP] is the most winning combination in today s growning internet to develop dynamic PHP applications. The linux part is replaced by any linux distro like Ubuntu 11.10, Fedora 15, Opensuse 12.1, Debian etc… Linux is the most fast and safest platform to develop PHP applications for todays web. How to install an Apache2 …

Installing Apache Mysql PHP in Ubuntu 11.10Read More »

Web Based Mysql Administration Tool – Chive Released

Now a days phpmyadmin is using widly for managing mysql databases in almost all hosting environments.Think of an alternative ? Chive is an alternative tool for PhpMyadmin, it is a webbased MySQL database management tool. The web-based user interface supports most of the common operations needed by software developers and database admins in MySQL(databases, tables, …

Web Based Mysql Administration Tool – Chive ReleasedRead More »

MySQL Change root Password

Setting up mysql password is one of the essential tasks. By default root user is MySQL admin account. Please note that the Linux / UNIX login root account for your operating system and MySQL root are different. They are separate and nothing to do with each other (indeed some admin removes root account and setup …

MySQL Change root PasswordRead More »