MySQL install error
I've been trying to get MySQL installed on my dedicated server now.This is one way I tried installing.
[root@localhost riscphree]# rpm -Uvh *.rpm
warning: MySQL-server-4.1.16-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
051214 18:58:32 [ERROR] Aborting
051214 18:58:32 [Note] /usr/sbin/mysqld: Shutdown complete
/usr/bin/mysql_install_db: line 299: 25220 Broken pipe cat $fill_help_tables
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly
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 localhost password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
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 https://order.mysql.com
Starting MySQL................................... ERROR!
warning: MySQL-server-4.1.16-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
051214 18:58:32 [ERROR] Aborting
051214 18:58:32 [Note] /usr/sbin/mysqld: Shutdown complete
/usr/bin/mysql_install_db: line 299: 25220 Broken pipe cat $fill_help_tables
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly
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 localhost password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
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 https://order.mysql.com
Starting MySQL................................... ERROR!