Hello!!
Imam problem pri instalaciji mysql-a.
Inače imam RedHat 5.3, a instaliram iz source koda mysql-4.1.16. Prije sam imala instalaciju mysql-4.0.26.
Sad radim:
mysql-4.1.16
mysql-4.1.16]# ./configure --prefix=/usr/local/mysql --with-charset=latin2 --with-unix-socket-path=/tmp/mysql.sock --localstatedir=/usr/mysql
make
mysql-4.1.16]# make install
mysql-4.1.16]# cp support-files/my-medium.cnf /etc/my.cnf
mysql-4.1.16]# cd /usr/local/mysql
mysql]# chown -R root .
mysql]# chgrp -R mysql .
mysql]# bin/mysql_install_db --user=mysql
Javlja se sljedeća greška:
Installing all prepared tables
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
110511 15:43:20 [ERROR] Aborting
110511 15:43:20 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
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 ls186.tel.net.ba 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/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
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
Probala sam maknuti prethodnu instalaciju, ali opet ista greška:-(
Ima li neka naredba za trajno micanje stare verzije mysql-a?