It says USER DOES NOT EXIST.
Here is files I have.
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2012 at 08:20 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `eman`
--
CREATE DATABASE `eman` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `eman`;
--
--
-- Table structure for table `leaks`
--
CREATE TABLE IF NOT EXISTS `leaks` (
`PNo` int(30) NOT NULL,
`Product` varchar(200) NOT NULL,
`DDate` varchar(12) NOT NULL,
`MDate` varchar(12) NOT NULL,
`Quantity` int(30) NOT NULL,
`Usern` varchar(100) NOT NULL,
`LeakID` int(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`LeakID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `leaks`
--
INSERT INTO `leaks` (`PNo`, `Product`, `DDate`, `MDate`, `Quantity`, `Usern`, `LeakID`) VALUES
(2, 'Bottle Water 5 ltrs', '06/02/2010', '06/02/2010', 1, '', 1);
--
--
-- Table structure for table `tbl_exp`
--
CREATE TABLE IF NOT EXISTS `tbl_exp` (
`refno` varchar(30) NOT NULL,
`Description` varchar(500) NOT NULL,
`DDate` varchar(12) NOT NULL,
`Reason` varchar(500) NOT NULL,
`Cost` int(30) NOT NULL,
`Remark` varchar(500) NOT NULL,
`ExpID` int(20) NOT NULL AUTO_INCREMENT,
`usern` varchar(20) NOT NULL,
PRIMARY KEY (`ExpID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_exp`
--
INSERT INTO `tbl_exp` (`refno`, `Description`, `DDate`, `Reason`, `Cost`, `Remark`, `ExpID`, `usern`) VALUES
('1', 'NEPA', '06/08/2010', 'For NEPA', 5000, 'Just a part payment for June', 1, '');
--
--
-- Table structure for table `tbl_pack`
--
CREATE TABLE IF NOT EXISTS `tbl_pack` (
`PackId` int(200) NOT NULL AUTO_INCREMENT,
`Pack` varchar(200) NOT NULL,
`PiecePack` int(200) NOT NULL,
`PricePiece` int(200) NOT NULL,
`PricePack` int(200) NOT NULL,
PRIMARY KEY (`PackId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_pack`
--
INSERT INTO `tbl_pack` (`PackId`, `Pack`, `PiecePack`, `PricePiece`, `PricePack`) VALUES
(1, 'Bottle Water 5 ltrs', 12, 100, 1200);
--
--
-- Table structure for table `tbl_rawmat`
--
CREATE TABLE IF NOT EXISTS `tbl_rawmat` (
`RawMatId` int(200) NOT NULL AUTO_INCREMENT,
`RefNo` varchar(200) NOT NULL,
`MType` varchar(200) NOT NULL,
`Quantity` int(200) NOT NULL,
`Meas` varchar(20) NOT NULL,
`Amount` int(200) NOT NULL,
`DDate` varchar(12) NOT NULL,
PRIMARY KEY (`RawMatId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_rawmat`
--
INSERT INTO `tbl_rawmat` (`RawMatId`, `RefNo`, `MType`, `Quantity`, `Meas`, `Amount`, `DDate`) VALUES
(1, 'hdhd', 'Polythene', 23, 'Pieces', 2400, '06/02/2010');
--
--
-- Table structure for table `tbl_sales`
--
CREATE TABLE IF NOT EXISTS `tbl_sales` (
`SalesID` int(30) NOT NULL AUTO_INCREMENT,
`refno` varchar(200) NOT NULL,
`Product` varchar(200) NOT NULL,
`Price` int(30) NOT NULL,
`DDate` varchar(12) NOT NULL,
`Amount` int(30) NOT NULL,
`Quantity` int(30) NOT NULL,
`usern` varchar(100) NOT NULL,
`Meas` varchar(12) NOT NULL,
PRIMARY KEY (`SalesID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_sales`
--
INSERT INTO `tbl_sales` (`SalesID`, `refno`, `Product`, `Price`, `DDate`, `Amount`, `Quantity`, `usern`, `Meas`) VALUES
(1, '1', 'Bottle Water 5 ltrs', 100, '06/09/2010', 100, 1, '', 'Pieces'),
(3, '2', 'Bottle Water 5 ltrs', 100, '02/20/2012', 1200, 12, '', 'Pieces');
--
--
-- Table structure for table `tbl_stock`
--
CREATE TABLE IF NOT EXISTS `tbl_stock` (
`StockID` int(200) NOT NULL AUTO_INCREMENT,
`Product` varchar(200) NOT NULL,
`DDate` varchar(12) NOT NULL,
`Quantity` int(200) NOT NULL,
`PNo` int(200) NOT NULL,
`Meas` varchar(20) NOT NULL,
PRIMARY KEY (`StockID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_stock`
--
INSERT INTO `tbl_stock` (`StockID`, `Product`, `DDate`, `Quantity`, `PNo`, `Meas`) VALUES
(3, 'Bottle Water 5 ltrs', '06/09/2010', 24, 3, 'Pieces'),
(1, 'Bottle Water 5 ltrs', '06/05/2010', 12, 1, 'Packs'),
(2, 'Bottle Water 5 ltrs', '06/02/2010', 2, 2, 'Packs');
--
--
-- Table structure for table `tbl_user`
--
CREATE TABLE IF NOT EXISTS `tbl_user` (
`userID` int(30) NOT NULL AUTO_INCREMENT,
`uname` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`pword` varchar(200) NOT NULL,
`Telephone` varchar(20) NOT NULL,
`roles` varchar(20) NOT NULL,
PRIMARY KEY (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_user`
--
INSERT INTO `tbl_user` (`userID`, `uname`, `name`, `pword`, `Telephone`, `roles`) VALUES
(1, 'segun', 'Akinyemi Olusegun', 'samson', '08066405654', 'Admin'),
(2, 'dada', 'Dada Edusetan', 'admin', '09087644556', 'User');
As I understand I need to go yo mysql admin and import this dump file, which will create eman database with all needed information. than I have to use information in database to login.