RE: [cobalt-users] mysql 4 package?

[Arthur Sherman <arturs@xxxxxxxxxxxxxxxx>]

Was that .RPM? If so do:

Rpm -qa | grep mysql

You may uninstall the old release. 

Rpm -ev mysql-VER

If you run in to troubles send me output of rpm-qa above

And you definitely should take mysql-VER.tar.gz source.

Arthur Sherman
 

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx 
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of Jim Dory
> Sent: Thursday, February 19, 2004 21:57
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: Re: [cobalt-users] mysql 4 package?
> 
> 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
> 
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>