Become a Site Supporter and Never see Ads again!

Author Topic: TSKB: PHPmyAdmin login help  (Read 2889 times)

0 Members and 1 Guest are viewing this topic.

Offline Fatah Ruark (aka MIKE B)

  • Trade Count: (11)
  • Needs to get out more...
  • *****
  • Posts: 9940
  • Gender: Male
  • I dream in beige.
    • sloppy.art.ink
TSKB: PHPmyAdmin login help
« on: June 15, 2009, 01:36:47 PM »
So I'm trying to build a server with Ubuntu, LAMP and Drupal. I've got LAMP and Drupal installed and working (somewhat).

I need to upgrade Drupal and would like to backup the database (even though I probably don't need to).

I am trying to login to phpmyadmin via my browser and I use the default user name (root) and password (which is blank). When I do this it says "access is denied"

I've read up on how to fix this and most of the answers I've found are pretty vague or assume I have a lot more knowledge than I actually have.

From what I've read it seems I need to edit the config.inc.php file, but can't really figure out where to change what I need to change.

Anyone have any idea how to fix this?

Here is what the file looks like now:

Quote
<?php
/**
 * Debian local configuration file
 *
 * This file overrides the settings made by phpMyAdmin interactive setup
 * utility.
 *
 * For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz
 *
 * NOTE: do not add security sensitive data to this file (like passwords)
 * unless you really know what you're doing. If you do, any user that can
 * run PHP or CGI on your webserver will be able to read them. If you still
 * want to do this, make sure to properly secure the access to this file
 * (also on the filesystem level).
 */

/**
 * Server(s) configuration
 */
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;

/* Read configuration from dbconfig-common */
require('/etc/phpmyadmin/config-db.php');

/* Configure according to dbconfig-common if enabled */
if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'config';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = 'localhost/';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport)) {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    }
    //$cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    /* Optional: User for advanced features */




    $cfg['Servers'][$i]['controluser'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    $cfg['Servers'][$i]['relation'] = 'pma_relation';
    $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    $cfg['Servers'][$i]['history'] = 'pma_history';
    $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

    /* Advance to next server for rest of config */
    $i++;
}

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost/';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
//$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
//$cfg['Servers'][$i]['extension'] = 'mysql';
/* Optional: User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Optional: Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

||| MICS:  Beyer CK930 | DPA 4022 | DPA 4080 | Nevaton MCE400 | Sennheiser Ambeo Headset |||
||| PREAMPS: DPA d:vice | Naiant Tinybox | Naiant IPA |||
||| DECKS: Sound Devices MixPre6 | iPod Touch 32GB |||
|||Concert History || LMA Recordings || Live YouTube |||

Online Sebastian

  • Trade Count: (4)
  • Taperssection All-Star
  • ****
  • Posts: 1588
  • Gender: Male
Re: TSKB: PHPmyAdmin login help
« Reply #1 on: June 15, 2009, 03:31:13 PM »
MySQL has its own password database (it's actually a database called "mysql" IIRC). Here's some documentation on how to set up MySQL:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

Offline phanophish

  • Trade Count: (2)
  • Needs to get out more...
  • *****
  • Posts: 2128
  • Gender: Male
    • ImageLume Photography
Re: TSKB: PHPmyAdmin login help
« Reply #2 on: June 18, 2009, 03:01:44 PM »
You are also scaring me with a blank root password......
______________________________________________
Audio: MBHO 603/KA200N or AKG C2000B>Edirol R44
http://www.archive.org/bookmarks/phanophish

Photo:  Nikon D300, D200, 35mm f/1.8,  50mm f/1.4, 85mm f/1.8, Nikon 17-55 f/2.8, Sigma 18-50/2.8 Macro, 18-70 f/4.5-5.6, 24-120 f/3.5-5.6 VR, Sigma 10-20 f4-5.6, Nikon 70-200 f/2.8VR, SB-800

Jake: What's this?
Elwood: What?
Jake: This car. This stupid car. Where's the Cadillac? The Caddy? Where's the Caddy?
Elwood: The what?
Jake: The Cadillac we used to have. The Blues Mobile!
Elwood: I traded it.
Jake: You traded the Blues Mobile for this?
Elwood: No. For a microphone.
Jake: A microphone? Okay I can see that.

Offline crazifyngers

  • Trade Count: (13)
  • Taperssection Member
  • ***
  • Posts: 340
  • Gender: Male
Re: TSKB: PHPmyAdmin login help
« Reply #3 on: June 19, 2009, 05:01:12 PM »
^^ first thing i though
Gotta love the rat-tail Jerry has; it's where his power comes from!

runonce

  • Guest
  • Trade Count: (0)
Re: TSKB: PHPmyAdmin login help
« Reply #4 on: August 13, 2009, 10:24:16 PM »
Ubuntu Server Editon or Desktop?

IIRC - If you install PhpMyAdmin from the Synaptic Package manager - it will prompt you to create a user/password...

 

RSS | Mobile
Page created in 0.052 seconds with 31 queries.
© 2002-2024 Taperssection.com
Powered by SMF