mysql question

[sonun]

I went through a install of mysql in the following steps which went throgh without any hitches.
#gunzip -dc mysql-3.23.49.tar.gz | tar xvf -
#cd mysql-3.23.49
#configure --prefix=/usr/local/mysql
#make
#make install
#scripts/mysql_install_db for which I got,
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
020221 17:58:00 /usr/local/mysql/libexec/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:
/usr/local/mysql/bin/mysqladmin -u root -p password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h lohengrin -p password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/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 /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

Then I type (to start the daemon)
#'/usr/local/mysql/bin/safe_mysqld &' for which I get,
[2] 25694
[root@lohengrin mysql-3.23.49]# chown: mysql: invalid user
Starting mysqld daemon with databases from /usr/local/mysql/var
020221 17:59:42 mysqld ended

[1]+ Done ./safe_mysqld


Of course now if I start to, I get,
# /usr/local/mysql/bin/mysqladmin -u root password 'abc'

./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

??????????????????????????????????????
Thanks.

 

[ifincham]

Hi,

That 'chown' error means you didn't create the 'mysql' user. You need to follow the instructions here -->

http://www.mysql.com/doc/Q/u/Quick_install.html

Hope this helps

 

[WheelDweller]

This might sound wrong, but here it is.

Drop the tarballs and use RPMs. I've installed MySQL about a hundred times, counting the updates- the maintainer of the RPM is a pro jock; when it's packaged, it's ready. And you don't have to micro-manage just to get the basics ready to support higher functions.

Just my 2 cents.