The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpmyadmin show all db

Discussion in 'Database Discussions' started by islam, Oct 21, 2004.

  1. islam

    islam Registered

    Joined:
    Dec 12, 2001
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    my phpmyadmin show all dbs to all users with access to there dbs only...


    i try

    /scripts/updatenow
    /scrripts/fixmysql


    try /usr/bin/fix_mysql_t

    and restart mysql many times ... every thing was running great before the cpanel update to this phpmyadmin version


    php myadmin 2.6.0

    mysql 3.23.56


    WHM 9.9.0 cPanel 9.9.2-S8
    RedHat 8.0 i686 - WHM X v3.1.0
     
  2. paolorulez

    paolorulez Guest

    reset your root password in WHM:)


    in ssh

    root@host root]# mysql
    Welcome to the MySQL monitor. Commands end with ; or g.
    Your MySQL connection id is 1 to server version: 3.23.41

    Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

    mysql> USE mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed
    mysql> UPDATE user
    -> SET password=password(newpassword)
    -> WHERE user=root;
    Query OK, 2 rows affected (0.04 sec)
    Rows matched: 2 Changed: 2 Warnings: 0

    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)

    mysql> exit;
     
    #2 paolorulez, Oct 21, 2004
    Last edited by a moderator: Oct 21, 2004
  3. islam

    islam Registered

    Joined:
    Dec 12, 2001
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    didnt fix the problem still..........
     
  4. paolorulez

    paolorulez Guest

    try

    pico .my.cnf

    remove the quote if exist ="xx" to =xx

    mysql> flush privileges;
    restart mysql
     
  5. maxbia

    maxbia Active Member

    Joined:
    Feb 11, 2003
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
Loading...

Share This Page