Support » Fixing WordPress » Help with MySQL and phpmyadmin please

  • stevomitch

    (@stevomitch)


    I use Fasthost servers in the UK. I am trying access the MySQL database using phpmyadin. Both are running on the same server. When I enter the username and password for the database I get the error message (click link to view):
    http://i38.photobucket.com/albums/e112/smitchell7/Web%20dev/phpmyadmin.png

    The ‘config.inc.php’ file currently uses the code below (actual UN and PW not supplied for security):

    <?php
    
    $i=0;
    $i++;
    $cfg['Servers'][$i]['user']          = 'myname';
    $cfg['Servers'][$i]['password']      = 'passwordhere'; // use here your password
    ?>

    I have also tried (without success):

    <?php
    $i=0;
    $i++;
    $cfg['Servers'][$i]['host']='000.000.000.00'; // your database server's IP address
    $cfg['Servers'][$i]['auth_type']='config'; // Authentication method - config, http or cookie
    $cfg['Servers'][$i]['user']='myname'; // your database username
    $cfg['Servers'][$i]['password']='password'; // your database user's password
    ?>

    Fasthosts don’t support phpmyadmin, so it would be great to get some advice from someone with more experience.

    I wan’t to clear the database so I can start a WordPress blog from scratch, after installing previously for a test run at another location on the server. I now want to start afresh placing the blog in a sub-domain.

    Thanks in anticipation.

Viewing 4 replies - 1 through 4 (of 4 total)
  • whooami

    (@whooami)

    contact your host. or find a phpmyadmin support forum, how abouts???

    MichaelH

    (@michaelh)

    If you do have WordPress installed you might look at this plugin if you don’t get satisfaction from your host:
    http://wordpress.org/extend/plugins/wp-phpmyadmin/

    Please note you can get a ‘new instance’ of WordPress by just using a different $table_prefix in wp-config.php. That assumes you have a running blog with the other information in wp-config.php.

    Saurus

    (@saurus)

    I don’t think I’d be inclined to deal with a host who doesn’t provide sql access via phpMyadmin, but that’s just me. Have you looked at hosting plans from 1and1,com UK?

    Sorry all, but Fasthosts do support phpmyadmin.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Help with MySQL and phpmyadmin please’ is closed to new replies.