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.

Can't run mysql_fix_privilege_tables.sql

Discussion in 'Database Discussions' started by goldenpentium, Sep 7, 2010.

  1. goldenpentium

    goldenpentium Registered

    Joined:
    Sep 7, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Hello everyone, i'm not sure what to do here, here is the situation:

    In phpmyadmin I changed the permissions for admin to everything except drop rather than everything.
    now i cannot create new users, nor give them permissions.

    So i tried running mysql_fix_privilege_tables.sql

    HTML:
    mysql_fix_privilege_tables -uadmin -p***** -verbose
    This script updates all the mysql privilege tables to be usable by
    the current version of MySQL
    
    Got a failure from command:
    cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
    Please check the above output and try again.
    
    Running the script with the --verbose option may give you some information
    of what went wrong.
    
    If you get an 'Access denied' error, you should run this script again and
    give the MySQL root user password as an argument with the --password= option
    my.cnf:

    HTML:
    [mysqld]
    set-variable=local-infile=0
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    what can i do from here :eek:?

    Thanks for the help :)
     
Loading...

Share This Page