Re: [cobalt-users] mysql 4 package?

[Jim Dory <jdory@xxxxxxxxxxxxxx>]

Arthur Sherman wrote:

> #cd /home/src
> #wget link_to_SOURCE_download
> #tar zxvf mysql-VERSION.tar.gz
> #cd mysql-VERSION
>
> #groupadd mysql
> #useradd -g mysql -c "MySQL Server" -d /dev/null -s /sbin/nologin mysql
>
> #CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \
> -felide-constructors -fno-exceptions -fno-rtti" ./configure \
> --prefix=/home/mysql --localstatedir=/home/mysql/data \
> --with-unix-socket-path=/home/tmp/mysql.sock \
> --with-mysqld-ldflags=-all-static --enable-assembler \
> --without-debug \
> --with-extra-charsets=complex --with-mysqld-user=mysql
>
> #make && make test
> #make install
>
> #./path_within_mysql_dir//mysql_install_db
> #chown -R root:mysql  /home/mysql
> #chown -R mysql:mysql /home/mysql/data
>
> #cp support-files/my-medium.cnf /etc/my.cnf
> #chown root:sys /etc/my.cnf
> #chmod 644 /etc/my.cnf
>
> #cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
> #chmod +x /etc/rc.d/init.d/mysql
> #/sbin/chkconfig --level 3 mysql on
>
> Then we set up symlinks for all the MySQL binaries, so they can be run from
> anyplace without having to include/specify long paths, etc.
> #cd /home/mysql/bin
> #for file in *; do ln -s /home/mysql/bin/$file /usr/local/sbin/$file; done
>
> Edit /etc/my.cnf and add/uncomment:
>
> skip-networking
> to the [mysqld] section.
>
> Now we can start the MySQL server!
Hey, thanks for all this help on mysql and php.. but I'm stuck, I think.

I went through your steps but must have downloaded the wrong thing.. got 
the binaries I guess instead of source from mysql.com. I didn't scroll 
down far enough. Question is, can I just delete the directories that 
untarred and then continue start over with correct source file? The 
output is below when I tried ./configure on it, using Arthur's instructions.

Yeah, I know, idiot.

thanks, Jim


[root opt]# cd mysql-standard-4.0.18-pc-linux-i686
[root mysql-standard-4.0.18-pc-linux-i686]# groupadd mysql
[root mysql-standard-4.0.18-pc-linux-i686]# useradd -g mysql -c "MySQL 
Server" -d /dev/null -s /sbin/nologin mysql
[root mysql-standard-4.0.18-pc-linux-i686]# CFLAGS="-O3 -mpentiumpro" 
CXX=gcc CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions 
-fno-rtti" ./configure --prefix=/home/mysql 
--localstatedir=/home/mysql/data 
--with-unix-socket-path=/home/tmp/mysql.sock 
--with-mysqld-ldflags=-all-static --enable-assembler --without-debug 
--with-extra-charsets=complex --with-mysqld-user=mysql
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.

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
040219 11:08:10  ./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 greenraq.citynome.org password 'new-password'
See the manual for more instructions.

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
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 mysql-standard-4.0.18-pc-linux-i686]# Starting mysqld daemon with 
databases from /home/opt/mysql-standard-4.0.18-pc-linux-i686/data
040219 11:08:11  mysqld ended



--
Jim Dory, Engineering
City of Nome
PO Box 281
102 Division St.
Nome, AK 99762
907.443.6604

http://www.nomealaska.org