problem with mySQL install
 

Hi...

I'm following the LAMPS tutorial...I downloaded mySQL 3.23.58 and first of all
I am confused about the following command in the tutorial

/usr/sbin/useradd mysql -g mysql -s /bin/false -d /home/mysql
scripts/mysql_install_db

Now I am not sure if the characters in bold are in continuation or a separate directory?, but this is how it appears in the tutorial

anyways, I gave the command

groupadd mysql

useradd mysql -g mysql -s /bin/false -d /home/mysql

Now, when i give ./configure, it gives me a seg-fault......what is probably wrong with this procedure?

---------------------

[root@amitmahajan mysql-3.23.58]# ./configure
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
040423 1:08:34 ./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 !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h amitmahajan.homelinux.com 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/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./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 the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@amitmahajan mysql-3.23.58]# Starting mysqld daemon with databases from /usr/local/mysql-3.23.58/data
./bin/safe_mysqld: line 284: 1880 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1
040423 01:08:35 mysqld ended

----------------------------------------------------------

Looking for some assistance...

amit

you have downloaded a compiled, binary, version of mysql. If you wish to com,pile it your self you will need to revisit the mysql download page and select the source tarball (right at the bottom IIRC).

Thanx for that info David...but, there's another question left answered in my first post..

Take a look at this command

/usr/sbin/useradd mysql -g mysql -s /bin/false -d /home/mysql
scripts/mysql_install_db

What is the correct path ??

1. -d /home/mysqlscripts/mysql_install_db ??

or is it supposed to be

2. -d /home/mysql/scripts/mysql_install_db ??


Pls suggest...

Regards,

amit

Ok...I got over this confusion..The correct command is

useradd mysql -g mysql -s /bin/false -d /home/mysql

./scripts/mysql_install_db

However, mysql ends without any reason now...I get the following message:

/usr/local/mysql/current/bin/mysqld_safe
Starting mysqld daemon with databases from /home/mysql/data
040423 11:45:57 mysqld ended

Now unless the daemon keeps running, the subsequent commands wont work..what to do now?

Regards,

amit

bump :confused: :scratch:

Check the permissions on the mysql data directory and the files within it - thye must be readable and writable by the mysql user.

Hi amit ,


scripts/mysql_install_db - actualy creates a test database for ur db server. As i know its located on the main installation directory under /scripts . e.g: mysql-3.23.58/scripts

I would suggest you to do a source installation. and have a look on :

"Installing MySQL on Other Unix-like Systems" - of mysql documentation. they really provides with amazing documentation i have seen ever before.

Happy install. :)

Thanx david...that did it!!!....I had forgotten to change ownership of the data folder to mysql...(sometimes one does forget small small things! ;) )

Thanx to all who chipped in :) .....I'll be back with some more issues soon ;)..lol

Regards,

amit