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.

Fixmysql runs on every upgrade

Discussion in 'General Discussion' started by sexy_guy, Apr 8, 2003.

  1. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Everytime i got to do an upgrade now i get this;

    This scripts updates the mysql.user, mysql.db, mysql.host and the
    mysql.func tables to MySQL 3.22.14 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

    If you get 'Access denied' errors, you should run this script again
    and give the MySQL root user password as an argument!
    Converting all privilege tables to MyISAM format

    If your tables are already up to date or partially up to date you will
    get some warnings about 'Duplicated column name'. You can safely ignore these!

    Creating Grant Alter and Index privileges if they don't exists
    You can ignore any Duplicate column errors

    Setting default privileges for the new grant, index and alter privileges

    Adding columns needed by GRANT .. REQUIRE (openssl)
    You can ignore any Duplicate column errors

    Creating the new table and column privilege tables
    Changing name of columns_priv.Type -> columns_priv.Column_priv
    You can ignore any Unknown column errors from this

    Fixing the func table
    You can ignore any Duplicate column errors

    Adding new fields used by MySQL 4.0.2 to the privilege tables
    You can ignore any Duplicate column errors

    Updating new privileges in MySQL 4.0.2 from old ones

    Is it necessarry to have the update run fixmysql everytime? Im just worried that it will screw up my databases. Can this be turned off? If so how?
     
  2. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Thats not good, some of use have optimized our version of MySQL and its unecessary for fixmysql to run. The script should be doing a check not a force fix on every update.
     
  3. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    *bump* still appears every night. Can we have this turned off?
     
  4. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    ** BUMP **

    Getting tired of seeing this everyday. Can DarkOrb please remove this?
     
  5. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    delete the fixmysql file touch a new one and chattr it.
     
  6. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Thanks i will do that!
     
Loading...

Share This Page