From: Sabika Makhdoom
Date: November 17 2012 8:10am
Subject: Re: installing mysql from src
List-Archive: http://lists.mysql.com/mysql/228646
Message-Id: <71BF6CA9-C191-4F55-BF5C-C0C0D3E297E1@gmail.com>
MIME-Version: 1.0 (iPhone Mail 8J2)
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

You can specify installation directory when you run the installer script ins=
tead of make. Also update the MySQL base and data directories in the mysql.s=
erver file under the support files directory. You can copy that file to /etc=
/init.d and add MySQL to chkconfig

Sabika

Life was meant to be mobile

On Nov 16, 2012, at 10:34 AM, Reindl Harald <h.reindl@stripped> wrote:

>=20
>=20
> Am 16.11.2012 19:21, schrieb =C3=89rico:
>> I have followed the steps from bellow to install mysql from src on my lin=
ux
>> ( red hat 6 ) :
>>=20
>> shell> groupadd mysql
>> shell> useradd -r -g mysql mysql
>> # Beginning of source-build specific instructions
>> shell> tar zxvf mysql-VERSION.tar.gz
>> shell> cd mysql-VERSION
>> shell> cmake .
>> shell> make
>> shell> make install
>>=20
>> all these as root
>> the point is that it did not install into /usr/local but into /usr/share
>=20
> first:
> why do you not take the src.rpm and modify the SPEC-file
> to install in /usr/local and build a RPM with a
> restricted user?
>=20
> building software directly and especially as root leads sooner or later
> in all kind of troubles because there will be orphaned files over the
> long and if oyu make any  mistake you spit files all over the system
> while rpmbuild is chained and restricted if it doe snot run as root and
> makes sure you have each time you start the build a clean buildroot
>=20
> yes, learn to use rpmbuild takes a little time
> but after have it running you save much more and
> with "rpmbuild -bs mysql.spec" you can build your
> src.rpm to backup and re-use it on any machine
>=20
>> 121116 14:50:18 [ERROR] Column count of mysql.proc is wrong. Expected 20,=

>> found 16. Created with MySQL 50080, now running 50504. Please use
>> mysql_upgrade to fix this error
>=20
> clear after upgrade to another major version
>=20
>> ERROR: 1558  Column count of mysql.proc is wrong. Expected 20, found 16.
>> Created with MySQL 50080, now running 50504. Please use mysql_upgrade to
>> fix this error.
>> 121116 14:50:18 [ERROR] Aborting
>>=20
>> but I CAN NOT update MySQL ... it doesn allow me to :
>>=20
>> [root@ericomtx bin]# ./mysql_upgrade
>> Looking for 'mysql' as: ./mysql
>> Looking for 'mysqlcheck' as: ./mysqlcheck
>> Running 'mysqlcheck with default connection arguments
>> ./mysqlcheck: Got error: 2002: Can't connect to local MySQL server throug=
h
>> socket '/tmp/mysql.sock' (2) when trying to connect
>=20
> well, configure your client and server correctly
> to the same socket fileor use at least the
> command-line option --socket=3D
>=20
> mysql_upgrade --help is your friend
> _____________________________
>=20
> /etc/my.cnf:
> [mysqld]
> socket =3D /var/lib/mysql/mysql.sock
>=20
> [client]
> socket =3D /var/lib/mysql/mysql.sock
>=20
> [mysqladmin]
> socket=3D /var/lib/mysql/mysql.sock
>=20
> [mysqld_safe]
> socket =3D /var/lib/mysql/mysql.sock
>=20
>=20
>=20