MySQL not starting, wrong syntax???

riscphree · 12-17-2005, 01:59 PM

I am running FC2. I am trying to install MySQL 4.1.16

I could not use the MySQL 3.23 that was available on the repos.

Ok, I downloaded the RPM's from MySQL. Both client and server. I did:

Code:

# rpm -i MySQL-server-4.1.16-0.glibc23.i386.rpm

and I get this:

Code:

# rpm -i MySQL-server-4.1.16-0.glibc23.i386.rpm
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
051216 23:38:11 [ERROR] Aborting

051216 23:38:11 [Note] /usr/sbin/mysqld: Shutdown complete

/usr/bin/mysql_install_db: line 299:  1633 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!

what does this mean? I have installed the correct version of the mysql client, however, I cant seem to get the server started.

bigrigdriver · 12-17-2005, 07:59 PM

I just looked at the MySQL site, and I didn't see any rpms for Fedora. So, I suggest the possibility that the rpms you downloaded aren't fully compatible with Fedora.

You best bet would be to download the .src.rpms for MySQL and compile binary, installable rpms for your box. Then install those. That should take care of the error messages.

If you don't know how to compile .src.rpms, there are many posts on these boards regarding that issue. You can also visit the RedHad site, and view or download the book "Maximum RPM" which covers that topic quite well.

riscphree · 12-21-2005, 08:13 PM

I have installed from source, but now get these errors:

Code:

[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
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

and get this error when I try and start it:

Code:

[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