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.

Update to MySQL 4.0.12

Discussion in 'General Discussion' started by andyf, Apr 6, 2003.

  1. andyf

    andyf Well-Known Member

    Joined:
    Jan 7, 2002
    Messages:
    246
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK
    Hi,

    Since CPanel updated to MySQL 4 overnight, when our users go into phpMyAdmin, they see a list of all users databases, not just their own - they cannot actually access these other databases, but thats not the point, they can see them and this in itself is a little too much information for them to be seeing.

    Any ideas folks?

    Cheers,
    A.
     
  2. lordkinjo

    lordkinjo Active Member

    Joined:
    Sep 21, 2002
    Messages:
    35
    Likes Received:
    0
    Trophy Points:
    6
    :(
    Hmm I just noticed this also... is there a fix for this?
     
  3. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    322
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    as root user run

    mysql_fix_privilege_tables

    or

    /scripts/fixmysql
     
  4. WeMasterz5

    WeMasterz5 Well-Known Member

    Joined:
    Feb 24, 2003
    Messages:
    361
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Miami
    just do as cpanel added to the WHM News updates


    MySQL 4.x upgrade If you are able to see all the databases on the server from phpMyAdmin after the MySQL 4.x upgrade you should run /scripts/updatenow;/scripts/fixmysql in a root shell as this will fix the mysql privilege table. For more information on this issue please review: http://www.mysql.com/doc/en/Upgrading-from-3.23.html
     
  5. octeto

    octeto Well-Known Member

    Joined:
    Nov 9, 2002
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    And restart mysql :)
     
  6. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    uhmm

    I executed

    # /scripts/updatenow;/scripts/fixmysql

    then restarted mysql ..


    my clients with phpmyadmin are STILL able to
    see all the databases :mad: ....
     
  7. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    38
    I think we should have phpmyadmin 2.4.0 to support the new
    MySQL 4 privileges !!
     
  8. andyf

    andyf Well-Known Member

    Joined:
    Jan 7, 2002
    Messages:
    246
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    UK
    I'd like to point out to those who replied that i posted this before the news in WHM, as our machines are out of the USA timezone, we get the update pre-most others.

    The update suggested in WHM worked on all machines I've run this on so far.
     
  9. nuklehed

    nuklehed Member

    Joined:
    Dec 10, 2002
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I've also run both scripts and our users can still see the list of databases but no tables. The problem is that the user still has the ability to drop a database if they select one. WTF?

    -nuklehed
     
  10. d-woo

    d-woo Well-Known Member

    Joined:
    Aug 9, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
Loading...

Share This Page