Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New Coder
    Join Date
    May 2006
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How do i see my DB in phpmyadmin

    Right i use cpanel, and im just wondering where do i save my DB to, and then how do i see it in phpmyadmin....

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    you don't choose where to save your database, phpmyadmin will save it for you in the data directory of where you have mysql installed.

    you will select your databases using the pulldown on the left side of phpmyadmin.

  • #3
    New Coder
    Join Date
    May 2006
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by guelphdad
    you don't choose where to save your database, phpmyadmin will save it for you in the data directory of where you have mysql installed.

    you will select your databases using the pulldown on the left side of phpmyadmin.
    I dont have mysql installed i'm doing it all on the web....
    All i've really done is save my DB to my system. then in 'cpanel' added it in "backups"'.

  • #4
    New Coder
    Join Date
    May 2006
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts
    And that's the main problem there isent a database to chose from "no databses"

    And when i do try to create table

    "create databasedisaster_underwor"

    i get:

    #1044 - Access denied for user 'disaster'@'localhost' to database 'disaster_underwor'

    what would it be im doing wrong. im preety dumb in mysql....
    Last edited by johay; 08-30-2006 at 06:07 PM.

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    well you'd have to have mysql installed or you wouldn't be using phpmyadmin which relies on having mysql or sqllite installed.

    maybe you don't have permissions to create a database. have you tried creating a table?

  • #6
    New Coder
    Join Date
    May 2006
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Nope, im all so new to mysql. i have a database made i just need to add it but i dont know how....

    here's the DB i made

    Code:
    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Feb 06, 2006 at 04:58 PM
    -- Server version: 4.0.25
    -- PHP Version: 4.3.11
    -- 
    -- Database: `disaster_underwor`
    -- 
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `NEWcities`
    -- 
    
    CREATE TABLE `NEWcities` (
      `cityid` smallint(6) unsigned NOT NULL auto_increment,
      `name` varchar(20) NOT NULL default '',
      `location` varchar(20) NOT NULL default '',
      `traincost` int(10) unsigned NOT NULL default '1000',
      `planecost` int(10) unsigned NOT NULL default '5000',
      `bfstock` smallint(5) unsigned NOT NULL default '5000',
      `bfprice` smallint(5) unsigned NOT NULL default '100',
      `bfowner` varchar(20) NOT NULL default '',
      `bfproduce` int(11) unsigned NOT NULL default '0',
      `bfactive` tinyint(1) unsigned NOT NULL default '0',
      `bfsellprice` int(10) unsigned NOT NULL default '0',
      `rtowner` varchar(20) NOT NULL default 'State',
      `rtmaxbet` int(7) unsigned NOT NULL default '100',
      `rtofferprice` int(7) unsigned NOT NULL default '0',
      `rtprofit` int(13) NOT NULL default '0',
      `rtloss` int(13) NOT NULL default '0',
      `bjowner` varchar(20) NOT NULL default 'State',
      `bjmaxbet` int(7) unsigned NOT NULL default '0',
      `bjofferprice` int(7) unsigned NOT NULL default '0',
      `roowner` varchar(20) NOT NULL default 'State',
      `romaxbet` int(7) unsigned NOT NULL default '0',
      `roofferprice` int(7) unsigned NOT NULL default '0',
      `kowner` varchar(20) NOT NULL default 'State',
      `kmaxbet` int(7) unsigned NOT NULL default '100',
      `kofferprice` int(7) unsigned NOT NULL default '0',
      `drugprices` text NOT NULL,
      `yzowner` varchar(20) NOT NULL default 'State',
      `yzmaxbet` int(10) unsigned NOT NULL default '100',
      `yzofferprice` int(10) unsigned NOT NULL default '0',
      PRIMARY KEY  (`cityid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `NEWcities`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `NEWgangreplies`
    -- 
    
    CREATE TABLE `NEWgangreplies` (
      `threadid` mediumint(8) unsigned NOT NULL auto_increment,
      `topicid` mediumint(8) unsigned NOT NULL default '0',
      `creator` varchar(20) NOT NULL default '',
      `message` text NOT NULL,
      `dtposted` datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (`threadid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `NEWgangreplies`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `NEWgangtopics`
    -- 
    
    CREATE TABLE `NEWgangtopics` (
      `topicid` mediumint(8) unsigned NOT NULL auto_increment,
      `title` varchar(40) NOT NULL default '',
      `message` text NOT NULL,
      `dtmade` datetime NOT NULL default '0000-00-00 00:00:00',
      `creator` varchar(20) NOT NULL default '',
      `replycount` smallint(5) unsigned NOT NULL default '0',
      `lastreply` datetime NOT NULL default '0000-00-00 00:00:00',
      `locked` tinyint(1) NOT NULL default '0',
      `sticky` tinyint(1) NOT NULL default '0',
      `important` tinyint(1) NOT NULL default '0',
      `normal` tinyint(1) NOT NULL default '1',
      PRIMARY KEY  (`topicid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `NEWgangtopics`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `News`
    -- 
    
    CREATE TABLE `News` (
      `newsid` tinyint(5) NOT NULL auto_increment,
      `poster` varchar(150) NOT NULL default '',
      `title` varchar(250) NOT NULL default '',
      `news` text NOT NULL,
      `posted` datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (`newsid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `News`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `Ticker`
    -- 
    
    CREATE TABLE `Ticker` (
      `newsid` tinyint(5) NOT NULL auto_increment,
      `news` text NOT NULL,
      `dt` datetime NOT NULL default '0000-00-00 00:00:00',
      `tos` text NOT NULL,
      PRIMARY KEY  (`newsid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `Ticker`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `activation`
    -- 
    
    CREATE TABLE `activation` (
      `username` varchar(20) NOT NULL default '',
      `code` varchar(64) NOT NULL default '',
      `expires` int(11) NOT NULL default '0',
      KEY `username` (`username`,`code`),
      KEY `code` (`code`)
    ) TYPE=MyISAM;
    
    -- 
    -- Dumping data for table `activation`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `adrec`
    -- 
    
    CREATE TABLE `adrec` (
      `adrecid` mediumint(8) unsigned NOT NULL auto_increment,
      `userid` mediumint(8) unsigned NOT NULL default '0',
      `event` varchar(20) NOT NULL default '',
      `ipaddress` varchar(15) NOT NULL default '',
      `dt` datetime NOT NULL default '0000-00-00 00:00:00',
      `safe` tinyint(1) unsigned NOT NULL default '0',
      `pldata` text NOT NULL,
      PRIMARY KEY  (`adrecid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `adrec`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `airport`
    -- 
    
    CREATE TABLE `airport` (
      `id` int(11) NOT NULL auto_increment,
      `owner` varchar(40) NOT NULL default '',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      `travel_prices` varchar(100) NOT NULL default '100-100-100-100-100-100',
      `profit` varchar(100) NOT NULL default '0-0-0-0-0-0',
      PRIMARY KEY  (`id`),
      KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `airport`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `attempts`
    -- 
    
    CREATE TABLE `attempts` (
      `id` int(11) NOT NULL auto_increment,
      `username` char(40) NOT NULL default '',
      `target` char(40) NOT NULL default '',
      `outcome` enum('Dead','Survived') NOT NULL default 'Dead',
      `date` datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `attempts`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `auctions`
    -- 
    
    CREATE TABLE `auctions` (
      `id` int(11) NOT NULL auto_increment,
      `username` varchar(40) NOT NULL default '',
      `min_starting` int(11) NOT NULL default '0',
      `current_bid` int(11) NOT NULL default '0',
      `winning` varchar(40) NOT NULL default '',
      `winning_bid` int(11) NOT NULL default '0',
      `item_type` varchar(100) NOT NULL default '',
      `time` varchar(100) NOT NULL default '',
      `item_id` varchar(100) NOT NULL default '',
      `an` enum('0','1') NOT NULL default '0',
      `pvt` enum('0','1') NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `auctions`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `ban`
    -- 
    
    CREATE TABLE `ban` (
      `id` int(11) NOT NULL auto_increment,
      `username` varchar(40) NOT NULL default '',
      `by` varchar(40) NOT NULL default '',
      `type` enum('0','1') NOT NULL default '0',
      `reason` text NOT NULL,
      `length` varchar(100) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `ban`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bank`
    -- 
    
    CREATE TABLE `bank` (
      `id` int(11) NOT NULL auto_increment,
      `owner` varchar(40) NOT NULL default '',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      `send_interest` int(11) NOT NULL default '0',
      `profit` int(100) NOT NULL default '0',
      PRIMARY KEY  (`id`),
      KEY `id` (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bank`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bar`
    -- 
    
    CREATE TABLE `bar` (
      `id` int(11) NOT NULL auto_increment,
      `owner` char(40) NOT NULL default '',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      `profit` int(50) NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bar`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bf`
    -- 
    
    CREATE TABLE `bf` (
      `id` int(11) NOT NULL auto_increment,
      `owner` varchar(40) NOT NULL default '0',
      `stock` int(100) NOT NULL default '0',
      `producing` enum('Yes','No') NOT NULL default 'Yes',
      `price` int(100) NOT NULL default '100',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      `profit` varchar(100) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bf`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bgarage`
    -- 
    
    CREATE TABLE `bgarage` (
      `id` int(11) NOT NULL auto_increment,
      `owner` varchar(40) NOT NULL default '',
      `boat` varchar(100) NOT NULL default '',
      `damage` varchar(100) NOT NULL default '',
      `origion` varchar(100) NOT NULL default '',
      `location` varchar(100) NOT NULL default '',
      `upgrades` varchar(100) NOT NULL default '0-0-0-0-0-0-0-0',
      `status` enum('0','1','2','3','4') NOT NULL default '0',
      `worth` int(32) NOT NULL default '0',
      `shiptime` varchar(100) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bgarage`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bidders`
    -- 
    
    CREATE TABLE `bidders` (
      `id` int(11) NOT NULL auto_increment,
      `bidder` char(40) NOT NULL default '',
      `amount` int(11) NOT NULL default '0',
      `auction_id` int(11) NOT NULL default '0',
      `time` datetime NOT NULL default '0000-00-00 00:00:00',
      `an` enum('0','1') NOT NULL default '0',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bidders`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `bj`
    -- 
    
    CREATE TABLE `bj` (
      `gameid` int(11) NOT NULL auto_increment,
      `card1` char(3) NOT NULL default '',
      `card2` char(3) NOT NULL default '',
      `card3` char(3) NOT NULL default '',
      `card4` char(3) NOT NULL default '',
      `card5` char(3) NOT NULL default '',
      `date` datetime NOT NULL default '0000-00-00 00:00:00',
      `bet` bigint(20) NOT NULL default '0',
      `winlose` tinyint(4) NOT NULL default '0',
      `dealer1` char(3) NOT NULL default '',
      `dealer2` char(3) NOT NULL default '',
      `dealer3` char(3) NOT NULL default '',
      `dealer4` char(3) NOT NULL default '',
      `dealer5` char(3) NOT NULL default '',
      `uid` int(11) NOT NULL default '0',
      PRIMARY KEY  (`gameid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `bj`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `boat_sell`
    -- 
    
    CREATE TABLE `boat_sell` (
      `id` int(11) NOT NULL auto_increment,
      `owner` char(40) NOT NULL default '',
      `boat_id` int(50) NOT NULL default '0',
      `price` int(50) NOT NULL default '0',
      `date` datetime NOT NULL default '0000-00-00 00:00:00',
      `boat_type` char(40) NOT NULL default '',
      `location` enum('England','Japan','Colombia','Usa','South Africa','Mexico') NOT NULL default 'England',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `boat_sell`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `car_sell`
    -- 
    
    CREATE TABLE `car_sell` (
      `id` int(11) NOT NULL auto_increment,
      `owner` char(40) NOT NULL default '',
      `car_id` int(50) NOT NULL default '0',
      `price` int(50) NOT NULL default '0',
      `date` datetime NOT NULL default '0000-00-00 00:00:00',
      `car_type` char(40) NOT NULL default '',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `car_sell`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `casinos`
    -- 
    
    CREATE TABLE `casinos` (
      `id` int(11) NOT NULL auto_increment,
      `owner` varchar(40) NOT NULL default '0',
      `casino` enum('Slots','Roulette','RPS','Race') NOT NULL default 'Slots',
      `profit` varchar(100) NOT NULL default '',
      `max` int(11) NOT NULL default '0',
      `location` enum('England','Japan','France','Usa','China','Canada') NOT NULL default 'England',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `casinos`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `chat`
    -- 
    
    CREATE TABLE `chat` (
      `id` int(32) NOT NULL auto_increment,
      `user` varchar(100) NOT NULL default '',
      `chat` varchar(100) NOT NULL default '',
      `timeh` varchar(20) NOT NULL default '',
      `timem` varchar(20) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `chat`
    -- 
    
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `cities`
    -- 
    
    CREATE TABLE `cities` (
      `cityid` smallint(6) unsigned NOT NULL auto_increment,
      `name` varchar(20) NOT NULL default '',
      `location` varchar(20) NOT NULL default '',
      `traincost` int(10) unsigned NOT NULL default '1000',
      `planecost` int(10) unsigned NOT NULL default '5000',
      `bfstock` smallint(4) unsigned NOT NULL default '1500',
      `bfprice` int(15) unsigned NOT NULL default '100',
      `bfowner` varchar(20) NOT NULL default '',
      `bfproduce` int(11) unsigned NOT NULL default '0',
      `bfactive` tinyint(1) unsigned NOT NULL default '0',
      `bfsellprice` int(10) unsigned NOT NULL default '0',
      `rtowner` varchar(20) NOT NULL default 'State',
      `rtmaxbet` int(7) unsigned NOT NULL default '100',
      `rtofferprice` int(7) unsigned NOT NULL default '250000',
      `rtprofit` int(13) NOT NULL default '0',
      `rtloss` int(13) NOT NULL default '0',
      `bjowner` varchar(20) NOT NULL default 'State',
      `bjmaxbet` int(7) unsigned NOT NULL default '0',
      `bjofferprice` int(7) unsigned NOT NULL default '0',
      `bjprofit` int(48) unsigned NOT NULL default '0',
      `bjloss` int(48) unsigned NOT NULL default '0',
      `roowner` varchar(20) NOT NULL default 'State',
      `romaxbet` bigint(20) unsigned NOT NULL default '100',
      `roofferprice` int(7) unsigned NOT NULL default '0',
      `roloss` int(32) unsigned NOT NULL default '0',
      `roprofit` int(32) unsigned NOT NULL default '0',
      `kowner` varchar(20) NOT NULL default 'State',
      `kmaxbet` int(7) unsigned NOT NULL default '100',
      `kofferprice` int(7) unsigned NOT NULL default '0',
      `drugprices` text NOT NULL,
      `yzowner` varchar(20) NOT NULL default 'State',
      `yzmaxbet` int(10) unsigned NOT NULL default '100',
      `yzofferprice` int(10) unsigned NOT NULL default '0',
      `yzprofit` bigint(20) NOT NULL default '0',
      `yzloss` bigint(20) NOT NULL default '0',
      `slowner` varchar(20) NOT NULL default 'State',
      `slmaxbet` int(10) unsigned NOT NULL default '100',
      `slofferprice` int(10) unsigned NOT NULL default '15000000',
      `slprofit` bigint(20) NOT NULL default '0',
      `slloss` bigint(20) NOT NULL default '0',
      `powner` varchar(20) NOT NULL default 'State',
      `pmaxbet` int(10) unsigned NOT NULL default '100',
      `pofferprice` int(20) unsigned NOT NULL default '2000000',
      `pprofit` bigint(20) NOT NULL default '0',
      `ploss` bigint(20) NOT NULL default '0',
      PRIMARY KEY  (`cityid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `cities`
    -- 
    
    
    -- --------------------------------------------------------
    Thats just some of it...

  • #7
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    You might want to talk to your host if you don't have permission to create a database. Or also look in cPanel if there is a place to create a mysql database. I know under Plesk, I create the database and db users through it, then I can use phpMyAdmin. But that is just an example of how my host has it setup.
    OracleGuy


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •