From: Reindl Harald
Date: April 2 2011 10:45am
Subject: Re: Mysql Bug 04/01/11
List-Archive: http://lists.mysql.com/mysql/224750
Message-Id: <4D96FE62.90105@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";
boundary="------------enigB55083CBE96F9BB259E92F41"
--------------enigB55083CBE96F9BB259E92F41
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Am 02.04.2011 02:18, schrieb Thomas Dineen:
>> Gentlemen:
>>=20
>> - Keep in mind that I have approximately 50 hours into this Mysql ser=
ver install and still no
>> results!
what have you done the whole time?
have you tried RTFM?
we are not here to guide a blind one trough a basic setup
because at the end you have something running and understodd
nothing!
sounds like you never before had used mysql and missing
all the basics from the first chapters in the well written documentation
>> - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz
>>=20
>> - When installed and started with the following command:
>> /usr/local/mysql/bin/mysqld_safe --user=3Dmysql &
>>=20
>> The following error occurs:
>> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find fi=
le: './mysql/host.frm' (errno: 13)
you should read the manuals or use a operating system with packages
which are idiot-proof, fedora does this for you:
if [ ! -d "$datadir/mysql" ] ; then
# First, make sure $datadir is there with correct permissions
if [ ! -e "$datadir" -a ! -h "$datadir" ]
then
mkdir -p "$datadir" || exit 1
fi
chown mysql:mysql "$datadir"
chmod 0755 "$datadir"
[ -x /sbin/restorecon ] && /sbin/restorecon "$datadir"
# Now create the database
action $"Initializing MySQL database: " /usr/bin/mysql_install_db --data=
dir=3D"$datadir" --user=3Dmysql
ret=3D$?
chown -R mysql:mysql "$datadir"
if [ $ret -ne 0 ] ; then
return $ret
fi
fi
>> 1) Please identify where the missing file can be found,=20
>> keeping in mind that I just installed and have no backup=20
>> (of the current rev.)
they CAN NOT BE FOUND if you have a fresh install and not used "mysql_ins=
tall_db"
and WHERE they are created depends on your configuration as said yesterda=
y
let me guess: you even have not spent any second for your my.cnf?
> [mysqld]
> datadir =3D /where/ever/you/want/your/databases/jesus/christ
on my system typing mysql_ followed with 2 x TAB brings a list of command=
s
since you think you must not use a environments package-system why
in the world do you not look in your bin-folder at /usr/local/mysql/
and read some docs to understand that the mysql-database is the userdb
[root@srv-rhsoft:~]$ mysql_
mysql_client_test mysql_convert_table_format mysql_fix_extensi=
ons mysql_secure_installation
mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap
mysql_config mysql_find_rows mysql_install_db =
mysql_setpermission
mysql_upgrade mysql_waitpid
--------------enigB55083CBE96F9BB259E92F41
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
iEYEARECAAYFAk2W/mIACgkQhmBjz394Ann7uwCeO9iSXHZh/JtcLdHwTyRdrQZ5
ljIAmQEJiEGdZHjG3N14y4bZt6sdbeBG
=j74F
-----END PGP SIGNATURE-----
--------------enigB55083CBE96F9BB259E92F41--