MySQL error!

Discussion in 'HOWTO-Related Questions' started by poba, Mar 18, 2007.

  1. poba

    poba New Member

    Hi,

    when I setup my server as described here (http://www.howtoforge.com/perfect_setup_opensuse_10.2) I get this error:
    Code:
    suse:~ # /etc/init.d/mysql start
    Creating MySQL privilege database...
    Installing all prepared tables
    Fill help tables
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h suse.pc-storitve.si password 'new-password'
    See the manual for more instructions.
    
    You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
    cd sql-bench ; perl run-all-tests
    
    Please report any problems with the /usr/bin/mysqlbug script!
    
    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at http://shop.mysql.com
    Updating MySQL privilege database...
    mysql.columns_priv                                 OK
    mysql.db                                           OK
    mysql.func                                         OK
    mysql.help_category                                OK
    mysql.help_keyword                                 OK
    mysql.help_relation                                OK
    mysql.help_topic                                   OK
    mysql.host                                         OK
    mysql.proc                                         OK
    mysql.procs_priv                                   OK
    mysql.tables_priv                                  OK
    mysql.time_zone                                    OK
    mysql.time_zone_leap_second                        OK
    mysql.time_zone_name                               OK
    mysql.time_zone_transition                         OK
    mysql.time_zone_transition_type                    OK
    mysql.user                                         OK
    [COLOR="Red"]ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'[/COLOR]
    Starting service MySQL                                                done
    What's the problem?
     
  2. till

    till Super Moderator

    Have you tried to remove mysql with yast and reinstall it?
     
  3. zcworld

    zcworld New Member

    try
    removing /var/lib/mysql/
    -> mysql
    -> test
    -> information_schema
    than restart mysql
    /etc/init.d/mysql restart


    than it will remake all the keep SQL database thats are needed to run it
    try that way see if its works than if not do what till said
     
  4. poba

    poba New Member

Share This Page