Closed Thread
Results 1 to 1 of 1

Thread: phpMyAdmin does not show databases

  1. #1
    ysptheband22 is offline x10Hosting Member ysptheband22 is an unknown quantity at this point
    Join Date
    Jan 2011
    Posts
    2

    phpMyAdmin does not show databases

    Well, the title says it all: even though I have given a MySQL user full privileges to my database, it won't show up in phpMyAdmin. Also, in scripts, the command mysql_select_db won't work, and when I try "SHOW TABLES FROM `*database name*`" in the SQL window at phpMyAdmin, it gives an acces denied message, even though I'm fully privileged for that database.

    Server: https://boru.x10hosting.com:2083/3rdparty/phpMyAdmin/
    User: ysptemp_root, database: ysptemp_db. It also happens at any other user or database I create.

    Additional information (as in phpMyAdmin):
    cpsrvd 11.28.87
    MySQL-client version: 5.0.92
    PHP extension: mysql

    ---------- Post added at 05:17 PM ---------- Previous post was at 11:31 AM ----------

    Oops, sorry folks, I made some mistakes in my past post, and also discovered some other oddities.

    Through scripts in public_html, everything works flawless; I can acces all databases.

    However, phpMyAdmin screws everything up. It informs me that there are 'no databases', and the SQL query "SHOW TABLES IN `table_name`" redirects me to the main pMA screen. I don't really need pMA, except for importing the database on my local testing server. So, my question comes down to two things:
    -Can someone please fix pMA on the boru server?
    -How to import SQL files without pMA?
    Last edited by ysptheband22; 04-22-2011 at 10:19 AM.

Closed Thread

Similar Threads

  1. SHOW DATABASES very slow on chopin
    By warrenhR in forum Free Hosting
    Replies: 3
    Last Post: 11-26-2010, 09:18 PM
  2. Databases working but do not show up
    By Adam! in forum Free Hosting
    Replies: 0
    Last Post: 10-25-2010, 10:44 AM
  3. [HELP] PHPmyadmin - databases
    By Premhtl in forum Free Hosting
    Replies: 1
    Last Post: 04-13-2008, 04:13 AM
  4. Accessing my databases and phpmyadmin
    By Dark1234 in forum Free Hosting
    Replies: 3
    Last Post: 01-03-2008, 06:39 PM
  5. Databases gone/ no phpmyadmin
    By AZOVGY in forum Free Hosting
    Replies: 18
    Last Post: 11-15-2007, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers