MySql Install error

osga · 03-23-2005, 01:49 PM

I trying for several hours to install myqsl 4.0.24 and i just cant see what is the problem.

I'm using Slackware 10.1 and i ve removed the package mysql with pkgtool...so far so good,no problem with this.I went to mysql.com to download the tar.gz from them, and after i made this:

as root:

tar xvfz mysql-standard-4.0.24.tar.gz

cd mysql-standard-4.0.24

./configure --prefix==/opt/mysql

Code:

NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
050323 19:28:35 ./bin/mysqld: Shutdown Complete


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:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h server password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./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 . ; ./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 ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

Support MySQL by buying support/licenses at 

Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
root@server:~/mysql-standard-4.0.24-pc-linux-gnu-i686# Starting mysqld daemon with databases from /root/mysql-standard-4.0.24-pc-linux-gnu-i686/data
STOPPING server from pid file /root/mysql-standard-4.0.24-pc-linux-gnu-i686/data/server.pid
050323 19:28:36  mysqld ended

And i just cant do anything else....What am i doing wrong?!!

reddazz · 03-23-2005, 02:08 PM

All you need to do is
1) extract the file to where you want it to be located .e.g. mine was extracted to /usr/local and rename mysql
2) as root go to /usr/local/mysql/scripts and do "./mysql_install_db"
3) as root do chown -R root.mysql /usr/local/mysql
4) as root do chown -R mysql.mysql /usr/local/mysql/data
5) You then have to modify the Slackware mysqld script so that it has the right paths to your mysql installation. The databases are in /usr/local/mysql/data in the example I gave.
6) You may have to change passwords for the mysql user.

osga · 03-23-2005, 02:30 PM

Quote:

Originally posted by reddazz
All you need to do is
1) extract the file to where you want it to be located .e.g. mine was extracted to /usr/local and rename mysql
2) as root go to /usr/local/mysql/scripts and do "./mysql_install_db"
3) as root do chown -R root.mysql /usr/local/mysql
4) as root do chown -R mysql.mysql /usr/local/mysql/data
5) You then have to modify the Slackware mysqld script so that it has the right paths to your mysql installation. The databases are in /usr/local/mysql/data in the example I gave.
6) You may have to change passwords for the mysql user.

root@server:/opt/mysql/scripts# ./mysql_install_db
./mysql_install_db: line 86: my_print_defaults: command not found
Didn't find ./bin/mysqld
You should do a 'make install' before executing thisscript
root@server:/opt/mysql/scripts#

Now im really confused????

reddazz · 03-23-2005, 03:26 PM

Thats puzzling cause it seems like you downloaded the binary that doesn't need to be compiled. Anyway take a look at this documentation, maybe it'll help you sort out your problem.