MySQL error!

[poba]

Hi,

when I setup my server as described here (http://www.howtoforge.com/perfect_setup_opensuse_10.2) I get this error:

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
ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Starting service MySQL                                                done

What's the problem?

[till]

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

[zcworld]

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

[poba]

Thanks, but I have enough of Suse. I decided to install Debian, but I have problem with upgrading MySQL

http://www.howtoforge.com/forums/sho...5327#post65327