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?
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
Thanks, but I have enough of Suse. I decided to install Debian, but I have problem with upgrading MySQL http://www.howtoforge.com/forums/showthread.php?p=65327#post65327