Ok, running FC2 and tried to install Mysql from source, I followed the installation from mysql's site and get this error:
[root@localhost mysql]# bin/mysql_install_db --user=mysql
Installing all prepared tables
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-' for key 1
Fill help tables
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
051218 19:28:40 [ERROR] Aborting
051218 19:28:40 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
bin/mysql_install_db: line 299: 18218 Broken pipe cat $fill_help_tables
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
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/local/mysql/bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at https://order.mysql.com
I dont know what that syntax error is ..
and here is the error I get when I try to start it:
[root@localhost mysql]# bin/mysqld_safe --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/localhost.pid 051218 19:49:45 mysqld ended
The reason why I did not use yum to get mysql is because it gave me an old version (3.23) and as you know .. thats reallly old. This is mysql 4.1.16.
Anyone have a take on it?