Re: installing mysql from src

[Sabika Makhdoom]

You can specify installation directory when you run the installer script 
instead of make. Also update the MySQL base and data directories in the 
mysql.server 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  wrote:

> 
> 
> Am 16.11.2012 19:21, schrieb Érico:
>> I have followed the steps from bellow to install mysql from src on my linux
>> ( red hat 6 ) :
>> 
>> 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
>> 
>> all these as root
>> the point is that it did not install into /usr/local but into /usr/share
> 
> 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?
> 
> 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
> 
> 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
> 
>> 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
> 
> clear after upgrade to another major version
> 
>> 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
>> 
>> but I CAN NOT update MySQL ... it doesn allow me to :
>> 
>> [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 through
>> socket '/tmp/mysql.sock' (2) when trying to connect
> 
> well, configure your client and server correctly
> to the same socket fileor use at least the
> command-line option --socket=
> 
> mysql_upgrade --help is your friend
> _
> 
> /etc/my.cnf:
> [mysqld]
> socket = /var/lib/mysql/mysql.sock
> 
> [client]
> socket = /var/lib/mysql/mysql.sock
> 
> [mysqladmin]
> socket= /var/lib/mysql/mysql.sock
> 
> [mysqld_safe]
> socket = /var/lib/mysql/mysql.sock
> 
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: installing mysql from src

[Reindl Harald]

Am 16.11.2012 19:21, schrieb Érico:
> I have followed the steps from bellow to install mysql from src on my linux
> ( red hat 6 ) :
> 
> 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
> 
> all these as root
> the point is that it did not install into /usr/local but into /usr/share

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?

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

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

> 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

clear after upgrade to another major version

> 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
> 
> but I CAN NOT update MySQL ... it doesn allow me to :
> 
> [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 through
> socket '/tmp/mysql.sock' (2) when trying to connect

well, configure your client and server correctly
to the same socket fileor use at least the
command-line option --socket=

mysql_upgrade --help is your friend
_

/etc/my.cnf:
[mysqld]
socket = /var/lib/mysql/mysql.sock

[client]
socket = /var/lib/mysql/mysql.sock

[mysqladmin]
socket= /var/lib/mysql/mysql.sock

[mysqld_safe]
socket = /var/lib/mysql/mysql.sock





signature.asc
Description: OpenPGP digital signature

installing mysql from src

[Érico]

I have followed the steps from bellow to install mysql from src on my linux
( red hat 6 ) :

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

all these as root

the point is that it did not install into /usr/local but into /usr/share


these worked fine :
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .


but I can not create the DB or start the server :


1. [root@ericomtx bin]# pwd
/usr/bin
[root@ericomtx bin]# ls -la mysql*
-rwxr-xr-x. 1 root root 4984411 Nov 15 13:26 mysql
-rwxr-xr-x. 1 root root  110776 Nov 15 13:24 mysqlaccess
-rwxr-xr-x. 1 root root1702 Apr  9  2010 mysqlaccess.conf
-rwxr-xr-x. 1 root root 4290406 Nov 15 13:26 mysqladmin
-rwxr-xr-x. 1 root root 4841390 Nov 15 13:26 mysqlbinlog
-rwxr-xr-x. 1 root root   10349 Nov 15 13:24 mysqlbug
-rwxr-xr-x. 1 root root 4281034 Nov 15 13:26 mysqlcheck
-rwxr-xr-x. 1 root root 4994249 Nov 15 13:26 mysql_client_test
-rwxr-xr-x. 1 root root6456 Nov 15 13:24 mysql_config
-rwxr-xr-x. 1 root root4169 Nov 15 13:24 mysql_convert_table_format
-rwxr-xr-x. 1 root root   22389 Nov 15 13:24 mysqld_multi
-rwxr-xr-x. 1 root root   21432 Nov 15 13:24 mysqld_safe
-rwxr-xr-x. 1 root root 4473050 Nov 15 13:26 mysqldump
-rwxr-xr-x. 1 root root6602 Nov 15 13:24 mysqldumpslow
-rwxr-xr-x. 1 root root3245 Nov 15 13:24 mysql_find_rows
-rwxr-xr-x. 1 root root 483 Nov 15 13:24 mysql_fix_extensions
-rwxr-xr-x. 1 root root   32209 Nov 15 13:24 mysqlhotcopy
-rwxr-xr-x. 1 root root 4287853 Nov 15 13:26 mysqlimport
-rwxr-xr-x. 1 root root   14472 Nov 15 13:24 mysql_install_db
-rwxr-xr-x. 1 root root7694 Nov 15 13:24 mysql_secure_installation
-rwxr-xr-x. 1 root root   16689 Nov 15 13:24 mysql_setpermission
-rwxr-xr-x. 1 root root 4278732 Nov 15 13:26 mysqlshow
-rwxr-xr-x. 1 root root 4331143 Nov 15 13:26 mysqlslap
-rwxr-xr-x. 1 root root 4845542 Nov 15 13:26 mysqltest
-rwxr-xr-x. 1 root root  729588 Nov 15 13:26 mysql_tzinfo_to_sql
-rwxr-xr-x. 1 root root 1017021 Nov 15 13:26 mysql_upgrade
-rwxr-xr-x. 1 root root  888746 Nov 15 13:26 mysql_waitpid
-rwxr-xr-x. 1 root root3818 Nov 15 13:24 mysql_zap


[root@ericomtx bin]# ./mysql_install_db --user =mysql


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.
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

but I CAN NOT update MySQL ... it doesn allow me to :


[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 through
socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
[root@ericomtx bin]#


 also ... you may say to me so I need to create the DB from my install
dir ... ok :

[root@ericomtx mysql-5.5.4-m3]# scripts/mysql_install_db --user=mysql
WARNING: The host '' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
121116 14:53:47 [Note] Buffered information: Performance schema disabled
(reason: start parameters).


121116 14:53:47 [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.
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:53:47 [ERROR] Aborting

121116 14:53:47 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the

Re: Installing Mysql Workbench

[Adarsh Sharma]

Thanks Vikas,

I checked my versions and below are the details :-

[root@]# gcc --version
gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[root@]# yacc --version [Don't know how to check 
its version ]

usage: yacc [-dlrtv] [-b file_prefix] [-o output_filename]
   [-p symbol_prefix] filename

[root@w~]# bison --version
bison (GNU Bison) 2.3
Written by Robert Corbett and Richard Stallman.

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[root@ws-test ~]# flex --version
flex version 2.5.4
[root@ws-test ~]# flex++ --version
flex++ version 2.5.4
[root@ws-test ~]#


Do I need to update any software.

Thanks

Vikas Shukla wrote:

Hi Adarsh, Please first check whether the pre-requisites for mysql are
accomplished are not.
For this, check following things:-
 1. gcc and its compatible version
 2. Yacc
 3. Bison
 4. Flex

These packages of appropriate version must be installed on your linux.

On Thu, Feb 16, 2012 at 2:04 PM, Adarsh Sharma  wrote:
  

Any update on the issue





Dear all,

Today I am facing some issues while installing
mysql-workbench-gpl-5.2.37-src] in CentOS 5.4.

./configure runs successfully but below command results in below error :

make

make[3]: Entering directory
`/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.37-src/ext/scintilla/gtk'
/bin/sh ../../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I.
-I../../.. -I ../include -I ../src -I ../lexlib
/usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra -Wall -Wno-unused
-Wsign-compare -DTIXML_USE_STL=1 -c -o scintilla-marshal.lo
scintilla-marshal.c
gcc -DHAVE_CONFIG_H -I. -I../../.. -I ../include -I ../src -I ../lexlib
/usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra -Wall -Wno-unused
-Wsign-compare -DTIXML_USE_STL=1 -c scintilla-marshal.c -fPIC -DPIC -o
.libs/scintilla-marshal.o
gcc: /usr/include/glib-2.0:/usr/lib64/glib-2.0/include: No such file or
directory
In file included from scintilla-marshal.c:2:
/usr/include/glib-2.0/glib-object.h:25:28: error: gobject/gboxed.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:26:28: error: gobject/genums.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:27:29: error: gobject/gobject.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:28:28: error: gobject/gparam.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:29:33: error: gobject/gparamspecs.h:
No such file or directory
/usr/include/glib-2.0/glib-object.h:30:29: error: gobject/gsignal.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:31:36: error:
gobject/gsourceclosure.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:32:27: error: gobject/gtype.h: No such
file or directory
/usr/include/glib-2.0/glib-object.h:33:33: error: gobject/gtypemodule.h:
No such file or directory
/usr/include/glib-2.0/glib-object.h:34:33: error: gobject/gtypeplugin.h:
No such file or directory
/usr/include/glib-2.0/glib-object.h:35:28: error: gobject/gvalue.h: No
such file or directory
/usr/include/glib-2.0/glib-object.h:36:33: error: gobject/gvaluearray.h:
No such file or directory
/usr/include/glib-2.0/glib-object.h:37:33: error: gobject/gvaluetypes.h:
No such file or directory
scintilla-marshal.c:52: error: expected ‘)’ before ‘*’ token
make[3]: *** [scintilla-marshal.lo] Error 1

Any comments to troubleshoot the issue.
I set following paths in my .bashrc
export GNOME_CFLAGS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export GNOME_LIBS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export CAIRO_CFLAGS=/usr/include/cairo:/usr/lib64
export CAIRO_LIBS=/usr/include/cairo:/usr/lib64

Thanks


  

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Installing Mysql Workbench

[Adarsh Sharma]

Any update on the issue



Dear all,

Today I am facing some issues while installing 
mysql-workbench-gpl-5.2.37-src] in CentOS 5.4.


./configure runs successfully but below command results in below error :

make

make[3]: Entering directory 
`/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.37-src/ext/scintilla/gtk' 

/bin/sh ../../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H 
-I. -I../../.. -I ../include -I ../src -I ../lexlib 
/usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra -Wall 
-Wno-unused -Wsign-compare -DTIXML_USE_STL=1 -c -o 
scintilla-marshal.lo scintilla-marshal.c
gcc -DHAVE_CONFIG_H -I. -I../../.. -I ../include -I ../src -I 
../lexlib /usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra 
-Wall -Wno-unused -Wsign-compare -DTIXML_USE_STL=1 -c 
scintilla-marshal.c -fPIC -DPIC -o .libs/scintilla-marshal.o
gcc: /usr/include/glib-2.0:/usr/lib64/glib-2.0/include: No such file 
or directory

In file included from scintilla-marshal.c:2:
/usr/include/glib-2.0/glib-object.h:25:28: error: gobject/gboxed.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:26:28: error: gobject/genums.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:27:29: error: gobject/gobject.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:28:28: error: gobject/gparam.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:29:33: error: 
gobject/gparamspecs.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:30:29: error: gobject/gsignal.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:31:36: error: 
gobject/gsourceclosure.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:32:27: error: gobject/gtype.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:33:33: error: 
gobject/gtypemodule.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:34:33: error: 
gobject/gtypeplugin.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:35:28: error: gobject/gvalue.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:36:33: error: 
gobject/gvaluearray.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:37:33: error: 
gobject/gvaluetypes.h: No such file or directory

scintilla-marshal.c:52: error: expected ‘)’ before ‘*’ token
make[3]: *** [scintilla-marshal.lo] Error 1

Any comments to troubleshoot the issue.
I set following paths in my .bashrc
export GNOME_CFLAGS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export GNOME_LIBS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export CAIRO_CFLAGS=/usr/include/cairo:/usr/lib64
export CAIRO_LIBS=/usr/include/cairo:/usr/lib64

Thanks





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Installing Mysql Workbench

[Adarsh Sharma]

Dear all,

Today I am facing some issues while installing 
mysql-workbench-gpl-5.2.37-src] in CentOS 5.4.


./configure runs successfully but below command results in below error :

make

make[3]: Entering directory 
`/root/Desktop/MYSQLWORKBENCH/mysql-workbench-gpl-5.2.37-src/ext/scintilla/gtk'
/bin/sh ../../../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. 
-I../../.. -I ../include -I ../src -I ../lexlib 
/usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra -Wall 
-Wno-unused -Wsign-compare -DTIXML_USE_STL=1 -c -o scintilla-marshal.lo 
scintilla-marshal.c
gcc -DHAVE_CONFIG_H -I. -I../../.. -I ../include -I ../src -I ../lexlib 
/usr/include/glib-2.0:/usr/lib64/glib-2.0/include -Wextra -Wall 
-Wno-unused -Wsign-compare -DTIXML_USE_STL=1 -c scintilla-marshal.c 
-fPIC -DPIC -o .libs/scintilla-marshal.o
gcc: /usr/include/glib-2.0:/usr/lib64/glib-2.0/include: No such file or 
directory

In file included from scintilla-marshal.c:2:
/usr/include/glib-2.0/glib-object.h:25:28: error: gobject/gboxed.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:26:28: error: gobject/genums.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:27:29: error: gobject/gobject.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:28:28: error: gobject/gparam.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:29:33: error: gobject/gparamspecs.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:30:29: error: gobject/gsignal.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:31:36: error: 
gobject/gsourceclosure.h: No such file or directory
/usr/include/glib-2.0/glib-object.h:32:27: error: gobject/gtype.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:33:33: error: gobject/gtypemodule.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:34:33: error: gobject/gtypeplugin.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:35:28: error: gobject/gvalue.h: No 
such file or directory
/usr/include/glib-2.0/glib-object.h:36:33: error: gobject/gvaluearray.h: 
No such file or directory
/usr/include/glib-2.0/glib-object.h:37:33: error: gobject/gvaluetypes.h: 
No such file or directory

scintilla-marshal.c:52: error: expected ‘)’ before ‘*’ token
make[3]: *** [scintilla-marshal.lo] Error 1

Any comments to troubleshoot the issue.
I set following paths in my .bashrc
export GNOME_CFLAGS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export GNOME_LIBS=/usr/include/glib-2.0:/usr/lib64/glib-2.0/include
export CAIRO_CFLAGS=/usr/include/cairo:/usr/lib64
export CAIRO_LIBS=/usr/include/cairo:/usr/lib64

Thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Installing Mysql-Workbench

[Adarsh Sharma]

Dear All,

I researched about data modelling & designing Schema diagrams & need a 
tool to design Schema diagrams.
Today i download the source code of Mysql-Workbench ( 
mysql-workbench-gpl-5.2.37-src ), but when i run the ./configure command 
i am facing the below issue :-



checking for GNOME... configure: error: Package requirements (gtkmm-2.4 
>= 2.12) were not met:


Requested 'gtkmm-2.4 >= 2.12' but version of gtkmm is 2.10.10

Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.

Alternatively, you may set the environment variables GNOME_CFLAGS
and GNOME_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.


I know I need to meet some dependencies , and is there any link that 
first installs all dependencies 7 then mysql-workbench because my yum 
install dependencies does not find the corresponding packages.



Thanks in Advance.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: problem with installing MySQL 5.5 on OS Lion

[Tim Johnson]

* Martin Mueller  [12 13:42]:
<..> 
> In short, in my installation there seems a gap between mysql and mysql, and
> I can't find any good explanations for what I might have done wrong or how I
> could fix it. 
> 
> I'll be grateful for any help.
 
 I am probably not going to be very useful, but have you checked you
 environment? In particular $PATH. I recently transitioned from
 linux to mac lion and found out after some befuddlement that some
 terminal emulators provide environment variables that were not
 what I expected...

-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

problem with installing MySQL 5.5 on OS Lion

[Martin Mueller]

I had MySQL 5.5.15 running on OS X Lion, deleted it, and tried to install
5.5.17. I have run into problems that I cannot  solve.

To begin with the end, I can run start mysqld with the skip-grant-tables
option and connect with mysql.  If I issue the command

select * from mysql

the result returns an empty set. This squares with the following finding. I
had thought that lost passwords caused problems and ran  the procedure for
updating the root password that is set forth in the MySQL documentation. The
procedure executes, except that it says that 0 rows were updated. So I
assume that the user account root does not exist on the machine. There is a
mysql user account on my Mac, but there may not be a mysql user entry in the
user table. 

If I try to connect to the server with the mysql command when the server is
started in the ordinary fashion I get the error message

Access denied for user 'martin'@'localhost' (using password: NO)

ditto for commands like

mysql ­p ­u  root
mysql ­u root

and the like.

I should add that I followed Rob Allen's instructions for completely
uninstalling previous versions, and theoretically speaking there should be
no traces of earlier passwords on my system. But I'm not sure.

I should add that I also followed the Post-installation steps inPaul
Dubois's MySQL, and I noticed something odd. According to him, if you have a
.tar package you need to run the mysql_install_db script. If you have a .dmg
package, the installer runs it for you. When the .dmg package had the
problems I described above, I tried a fresh installation from the .tar
package. But the command
bin/mysql_install_db ‹user=mysql  does not work , and in fact there is no
script by that name in the /usr/local/mysql/bin directory.

In short, in my installation there seems a gap between mysql and mysql, and
I can't find any good explanations for what I might have done wrong or how I
could fix it. 

I'll be grateful for any help.

Re: Error when installing mysql-5.5.9 server on Linux Redhat OS

[Reindl Harald]

Am 17.06.2011 19:53, schrieb Philippe Mokrani:

> I have the following error messages:
> 
> Installing MySQL system tables...
> 
> 110617 19:46:25 [ERROR] ./bin/mysqld: unknown variable
> 'default-character-set=latin1'

"default-character-set=latin1" is way too old for 5.5
"character-set-server" should be used



signature.asc
Description: OpenPGP digital signature

Error when installing mysql-5.5.9 server on Linux Redhat OS

[Philippe Mokrani]

Hello,

 

I tried to install  mysql-5.5.9 server on  Redhat 2.6.18-194.el5  x86_64
GNU/Linux  operating system  using the binary distribution
openlogic-mysql-5.5.9-linux-amd64-bin-1.zip  from
http://olex.openlogic.com/packages/mysql/5.5.9

 

After installed the above archive in  a  "/moteurs"   directory, and
executed the following installation commands under root:

 

# unzip openlogic-mysql-5.5.9-linux-ia32-bin-2.zip

# cd mysql-5.5.9

# chown -R mysql .

# chgrp -R mysql .

# scripts/mysql_install_db --user=mysql

 

I have the following error messages:

 

Installing MySQL system tables...

110617 19:46:25 [ERROR] ./bin/mysqld: unknown variable
'default-character-set=latin1'

110617 19:46:25 [ERROR] Aborting

 

110617 19:46:25 [Note] ./bin/mysqld: Shutdown complete

 

Installation of system tables failed!  Examine the logs in

./data for more information.

 

You can try to start the mysqld daemon with:

 

shell> ./bin/mysqld --skip-grant &

 

and use the command line tool ./bin/mysql

to connect to the mysql database and look at the grant tables:

 

shell> ./bin/mysql -u root mysql

mysql> show tables

 

Try 'mysqld --help' if you have problems with paths.  Using --log

gives you a log in ./data that may be helpful.

 

Please consult the MySQL manual section

'Problems running mysql_install_db', and the manual section that

describes problems on your OS.  Another information source are the

MySQL email archives available at http://lists.mysql.com/.

 

Please check all of the above before mailing us!  And remember, if

you do mail us, you MUST use the ./bin/mysqlbug script!

 

 

No log file was created in  ./data directory.

I have tried all the actions mentioned on the above messages,  I have read
the documentation, I have searched for the error message  [ERROR]
./bin/mysqld: unknown variable 'default-character-set=latin1' ,  but without
success.

 

May have I help ?

 

Best regards,

Philippe Mokrani

 



 




 

Re: Problem with installing MySQL

[Shawn Green]

alba.albetti wrote:

I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written 
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password:  and I've given  and I 
get

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

After installing MySQL what do I have to do left?
Sorry my this is my firt time with MySQL



If you have not set a password for the root user, yet, then there is no 
password. Leave off the -p option and see if it allows you to set it 
that way.


--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Problem with installing MySQL

[Ananda Kumar]

what is mysql2010, it it host name or password.

If password, there cannot be space for a password, it its host, then dont
use if u connecting from the server.

regards
anandkl

On Fri, Apr 9, 2010 at 2:06 AM, Michael Dykman  wrote:

> If you want to specify the password itself on the command line use
> '--password' (double hyphen).  '-p' requests interactive password
> prompt.
>
>  - michael
>
>
> On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen 
> wrote:
> > don't have a space between '-p' and 'password', i.e. -ppassword
> >
> > / Carsten
> >
> > alba.albetti skrev:
> >>
> >> I've just installed MySQL on Windows 2000.
> >> I've opened the MS-DOS windows and I've written
> >> >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
> >> After the enter the prompt says >Enter password:  and I've given 
> >> and I get
> >>
> >> mysqladmin: connect to server at 'localhost' failed
> >> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> >>
> >> After installing MySQL what do I have to do left?
> >> Sorry my this is my firt time with MySQL
> >>
> >> Thanks!
> >>
> >>
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
> >
> >
>
>
>
> --
>  - michael dykman
>  - mdyk...@gmail.com
>
>  May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=anan...@gmail.com
>
>

Re: Problem with installing MySQL

[Michael Dykman]

If you want to specify the password itself on the command line use
'--password' (double hyphen).  '-p' requests interactive password
prompt.

 - michael


On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen  wrote:
> don't have a space between '-p' and 'password', i.e. -ppassword
>
> / Carsten
>
> alba.albetti skrev:
>>
>> I've just installed MySQL on Windows 2000.
>> I've opened the MS-DOS windows and I've written
>> >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
>> After the enter the prompt says >Enter password:  and I've given 
>> and I get
>>
>> mysqladmin: connect to server at 'localhost' failed
>> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
>>
>> After installing MySQL what do I have to do left?
>> Sorry my this is my firt time with MySQL
>>
>> Thanks!
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>



-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Problem with installing MySQL

[Carsten Pedersen]

don't have a space between '-p' and 'password', i.e. -ppassword

/ Carsten

alba.albetti skrev:

I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written 
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password:  and I've given  and I 
get

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

After installing MySQL what do I have to do left?
Sorry my this is my firt time with MySQL

Thanks!




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Problem with installing MySQL

[mos]

At 09:02 AM 4/8/2010, alba\.albetti wrote:

I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've 
written >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password:  and I've given  
and I get


mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

After installing MySQL what do I have to do left?
Sorry my this is my firt time with MySQL

Thanks!



Don't add a space between the "-u" and the user name or "-p" and the password.

Example, use:

C:\Programs\MySQL\...\bin\mysqladmin -uroot -p mysql2010

Mike




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Problem with installing MySQL

[alba.albetti]

I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written 
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password:  and I've given  and I 
get

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

After installing MySQL what do I have to do left?
Sorry my this is my firt time with MySQL

Thanks!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

installing mysql 5.1.37 in ubuntu 8.10

[Mohan Prasad Gutta]

Hi,
i am using ubuntu 8.10, i installed mysql from aptitude(version is 
5.0.67-0ubuntu6). My db creation sql script is working correctly in 
version, But my client complaining its giving errors in mysql 5.1.37 
version.

Could any one guide me to install mysql 5.1.37 in my ubuntu 8.10 OS.

Thanks in advance.

Best Regards,
Mohan.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Installing MySQL from source

[Paul DuBois]

On Feb 13, 2009, at 8:52 AM, Joerg Bruehe wrote:


Michel,


michel wrote:
From the different documentation I was reading that after going to  
the root directory I should execute /.configure; but there is no  
configure file in the root source directory, just configure.in


there is a difference between
 "Installing MySQL from the current development source tree"
and
 "Installing MySQL from the source tarball of some released version".

In the development source tree, we have files which need to be  
processed

by the GNU autotools (autoconf, automake, aclocal),
whereas a source tarball is created from the result of these tools.

The manual should cover that, but I don't have a specific URL handy.


It's http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html


The development tree contains a file "BUILD/autorun.sh" which runs  
these

tools.


HTH,
Jörg


--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Installing MySQL from source

[Joerg Bruehe]

Michel,


michel wrote:
> From the different documentation I was reading that after going to the root 
> directory I should execute /.configure; but there is no configure file in the 
> root source directory, just configure.in

there is a difference between
  "Installing MySQL from the current development source tree"
and
  "Installing MySQL from the source tarball of some released version".

In the development source tree, we have files which need to be processed
by the GNU autotools (autoconf, automake, aclocal),
whereas a source tarball is created from the result of these tools.

The manual should cover that, but I don't have a specific URL handy.

The development tree contains a file "BUILD/autorun.sh" which runs these
tools.


HTH,
Jörg

-- 
Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
Sun Microsystems GmbH,   Sonnenallee 1,   D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Installing MySQL from source

[michel]

>From the different documentation I was reading that after going to the root 
>directory I should execute /.configure; but there is no configure file in the 
>root source directory, just configure.in

Installing MySQL client into workstations using GPO

[Scott Hamm]

My objective is to have all Windows XP workstation (300+) report their 
activities using mysql client that exports in CSV format to our Active 
Directory's MySQL server.  Is it possible to install just the MySQL client over 
GPO, is this possible?

Thanks,


Scott Hamm
Technology Coordinator
MOT Charter School
1156 Levels Rd
Middletown, DE 19709
scott.h...@mot.k12.de.us

--And the mome raths outgrabe...

Installing MySQL Twice

[Jesse]

We have a web server that am using solely as a mysql replication server 
right now, so it's not really being used that much.  I'd like to use it as a 
backup web server as well, but I don't want to mess with the replication 
that I've got going on.  I believe I've heard that you can install MySQL 
twice on a server, right?  How does one go about doing that?  This is a 
Windows 2003 server.  I realize that as an alternative, I can install a 
Virtual Machine and some flavor of Linux (Ubuntu would be my choice, most 
likely), and that would probably solve the problem, but would it be easier 
to just install MySQL twice on this machine?  Obviously, when I install, I'd 
want to install to a different directory, put the data in a different 
directory, and use a different port.  How would Windows handle having the 
MySQL service running twice, would that be a problem?  Are there any "got 
'cha's" in this situation?


Thanks,
Jesse 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: locked file mysqld-nt.exe when re-installing mysql on windows server

[Johan Gant]

That worked for me, much appreciated.

Thanks

2008/7/30 Ananda Kumar <[EMAIL PROTECTED]>

> got to
>
> start-->run--(type regedit)-->HKEY_LOCAL_MACHINE--->SOFTWARE
> folder--->delete all mysql folder
>
> Then in SYSTEM Folder --->controlset001-->services---> delete all mysql
> entries. Do the same for controlset002 and controlset003
>
> After above is done try to delete the file in C:\mysql\bin folder.
>
> regards
> anandkl
>
>
> On 7/30/08, Johan Gant <[EMAIL PROTECTED]> wrote:
>>
>> Hi
>> I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003
>> machine,
>> but I cannot delete the original installation folder or re-install into it
>> due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder.
>> I've killed all services relating to MySQL (or those that I can clearly
>> identify using task manager and the services list from admin tools) from
>> all
>> user sessions on that machine, but the file is still locked by some
>> process
>> which I cannot identify. I encountered this problem in the past and got
>> around it by killing all MySQL related processes but this time it's not
>> helping. I've also logged out any other user sessions on this machine to
>> ensure there is nothing idling in the background.
>>
>> Short of rebooting the server - is there any way to find out what might be
>> locking this file, or a way of forcing a release to allow me to reinstall
>> MySQL? I'm happy to hear alternative suggestions as well.
>>
>> Thanks
>> Johan
>>
>
>

Re: locked file mysqld-nt.exe when re-installing mysql on windows server

[Ananda Kumar]

got to

start-->run--(type regedit)-->HKEY_LOCAL_MACHINE--->SOFTWARE
folder--->delete all mysql folder

Then in SYSTEM Folder --->controlset001-->services---> delete all mysql
entries. Do the same for controlset002 and controlset003

After above is done try to delete the file in C:\mysql\bin folder.

regards
anandkl


On 7/30/08, Johan Gant <[EMAIL PROTECTED]> wrote:
>
> Hi
> I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine,
> but I cannot delete the original installation folder or re-install into it
> due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder.
> I've killed all services relating to MySQL (or those that I can clearly
> identify using task manager and the services list from admin tools) from
> all
> user sessions on that machine, but the file is still locked by some process
> which I cannot identify. I encountered this problem in the past and got
> around it by killing all MySQL related processes but this time it's not
> helping. I've also logged out any other user sessions on this machine to
> ensure there is nothing idling in the background.
>
> Short of rebooting the server - is there any way to find out what might be
> locking this file, or a way of forcing a release to allow me to reinstall
> MySQL? I'm happy to hear alternative suggestions as well.
>
> Thanks
> Johan
>

locked file mysqld-nt.exe when re-installing mysql on windows server

[Johan Gant]

Hi
I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine,
but I cannot delete the original installation folder or re-install into it
due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder.
I've killed all services relating to MySQL (or those that I can clearly
identify using task manager and the services list from admin tools) from all
user sessions on that machine, but the file is still locked by some process
which I cannot identify. I encountered this problem in the past and got
around it by killing all MySQL related processes but this time it's not
helping. I've also logged out any other user sessions on this machine to
ensure there is nothing idling in the background.

Short of rebooting the server - is there any way to find out what might be
locking this file, or a way of forcing a release to allow me to reinstall
MySQL? I'm happy to hear alternative suggestions as well.

Thanks
Johan

installing mysql on OSX 10.4

[uszek]

This problem is driving me crazy. Please help.

127:~ mariuszlenk$ cd /usr/local/mysql
127:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/127.0.0.1.pid
061108 00:31:05  mysqld ended

this is kind of error im getting all the time round? could you help me to solve 
it?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem installing MySQL 5.0.24a from RHEL RPM on Centos Linux VPS box

[Vasudev Ram]

Hi list,

I'm trying to install MySQL 5.0.24a RHEL RPM on a Centos Linux VPS box.

"uname -a" output on this box:

Linux my.host.com 2.6.9-022stab078.14-enterprise #1 SMP Wed Jul 19 14:35:02
MSD 2006 i686 athlon i386 GNU/Linux

It already has MySQL 4.1 RHEL installed on it - I checked this with "rpm -q
mysql", which shows:

 mysql-4.1.20-1.RHEL4.1

The 4.1 install came by with the box, probably (not sure but maybe able to
find out from the previous administrator or the hosting provider).

I don't want to uninstall the 4.1 if I can help it. Reason: though I'm
fairly comfortable
with Linux software installations in general, I haven't installed MySQL
before, and so not sure of all the files that get installed, and their
locations, particularly into other directories than the base installation
directory (e.g. there is a file called my.cnf in /etc). So not sure if all
the files installed with 4.1 will be properly removed if I uninstall 4.1,
and if they don't, it may create conflicts; e.g. some config file of
4.1might get used when I try to run
5.0 after installing it, and this might lead to strange errors.

So I want to install MySQL 5.0 into a different location.
That is why I used the --prefix option in the install command that I used:

rpm --install --test --hash --verbose --prefix /root/mysql5.0rhel4
MySQL-server-standard-5.0.24a-0.rhel4.i386.rpm

When I run the above command (as root), I get this error message:

warning: MySQL-server-standard-5.0.24a-0.rhel4.i386.rpm: V3 DSA signature:
NOKEY, key ID 5072e1f5
error: package MySQL-server-standard is not relocatable

Does this mean that this RPM can only be installed in the standard/default
location?
Is there any way or any other kind of package (e.g. not an RPM but a tar.gz)
that will work - for the binary package, I mean - such that it will allow me
to install MySQL into some base location (directory) specified by me?
Otherwise I can install MySQL from the source tarball which I've already
downloaded, but thought to avoid that route if possible, as I suspect it
might take some time (not sure). This is because I just previously installed
the GNU C++ compiler (g++) on the box, which I had to do because I had tried
to install MySQL from the source tarball earlier and got a message "C++
compiler fails sanity check", and Googling for that message, indicated that
the C++ compiler was not installed on the system - my guess is that the C++
compiler is not there by default on the box because it is a VPS, so they
want to minimize the disk space used by default. So I downloaded and
installed the g++ compiler. It worked ok - I wrote a short C++ test program,
could compile and run it.

So the reason I want to avoid installing MySQL from source, is because the
C++ compiler build+install, took a good amount of time, over 3.5 hours,
probably because it compiles hundreds of small source files, and so does a
lot of file I/O, and my client doesn't want to spend a lot of time on the
install (the project is on a tight schedule).

Thanks for any help or pointers.

Vasudev Ram
http://www.dancingbison.com
10.times say "Truly rural"

Re: installing mysql

[Colin Charles]

jagdish gunjal wrote:

i m upgrading mysql from 3.23 to 4.1.8.
   
  there was packge conflict for so many files like /etc/my.cnf

  Also i installed shared-compat for removing such problems.
   
   
  Is there any solution?


Can you provide us with more about your environment?

Also, have you read the 3-4 MySQL upgrade guide in our excellent 
documentation?


best regards,
--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528
Mobile: +614 12 593 292 / Skype: colincharles

MySQL Forge: http://forge.mysql.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

[David Lazo]

I still get the same error.  Not sure what I'm doing wrong.





On 8/25/06 5:49 PM, "Greg Joss" <[EMAIL PROTECTED]> wrote:

> Go to Control Panel>System>Advanced. Click Environmental Variables and Find
> the PATH variable under System Variables and add the full path, i.e.
> c:\Program Files\...\mysql\bin to the variable.
> 
> -Original Message-
> From: David Lazo [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 25, 2006 2:54 PM
> To: mysql@lists.mysql.com
> Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition
> 
> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
> Component
> 
>This application has failed to start because LIBMYSQL.dll was not found.
> Re-installing the application may fix this problem
> 
> I have tried to re-install, but I get the same message.
> 
> I read the following related threads but didn't help.
> http://lists.mysql.com/win32/14799
> 
> http://lists.mysql.com/mysql/167676
> 
> 
> I looked for the file and it exists in:
> /mysql/bin/
> /mysql/lib/debug/
> /mysql/lib/opt/
> 
> This is the download I'm using for the installation:
> Windows Server 2003 (AMD64 / Intel EM64T)5.0.24
> 
> Please advise.
> 
> 
> David.
> 
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL on Windows Server 2003 Standard x64 Edition

[Greg Joss]

Go to Control Panel>System>Advanced. Click Environmental Variables and Find
the PATH variable under System Variables and add the full path, i.e.
c:\Program Files\...\mysql\bin to the variable.

-Original Message-
From: David Lazo [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 25, 2006 2:54 PM
To: mysql@lists.mysql.com
Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition

I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
Component

   This application has failed to start because LIBMYSQL.dll was not found.
Re-installing the application may fix this problem

I have tried to re-install, but I get the same message.

I read the following related threads but didn't help.
http://lists.mysql.com/win32/14799

http://lists.mysql.com/mysql/167676


I looked for the file and it exists in:
/mysql/bin/
/mysql/lib/debug/
/mysql/lib/opt/

This is the download I'm using for the installation:
Windows Server 2003 (AMD64 / Intel EM64T)5.0.24

Please advise.


David.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

[obed]

On 8/25/06, David Lazo <[EMAIL PROTECTED]> wrote:

I didn't add it anywhere because the file exists in mysql/bin folder

c:/program files/mysql/bin

Does it need to be somewhere else??


mm.. i don't know, you tell us !!!  try it. !!!

--

http://www.obed.org.mx ---> blog

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

[David Lazo]

I didn't add it anywhere because the file exists in mysql/bin folder

c:/program files/mysql/bin

Does it need to be somewhere else??


On 8/25/06 5:03 PM, "João Cândido de Souza Neto"
<[EMAIL PROTECTED]> wrote:

> It could seems stupid, but you tried to put this file on c:\windows\system32
> or the similar folder of your system?
> 
> "David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem
> news:[EMAIL PROTECTED]
>> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
>> Component
>> 
>>   This application has failed to start because LIBMYSQL.dll was not found.
>> Re-installing the application may fix this problem
>> 
>> I have tried to re-install, but I get the same message.
>> 
>> I read the following related threads but didn't help.
>> http://lists.mysql.com/win32/14799
>> 
>> http://lists.mysql.com/mysql/167676
>> 
>> 
>> I looked for the file and it exists in:
>> /mysql/bin/
>> /mysql/lib/debug/
>> /mysql/lib/opt/
>> 
>> This is the download I'm using for the installation:
>> Windows Server 2003 (AMD64 / Intel EM64T)5.0.24
>> 
>> Please advise.
>> 
>> 
>> David.
>> 
>> 
> 
> 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL on Windows Server 2003 Standard x64 Edition

[Jo�o C�ndido de Souza Neto]

It could seems stupid, but you tried to put this file on c:\windows\system32 
or the similar folder of your system?

"David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem 
news:[EMAIL PROTECTED]
> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
> Component
>
>   This application has failed to start because LIBMYSQL.dll was not found.
> Re-installing the application may fix this problem
>
> I have tried to re-install, but I get the same message.
>
> I read the following related threads but didn't help.
> http://lists.mysql.com/win32/14799
>
> http://lists.mysql.com/mysql/167676
>
>
> I looked for the file and it exists in:
> /mysql/bin/
> /mysql/lib/debug/
> /mysql/lib/opt/
>
> This is the download I'm using for the installation:
> Windows Server 2003 (AMD64 / Intel EM64T)5.0.24
>
> Please advise.
>
>
> David.
>
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL on Windows Server 2003 Standard x64 Edition

[David Lazo]

I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
Component

   This application has failed to start because LIBMYSQL.dll was not found.
Re-installing the application may fix this problem

I have tried to re-install, but I get the same message.

I read the following related threads but didn't help.
http://lists.mysql.com/win32/14799

http://lists.mysql.com/mysql/167676


I looked for the file and it exists in:
/mysql/bin/
/mysql/lib/debug/
/mysql/lib/opt/

This is the download I'm using for the installation:
Windows Server 2003 (AMD64 / Intel EM64T)5.0.24

Please advise.


David.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

installing mysql

[jagdish gunjal]

i m upgrading mysql from 3.23 to 4.1.8.
   
  there was packge conflict for so many files like /etc/my.cnf
  Also i installed shared-compat for removing such problems.
   
   
  Is there any solution?
   


Regards
  Jagdish
  
   " Everyone has beauty but not everyone sees it." 








-
 Here’s a new way to find what you're looking for - Yahoo! Answers 

Re: Problem installing mysql on Debian linux

[Tselemegkos Grigorios]

Thanks for the reply Sam,  :-)

I'm using Debian 3.1
I thought that termcap libraries where into ndevel package, which i
installed.
Where can i find the termcap libraries.
Do i have to do something special in the configure of termcap or mysql?
I need a version of mysql < 4.1.0 because i need to install CDSware (it has
problems with earlier versions)
Does mysql 5.0.18 compile without termcap libraries installed?

Gregory




- Original Message - 
From: "Sam Tran" <[EMAIL PROTECTED]>

To: "Tselemegkos Grigorios" <[EMAIL PROTECTED]>
Cc: 
Sent: Saturday, February 25, 2006 9:34 PM
Subject: Re: Problem installing mysql on Debian linux


On 2/25/06, Tselemegkos Grigorios <[EMAIL PROTECTED]> wrote:

Hi,

I'm trying to install mysql 4.0.25 from source on Debian linux without
root privileges.
The problem comes when i execute the configure command.
I typed:
configure --prefix /home/grtsel/mysql

and the output error was:

checking for FIONREAD in sys/ioctl.h... yes
checking for TIOCSTAT in sys/ioctl.h... no
checking if struct dirent has a d_ino member... yes
checking whether signal handlers are of type void... yes
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No
curses/termcap library found

I installed ncurses package from source in order to bypass this problem
but nothing happend...

Does anyone know what's going wrong..?
Please help me...



Gregory,

You need to install the termcap libraries.
What version of Debian are you using? Why don't you install MySQL 5.0.18?

Sam

__
Χρησιμοποιείτε Yahoo!;
Βαρεθήκατε τα ενοχλητικά μηνύματα (spam);   Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων  
http://mail.yahoo.gr 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem installing mysql on Debian linux

[Sam Tran]

On 2/25/06, Tselemegkos Grigorios <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to install mysql 4.0.25 from source on Debian linux without root 
> privileges.
> The problem comes when i execute the configure command.
> I typed:
> configure --prefix /home/grtsel/mysql
>
> and the output error was:
>
> checking for FIONREAD in sys/ioctl.h... yes
> checking for TIOCSTAT in sys/ioctl.h... no
> checking if struct dirent has a d_ino member... yes
> checking whether signal handlers are of type void... yes
> checking for tgetent in -lncurses... no
> checking for tgetent in -lcurses... no
> checking for tgetent in -ltermcap... no
> checking for termcap functions library... configure: error: No curses/termcap 
> library found
>
> I installed ncurses package from source in order to bypass this problem but 
> nothing happend...
>
> Does anyone know what's going wrong..?
> Please help me...
>

Gregory,

You need to install the termcap libraries.
What version of Debian are you using? Why don't you install MySQL 5.0.18?

Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem installing mysql on Debian linux

[Tselemegkos Grigorios]

Hi,

I'm trying to install mysql 4.0.25 from source on Debian linux without root 
privileges.
The problem comes when i execute the configure command.
I typed:
configure --prefix /home/grtsel/mysql

and the output error was:

checking for FIONREAD in sys/ioctl.h... yes
checking for TIOCSTAT in sys/ioctl.h... no
checking if struct dirent has a d_ino member... yes
checking whether signal handlers are of type void... yes
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No curses/termcap 
library found

I installed ncurses package from source in order to bypass this problem but 
nothing happend...

Does anyone know what's going wrong..?
Please help me...

Gregory

Re: installing mysql in a chroot jail.

[Gleb Paharenko]

Hello.

Search in archives at http://lists.mysql.com/mysql. There is at least
one interesting for you thread:
  http://lists.mysql.com/mysql/192066


Gregory Machin wrote:
> Hi
> I have fc4 and would like to install / upgrade to mysql 5. When i try via
> yum using fedore-devel.repo it wants to update most of my system because of
> dependencies  So I though why not install mysql5 in a charoot jail thus
> leaving my os intacted and allowing me to do testing on both version (using
> different ports). But I havnt a clue how to create a chroot and install
> mysql into it ... Any idea how I would go about this ?
> 
> --
> Gregory Machin
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> www.linuxpro.co.za
> www.exponent.co.za
> Web Hosting Solutions
> Scalable Linux Solutions
> www.iberry.info (support and admin)
> 
> +27 72 524 8096


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

installing mysql in a chroot jail.

[Gregory Machin]

Hi
I have fc4 and would like to install / upgrade to mysql 5. When i try via
yum using fedore-devel.repo it wants to update most of my system because of
dependencies  So I though why not install mysql5 in a charoot jail thus
leaving my os intacted and allowing me to do testing on both version (using
different ports). But I havnt a clue how to create a chroot and install
mysql into it ... Any idea how I would go about this ?

--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

+27 72 524 8096

Re: Problem installing MySQL 5.0

[Francesco Vincenti]

Hello Chander,
thank you very much.
I tried to do in your way ad the installation works!
I downloaded the perl(DBI) .rpm and I installed it the first time using the
command:

rpm -Uvh perl-DBI-1.50-1.i386.rpm

but I got back an error about one glibc library not founded, so I use this
format:

rpm -Uvh --nodeps perl-DBI-1.50-1.i386.rpm

and the installation finished without problems.
Then, I installed both MySQL-server-standard-5.0.18-0 .rhel3.i386.rpm, with
which I have had the problem, and
MySQL-client-standard-5.0.18-0.rhel3.i386.rpm and all went in the right way.
Greetings
Francesco Vincenti

Re: Problem installing MySQL 5.0

[Chander Ganesan]

You can force the installation (--nodeps) when installing the RPM package.

Even if you build DBI (and not install it from RPM) it won't be in the 
RPM database, and you'll get the same error.


You should be able to get a FC2 RPM for the DBI module - download that 
RPM and install it, then install MySQL - that would be the easiest 
course of action...


--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com




Francesco Vincenti wrote:


Hello everybody,
This is the first time I try to install MySQL 5.0, I think I followed the
steps showed by the documentation in the right way, but when I run the
command:

rpm -i MySQL-server-Version-.i386.rpm

I get back the error:

error: Failed dependencies:
   perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3

I am trying to install MySQL on this platform:
- CPU:AMD Athlon 800 Mhz
- Operating System: Linux Fedora core 2, release 2.6.5-1.358

The packages I have downloaded are:
- MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
- MySQL-client-standard-5.0.18-0.rhel3.i386.rpm

After the error, I found a few information on internet about perl(DBI), so I
downloaded it  and  installed it on my system.
The test step (make test) ended with error 355 (??), but I run anyway "make
install" which ended without problems, I think.
At this point I do not know what to do, so I need your help to solve this
problem.
Greetings
Francesco Vincenti

*
*

 




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem installing MySQL 5.0

[Francesco Vincenti]

Hello everybody,
This is the first time I try to install MySQL 5.0, I think I followed the
steps showed by the documentation in the right way, but when I run the
command:

rpm -i MySQL-server-Version-.i386.rpm

I get back the error:

error: Failed dependencies:
perl(DBI) is needed by MySQL-server-standard-5.0.18-0.rhel3

I am trying to install MySQL on this platform:
- CPU:AMD Athlon 800 Mhz
- Operating System: Linux Fedora core 2, release 2.6.5-1.358

The packages I have downloaded are:
- MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
- MySQL-client-standard-5.0.18-0.rhel3.i386.rpm

After the error, I found a few information on internet about perl(DBI), so I
downloaded it  and  installed it on my system.
The test step (make test) ended with error 355 (??), but I run anyway "make
install" which ended without problems, I think.
At this point I do not know what to do, so I need your help to solve this
problem.
Greetings
Francesco Vincenti

*
*

Re: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8

[Pooly]

2005/12/22, John Galatti <[EMAIL PROTECTED]>:
> All
> I am trying to build the mysql 5.0 from the source
> When I run the configure scripts it error out saying it can not find termcap  
> data base  also, can not find tegenent  in any library
> I am running under debian linux 2.8

you mean Debian with a linux kernel 2.6.8 ? then you're running sarge.
Did you install the dev packages ?
apt-get install termcap-dev

--
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8

[Gleb Paharenko]

Hello.



Are you sure that configure is saying that it is unable

to find 'termcap data base'? I haven't seen this message

inside the configure script. May be it is looking for termcap

library? In this case, you should install some termcap development

package for Debian (I not a Debian user, so I don't know exacty which

package you need). BTW, why don't you want to use official binaries?









>All

>I am trying to build the mysql 5.0 from the source

>When I run the configure scripts it error out saying it can not find

>termcap  data base

>also, can not find tegenent  in any library

>I am running under debian linux 2.8

>Does any one have nay idea on what I should do

John Galatti wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8

[John Trammell]

There is no such thing as Debian 2.8--see
http://www.us.debian.org/releases/. 

> -Original Message-
> From: John Galatti [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 22, 2005 8:53 AM
> To: mysqlList
> Subject: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8
> 
> All
> I am trying to build the mysql 5.0 from the source
> When I run the configure scripts it error out saying it can 
> not find termcap  data base  also, can not find tegenent  in 
> any library
> I am running under debian linux 2.8   
> Does any one have nay idea on what I should do
> 
> John
> 


INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE 
PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you 
are not an intended recipient of this message, or an agent responsible for 
delivering it to an intended recipient, you are hereby notified that you have 
received this message in error, and that any review, dissemination, 
distribution, or copying of this message is strictly prohibited. If you 
received this message in error, please notify the sender immediately, delete 
the message, and return any hard copy print-outs.

This message has been scanned for viruses by McAfee's Groupshield.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8

[John Galatti]

All
I am trying to build the mysql 5.0 from the source
When I run the configure scripts it error out saying it can not find termcap  
data base  also, can not find tegenent  in any library
I am running under debian linux 2.8   
Does any one have nay idea on what I should do

John

Re: Problem installing MySQL on Mac OSX 10.4.3

[Brent Baisley]

Those message are kind of odd, even on a messed up system. I would  
first run the repair privileges in the disk utility for good measure,  
then delete all traces of MySQL and just start over. MySQL should be  
in /usr/local/mysql. To remove it just type:

sudo rm -R /usr/local/mysql

Then try installing again. If you are running OSX Server, things may  
be a little different. Apple puts MySQL files in different places on  
there server install as I recall. You may need to poke around a bit  
to find them. Check /usr/local and also /etc


On Dec 2, 2005, at 5:26 PM, Ton Kuypers wrote:


Hi,

I've downloaded the "mysql-max-4.1.15-apple-darwin8.2.0- 
powerpc.dmg" and tried to install it, but I keep on getting the  
error "You cannot continue. There is nothing to install".
I've also tried the "mysql-max-5.0.16-osx10.4-powerpc.dmg" and the  
"mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg", all give the  
same result...


Can anyone help me? I think the previous person using this Mac  
screwed up some things, I've found traces of mySQL on the system,  
but I cannot find anything usable anymore.


Any help is welcome!


warm regards,


Ton Kuypers
Digital Media Partners bvba
Tel. +32 (0)477 / 739 530
Fax +32 (0)14 / 71 03 04
http://www.dmp-int.com





--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem installing MySQL on Mac OSX 10.4.3

[Ton Kuypers]

Hi,

I've downloaded the "mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg"  
and tried to install it, but I keep on getting the error "You cannot  
continue. There is nothing to install".
I've also tried the "mysql-max-5.0.16-osx10.4-powerpc.dmg" and the  
"mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg", all give the  
same result...


Can anyone help me? I think the previous person using this Mac  
screwed up some things, I've found traces of mySQL on the system, but  
I cannot find anything usable anymore.


Any help is welcome!


warm regards,


Ton Kuypers
Digital Media Partners bvba
Tel. +32 (0)477 / 739 530
Fax +32 (0)14 / 71 03 04
http://www.dmp-int.com

Re: Installing Mysql beta on Debian

[Gleb Paharenko]

Hello.



It is recommended to use precompiled binaries in most cases. MySQL

has a very flexible system of parameters which you could change through

different ways. If you want to use this server as dedicated database

server, probably the solution exists (I mean integrating MySQL binaries

without breaking apt's database). But if you want to use other programs

which requires MySQL shared libraries the problem becomes harder.







[EMAIL PROTECTED] wrote:

> Hi,

> 

> I've been successfully using mysql 5.0.x on my win32 development machine.

> 

> I would like to install it on a server running stable Debian. Unfortunately,

> there are no .deb packages for the MySQL 5.0 series.

> 

> I have tried to use the linux precompiled binaries but my debian complains 
> about

> not being able to connect using "/var/run/.../mysqld.sock" and the

> "/etc/init.d/mysql start" script will tell me something went wrong.

> I have accidentally deleted "/etc/mysql/debian-start" and replaced it with an

> empty file :(.

> 

> Now, what I would like to do is to either

> 1) use the precompiled binaries without breaking apt's database (ie 
> overwriting

> the files that already exist) and using canonical debian path conventions.

> 2) compile by myself, but I *really* need some help with all the options

> ./configure provides, in order, again, to use the debian patch conventions.

> 

> thanks in advance,

> Phil

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing Mysql beta on Debian

[hameau . phil]

Hi,

I've been successfully using mysql 5.0.x on my win32 development machine.

I would like to install it on a server running stable Debian. Unfortunately,
there are no .deb packages for the MySQL 5.0 series.

I have tried to use the linux precompiled binaries but my debian complains about
not being able to connect using "/var/run/.../mysqld.sock" and the
"/etc/init.d/mysql start" script will tell me something went wrong.
I have accidentally deleted "/etc/mysql/debian-start" and replaced it with an
empty file :(.

Now, what I would like to do is to either
1) use the precompiled binaries without breaking apt's database (ie overwriting
the files that already exist) and using canonical debian path conventions.
2) compile by myself, but I *really* need some help with all the options
./configure provides, in order, again, to use the debian patch conventions.

thanks in advance,
Phil

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL 4.1.12 on Mandrake 10.1

[Gleb Paharenko]

Hello.



>My questions are: Is there other files besides just the server 
> and

>the client

>that I would need to install to get MySQL to work on Mandrake

>v10.1?  



Your data directory should contain mysql database prepared with

mysql_install_db script. See:



  http://dev.mysql.com/doc/mysql/en/unix-post-installation.html



>   Are there other issues with 4.1.12 that I have not 
> fully explored

>   that might

>   prevent this from being installed? 



In your case - no.



>

>Finally if I upgraded this system to 4.1.12 now that 
> 4.0.20 is

>installed

>would I wind up having the same problems? 

> 





You should read:



  http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html



But I suggest you to remove all mysql instances from you box and perform

a clean install of 4.1.12 using official binaries.









> I have a new test Linux server with Mandrake 10.1 installed that I was

> trying

> to install MySQL version 4.1.12 on today.

>  

>   Once I had installed the software, whenever I tried to start MySQL on

>   this

>   server I was getting the error message "[ERROR] Fatal error: Can't

>   open

>   privilege tables: Table 'mysql.host' doesn't exist" when I tried to

>   run the

>   'mysql_setpermissions' script and was getting the same result. 

>

>After this failed I decided to try the MySQL installation files that

>came

>with the operating system which were Version 4.0.20 and this version

>worked

>fine. 

> 

>   When I was installing the 4.1.12 version I was simply going 
> with a

>   minimal

>   install of just the server package and the clients. When I ran 
> the

>   installation package from Mandrake it installed other files that

>   from my

>   reading of the MySQL manual I did not think that I needed. 

>

>My questions are: Is there other files besides just the server 
> and

>the client

>that I would need to install to get MySQL to work on Mandrake

>v10.1?  

> 

>   Are there other issues with 4.1.12 that I have not 
> fully explored

>   that might

>   prevent this from being installed? 

>

>Finally if I upgraded this system to 4.1.12 now that 
> 4.0.20 is

>installed

>would I wind up having the same problems? 

> 

>

>"Eric Lommatsch" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL 4.1.12 on Mandrake 10.1

[Eric Lommatsch]

Hello List,
 
I have a new test Linux server with Mandrake 10.1 installed that I was trying
to install MySQL version 4.1.12 on today.
 
Once I had installed the software, whenever I tried to start MySQL on this
server I was getting the error message "[ERROR] Fatal error: Can't open
privilege tables: Table 'mysql.host' doesn't exist" when I tried to run the
'mysql_setpermissions' script and was getting the same result. 
 
After this failed I decided to try the MySQL installation files that came
with the operating system which were Version 4.0.20 and this version worked
fine. 
 
When I was installing the 4.1.12 version I was simply going with a minimal
install of just the server package and the clients. When I ran the
installation package from Mandrake it installed other files that from my
reading of the MySQL manual I did not think that I needed. 
 
My questions are: Is there other files besides just the server and the client
that I would need to install to get MySQL to work on Mandrake v10.1?  
 
Are there other issues with 4.1.12 that I have not fully explored that might
prevent this from being installed? 
 
Finally if I upgraded this system to 4.1.12 now that 4.0.20 is installed
would I wind up having the same problems? 
 
Thank you
 
Eric H. Lommatsch
Programmer
MICRONix, Inc.
2087 South Grant Street
Denver, CO 80210
Tel 303-777-8939
Fax 303-778-0378
 
[EMAIL PROTECTED]
 

RE: Problems installing MySQL 4.1 under Fedora Core 3

[John Schmidt]

I am pretty sure hat is due to the SELinux policy being set to restrictive. For 
the brute force fix try editing /etc/selinux/config and set the variable 
SELINUX=Permissive. There is a more subtle approach that maintains beeter 
security explained under the SELinux topic in the Fedora doc, sorry I don't 
have the link handy. Basically you can realx the policy via the "targetted" 
settings. 
Good luck
//jjs
  


-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Wed 4/13/2005 10:56 PM
To: mysql@lists.mysql.com
Subject: Problems installing MySQL 4.1 under Fedora Core 3
 
I have a Pentium III with Fedora Core 3 notebook and I need to install 
MySQL 4.1 on it.
There was no mysql installed before so I've downloaded the packages and 
did what I usually do to install
the packages. They install great. But when I try to run MySQL I have 
problems as it does not run.
It tries for a while and then quits.

I am using the 4.1.11-0.i386 version.

I have checked the persmissions under /var/lib/mysql and they were user 
mysql group root. So I've changed to
the MySQL group by using chgrp -R mysql /var/lib/mysql

I've created an /etc/my.cnf file by copying the standard 
/usr/share/doc/packages/MySQL-server/my-medium.cnf

It still does not work.

My /var/log/messages file shows the following:

Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.267:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.269:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:54:10 presario2700 lsb_log_message:  failed

I have no idea what might be wrong.

Can anyone help me out?

Thanks in advance!



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems installing MySQL 4.1 under Fedora Core 3

[C.F. Scheidecker Antunes]

I have a Pentium III with Fedora Core 3 notebook and I need to install 
MySQL 4.1 on it.
There was no mysql installed before so I've downloaded the packages and 
did what I usually do to install
the packages. They install great. But when I try to run MySQL I have 
problems as it does not run.
It tries for a while and then quits.

I am using the 4.1.11-0.i386 version.
I have checked the persmissions under /var/lib/mysql and they were user 
mysql group root. So I've changed to
the MySQL group by using chgrp -R mysql /var/lib/mysql

I've created an /etc/my.cnf file by copying the standard 
/usr/share/doc/packages/MySQL-server/my-medium.cnf

It still does not work.
My /var/log/messages file shows the following:
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.267:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.269:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:54:10 presario2700 lsb_log_message:  failed

I have no idea what might be wrong.
Can anyone help me out?
Thanks in advance!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re : Problems installing MySQL 4.1 under Fedora Core 3

[C.F. Scheidecker Antunes]

It only shows this:
050413  23:53:35 mysqld started
050413  23:53:35 mysqld ended
Nothing conclusive.
prasanna a wrote:
Hi
please cat the below error file and see 
/var/lib/mysql/presario2700.err

		
__ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search. 
http://info.mail.yahoo.com/mail_250

 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems installing MySQL 4.1 under Fedora Core 3

[C.F. Scheidecker Antunes]

I have a Pentium III with Fedora Core 3 notebook and I need to install 
MySQL 4.1 on it.
There was no mysql installed before so I've downloaded the packages and 
did what I usually do to install
the packages. They install great. But when I try to run MySQL I have 
problems as it does not run.
It tries for a while and then quits.

I am using the 4.1.11-0.i386 version.
I have checked the persmissions under /var/lib/mysql and they were user 
mysql group root. So I've changed to
the MySQL group by using chgrp -R mysql /var/lib/mysql

I've created an /etc/my.cnf file by copying the standard 
/usr/share/doc/packages/MySQL-server/my-medium.cnf

It still does not work.
My /var/log/messages file shows the following:
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.252:0): avc:  
denied  { append } for  pid=5693 exe=/usr/sbin/mysqld 
path=/var/lib/mysql/presario2700.err dev=hda5 ino=653099 
scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.267:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:53:35 presario2700 kernel: audit(1113458015.269:0): avc:  
denied  { write } for  pid=5693 exe=/usr/sbin/mysqld name=mysql dev=hda5 
ino=653096 scontext=root:system_r:mysqld_t 
tcontext=root:object_r:var_lib_t tclass=dir
Apr 13 23:54:10 presario2700 lsb_log_message:  failed

I have no idea what might be wrong.
Can anyone help me out?
Thanks in advance!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[Gleb Paharenko]

Hello.



>050314  1:31:06 /usr/sbin/mysqld-max: Shutdown Complete



Your error file has this record. And you said that you'd installed

only:

  >>>>> - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm

  >>>>> - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm



There are no mysqld-max in listed rpms. I suggest you to check your

installation. May be you should remove already installed instances

of MySQL and try to install it again. You could also install the 

server using binary distribution.







"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:

> I do not know what else to do at this point. I even messed with 

> permissions but I realized it is not the problem.

> 

> 

> Jeff Steinkamp wrote:

> 

>> Yes, and it look pretty much like yours.  Form what I can tell, the 

>> daemon is never started during the init cycle, or actually aborts for 

>> some reason.  Since my machine is a dual boot, Winders and Linux, and 

>> I am running a test project on the Winders machine, it will be later 

>> this weekend before I can get back to the Linux box and putter around 

>> further.

>>

>>

>> Jeff Steinkamp - N7YG

>> Tucson, AZ

>> SCUD Missile Coordinates

>> N32-13-52 W110-52-15

>> http://home.earthlink.net/~jksteinkamp

>> http://n7yg.webhop.org

>> ___

>> Nothing is foolproof to a sufficiently talented fool.

>>

>> - Original Message - From: "C.F. Scheidecker Antunes" 

>> <[EMAIL PROTECTED]>

>> To: "Jeff Steinkamp" <[EMAIL PROTECTED]>

>> Sent: Monday, March 14, 2005 10:52

>> Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

>>

>>

>>> Jeff,

>>>

>>> I am in SLC Utah.

>>> Do you have your /var/log/mysqld.log file? I've put mine on the list 

>>> so that anyone can see it.

>>>

>>> thanks,

>>>

>>> C.F.

>>>

>>> Jeff Steinkamp wrote:

>>>

>>>> I've had the same problem and for the last month I've not been able 

>>>> to get the mysqld to run.  Tried a number of things I've found on 

>>>> the net and nothing works.  If you get a solution, I will be 

>>>> interested.

>>>>

>>>>

>>>> Jeff Steinkamp - N7YG

>>>> Tucson, AZ

>>>> SCUD Missile Coordinates

>>>> N32-13-52 W110-52-15

>>>> http://home.earthlink.net/~jksteinkamp

>>>> http://n7yg.webhop.org

>>>> ___

>>>> At 18, I was ashamed of how ignorant my father was. At 21, I was 

>>>> amazed at how much he had learned in three years.

>>>>

>>>> - Original Message - From: "C.F. Scheidecker Antunes" 

>>>> <[EMAIL PROTECTED]>

>>>> To: 

>>>> Sent: Sunday, March 13, 2005 21:28

>>>> Subject: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

>>>>

>>>>

>>>>> Hello,

>>>>>

>>>>> I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp

>>>>>

>>>>> It is a dual Xenon PIII server.

>>>>>

>>>>> I am trying to install MySQL 4.0.24 as I usually do:

>>>>>

>>>>> - There are no other mysql servers present, no 3.x as I did not 

>>>>> install it.

>>>>>

>>>>> - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm

>>>>> - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm

>>>>> It installs the server

>>>>>

>>>>>

>>>>> Then I try to run MySQL but it does not run. Instead I have a .err 

>>>>> file under /var/lib/mysql  saying mysqld started and mysqld ended.

>>>>>

>>>>> I have done so many MySQL installs before and so I cannot 

>>>>> understand why I cannot install it now on this server.

>>>>> The tables are not created not even if I run mysql_install_db.

>>>>>

>>>>> Is there any dependency that is missing? Any necessary library?

>>>>>

>>>>> Any ideas?

>>>>>

>>>>> Thank you,

>>>>>

>>>>> C.F.

>>>>>

>>>>> 

-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[C.F. Scheidecker Antunes]

I do not know what else to do at this point. I even messed with 
permissions but I realized it is not the problem.

Jeff Steinkamp wrote:
Yes, and it look pretty much like yours.  Form what I can tell, the 
daemon is never started during the init cycle, or actually aborts for 
some reason.  Since my machine is a dual boot, Winders and Linux, and 
I am running a test project on the Winders machine, it will be later 
this weekend before I can get back to the Linux box and putter around 
further.

Jeff Steinkamp - N7YG
Tucson, AZ
SCUD Missile Coordinates
N32-13-52 W110-52-15
http://home.earthlink.net/~jksteinkamp
http://n7yg.webhop.org
___
Nothing is foolproof to a sufficiently talented fool.
- Original Message - From: "C.F. Scheidecker Antunes" 
<[EMAIL PROTECTED]>
To: "Jeff Steinkamp" <[EMAIL PROTECTED]>
Sent: Monday, March 14, 2005 10:52
Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box


Jeff,
I am in SLC Utah.
Do you have your /var/log/mysqld.log file? I've put mine on the list 
so that anyone can see it.

thanks,
C.F.
Jeff Steinkamp wrote:
I've had the same problem and for the last month I've not been able 
to get the mysqld to run.  Tried a number of things I've found on 
the net and nothing works.  If you get a solution, I will be 
interested.

Jeff Steinkamp - N7YG
Tucson, AZ
SCUD Missile Coordinates
N32-13-52 W110-52-15
http://home.earthlink.net/~jksteinkamp
http://n7yg.webhop.org
___
At 18, I was ashamed of how ignorant my father was. At 21, I was 
amazed at how much he had learned in three years.

- Original Message - From: "C.F. Scheidecker Antunes" 
<[EMAIL PROTECTED]>
To: 
Sent: Sunday, March 13, 2005 21:28
Subject: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box


Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not 
install it.

- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err 
file under /var/lib/mysql  saying mysqld started and mysqld ended.

I have done so many MySQL installs before and so I cannot 
understand why I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.

Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[C.F. Scheidecker Antunes]

Hi Bob,
Yes the ownership is correct. In fact I did a chmod -R mysql:mysql 
/var/lib/mysql and I still have the same problem.
I wonder if it is because I am running a dual processor machine.

Robert A. Rawlinson wrote:
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried 
/etc/rc.d/init.d/mysql start

Funny thing is that after install the the mysql and test databases 
are empty so I've tried mysql_install_db which runs but the databases 
remains empty as well.

It is weird. I've done so many MySQL installations under Linux and 
they are usually so smoth. Any version I try to install on this 
machine such as 4.0.24 and 4.0.20 is not successful.
So I believe that there must be a missing library on this machine. It 
is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid 
system. It is running a smp kernel

2.6.10-1.770_FC3smp
I am attaching the files for you.
As you can see it only has the process number and that it started and 
ended right away.
Again, the base mysql database cannot be created. So I wonder, is 
there any app missing?

If I still FC3 full I can get it running if I remove the original 
series 3.x and put 4.x
Then if I still a clean FC3 and try 4.0 it does not work. Any clues?

The attached file is myhost.err under /var/lib/mysql that I've 
renamed to mysql.log

mysqld.log is under /var/log/  and it has the errors
Thank you in advance,
C.F.

Gleb Paharenko wrote:
Hello.
 

under /var/lib/mysql  saying mysqld started and mysqld ended.
  

It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
 

The tables are not created not even if I run mysql_install_db.
  

According to the manual they should be installed automatically,
when you're using RPM distribution.
How do you start the MySQL server?
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
 

Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not 
install it.

- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err 
file under /var/lib/mysql  saying mysqld started and mysqld ended.

I have done so many MySQL installs before and so I cannot 
understand why I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.

Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
  


 


050314 02:22:28  mysqld started
050314 02:22:28  mysqld ended
050314 02:27:47  mysqld started
050314 02:27:47  mysqld ended
050314 02:28:00  mysqld started
050314 02:28:00  mysqld ended
 


050314 01:30:52  mysqld started
050314 01:30:52  mysqld ended
050314 01:30:58  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050314  1:30:58  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile0 did not exist: new to 
be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile1 did not exist: new to 
be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050314  1:31:02  InnoDB: Started
050314  1:31:02 Fatal error: Can't open privilege tables: Table 
'mysql.host' doesn't exist
050314  1:31:02 Aborting

050314  1:31:02  InnoDB: Starting shutdown...
050314  1:31:06  InnoDB: Shutdown completed
050314  1:31:06 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:31:06  mysqld ended
050314 01:31:32  mysqld started
050314  1:31:32  InnoDB: Started
050314  1:31:32 Fatal error: Can't open privilege tables: Table 
'mysql.host' doesn't exist
050314  1:31:32 Aborting

050314  1:31:32  InnoDB: Starting shutdown...
050314  1:31:35  InnoDB: Shutdown completed
050314  1:31:35 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:31:35  mysqld ended
050314 01:32:03  mysqld started
050314  1:32:03  InnoDB: Started
050314  1:32:03 Fatal error: Can't open privilege tables: Table 
'mysql.host' doesn't exist
050314  1:32:03 Aborting

050314  1:32:03  InnoDB: Starting shutdown...
050314  1:32:05  InnoDB: Shutdown completed
050314  1:32:05 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:32:05  mysqld ended
050314 01:32:41  mysqld started
050314  1:32:41  InnoDB: St

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[Robert A. Rawlinson]

C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried 
/etc/rc.d/init.d/mysql start

Funny thing is that after install the the mysql and test databases are 
empty so I've tried mysql_install_db which runs but the databases 
remains empty as well.

It is weird. I've done so many MySQL installations under Linux and 
they are usually so smoth. Any version I try to install on this 
machine such as 4.0.24 and 4.0.20 is not successful.
So I believe that there must be a missing library on this machine. It 
is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid 
system. It is running a smp kernel

2.6.10-1.770_FC3smp
I am attaching the files for you.
As you can see it only has the process number and that it started and 
ended right away.
Again, the base mysql database cannot be created. So I wonder, is 
there any app missing?

If I still FC3 full I can get it running if I remove the original 
series 3.x and put 4.x
Then if I still a clean FC3 and try 4.0 it does not work. Any clues?

The attached file is myhost.err under /var/lib/mysql that I've renamed 
to mysql.log

mysqld.log is under /var/log/  and it has the errors
Thank you in advance,
C.F.

Gleb Paharenko wrote:
Hello.
 

under /var/lib/mysql  saying mysqld started and mysqld ended.
  

It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
 

The tables are not created not even if I run mysql_install_db.
  

According to the manual they should be installed automatically,
when you're using RPM distribution.
How do you start the MySQL server?
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
 

Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not 
install it.

- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err 
file under /var/lib/mysql  saying mysqld started and mysqld ended.

I have done so many MySQL installs before and so I cannot understand 
why I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.

Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
  

 


050314 02:22:28  mysqld started
050314 02:22:28  mysqld ended
050314 02:27:47  mysqld started
050314 02:27:47  mysqld ended
050314 02:28:00  mysqld started
050314 02:28:00  mysqld ended
 


050314 01:30:52  mysqld started
050314 01:30:52  mysqld ended
050314 01:30:58  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050314  1:30:58  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050314  1:31:02  InnoDB: Started
050314  1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' 
doesn't exist
050314  1:31:02 Aborting
050314  1:31:02  InnoDB: Starting shutdown...
050314  1:31:06  InnoDB: Shutdown completed
050314  1:31:06 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:31:06  mysqld ended
050314 01:31:32  mysqld started
050314  1:31:32  InnoDB: Started
050314  1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' 
doesn't exist
050314  1:31:32 Aborting
050314  1:31:32  InnoDB: Starting shutdown...
050314  1:31:35  InnoDB: Shutdown completed
050314  1:31:35 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:31:35  mysqld ended
050314 01:32:03  mysqld started
050314  1:32:03  InnoDB: Started
050314  1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' 
doesn't exist
050314  1:32:03 Aborting
050314  1:32:03  InnoDB: Starting shutdown...
050314  1:32:05  InnoDB: Shutdown completed
050314  1:32:05 /usr/sbin/mysqld-max: Shutdown Complete
050314 01:32:05  mysqld ended
050314 01:32:41  mysqld started
050314  1:32:41  InnoDB: Started
050314  1:32:41 Fatal error: Can't open privilege tables: Table 'mysql.host' 
doesn't exist
050314  1:32:41 Aborting
050314  1:32:41  InnoDB: Starting shutdown...
050314  1:32:43  InnoDB: Shutdown completed
050314  1:32

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[gerald_clark]

C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried 
/etc/rc.d/init.d/mysql start

Funny thing is that after install the the mysql and test databases are 
empty so I've tried mysql_install_db which runs but the databases 
remains empty as well.

It is weird. I've done so many MySQL installations under Linux and 
they are usually so smoth. Any version I try to install on this 
machine such as 4.0.24 and 4.0.20 is not successful.
So I believe that there must be a missing library on this machine. It 
is a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid 
system. It is running a smp kernel

2.6.10-1.770_FC3smp
Fedora supplied RPMS initialize the database when you do a 'service 
mysqld start'
Have you done this?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[C.F. Scheidecker Antunes]

Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried 
/etc/rc.d/init.d/mysql start

Funny thing is that after install the the mysql and test databases are 
empty so I've tried mysql_install_db which runs but the databases 
remains empty as well.

It is weird. I've done so many MySQL installations under Linux and they 
are usually so smoth. Any version I try to install on this machine such 
as 4.0.24 and 4.0.20 is not successful.
So I believe that there must be a missing library on this machine. It is 
a dual PIII Xenon 500Mhz Compaq Server with 2GB of RAM and a Raid 
system. It is running a smp kernel

2.6.10-1.770_FC3smp
I am attaching the files for you.
As you can see it only has the process number and that it started and ended 
right away.
Again, the base mysql database cannot be created. So I wonder, is there any app 
missing?
If I still FC3 full I can get it running if I remove the original series 3.x 
and put 4.x
Then if I still a clean FC3 and try 4.0 it does not work. Any clues?
The attached file is myhost.err under /var/lib/mysql that I've renamed to 
mysql.log
mysqld.log is under /var/log/  and it has the errors
Thank you in advance,
C.F.

Gleb Paharenko wrote:
Hello.
 

under /var/lib/mysql  saying mysqld started and mysqld ended.
   

It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
 

The tables are not created not even if I run mysql_install_db.
   

According to the manual they should be installed automatically,
when you're using RPM distribution.
How do you start the MySQL server?
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
 

Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not install it.
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err file 
under /var/lib/mysql  saying mysqld started and mysqld ended.

I have done so many MySQL installs before and so I cannot understand why 
I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.

Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
   


 

050314 02:22:28  mysqld started
050314 02:22:28  mysqld ended

050314 02:27:47  mysqld started
050314 02:27:47  mysqld ended

050314 02:28:00  mysqld started
050314 02:28:00  mysqld ended

050314 01:30:52  mysqld started
050314 01:30:52  mysqld ended

050314 01:30:58  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050314  1:30:58  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050314  1:30:59  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050314  1:31:02  InnoDB: Started
050314  1:31:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050314  1:31:02 Aborting

050314  1:31:02  InnoDB: Starting shutdown...
050314  1:31:06  InnoDB: Shutdown completed
050314  1:31:06 /usr/sbin/mysqld-max: Shutdown Complete

050314 01:31:06  mysqld ended

050314 01:31:32  mysqld started
050314  1:31:32  InnoDB: Started
050314  1:31:32 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050314  1:31:32 Aborting

050314  1:31:32  InnoDB: Starting shutdown...
050314  1:31:35  InnoDB: Shutdown completed
050314  1:31:35 /usr/sbin/mysqld-max: Shutdown Complete

050314 01:31:35  mysqld ended

050314 01:32:03  mysqld started
050314  1:32:03  InnoDB: Started
050314  1:32:03 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050314  1:32:03 Aborting

050314  1:32:03  InnoDB: Starting shutdown...
050314  1:32:05  InnoDB: Shutdown completed
050314  1:32:05 /usr/sbin/mysqld-max: Shutdown Complete

050314 01:32:05  mysqld ended

050314 01:32:41  mysqld started
050314  1:32:41  InnoDB: Started
050314  1:32:41 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050314  1:32:41 Aborting

050314  1:32:41  InnoDB: Starting shutdown...
050314  1:32:43  InnoDB: Shutdown completed
050314  1:32:43 /usr/sbin/mysqld-max: Shutdown Complete

050314 01:32:43  mysqld ended

050314 01:32:58  mysqld started
050314  1:32:59  InnoDB: Started
050314  1:32:59 Fatal error: Ca

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[Gleb Paharenko]

Hello.



> under /var/lib/mysql  saying mysqld started and mysqld ended.



It is unusual behavior of MySQL to leave the error files without

clues. Please, send us the contents of this file.



> The tables are not created not even if I run mysql_install_db.



According to the manual they should be installed automatically,

when you're using RPM distribution.



How do you start the MySQL server?





"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:

> Hello,

> 

> I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp

> 

> It is a dual Xenon PIII server.

> 

> I am trying to install MySQL 4.0.24 as I usually do:

> 

> - There are no other mysql servers present, no 3.x as I did not install it.

> 

> - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm

> - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm

> It installs the server

> 

> 

> Then I try to run MySQL but it does not run. Instead I have a .err file 

> under /var/lib/mysql  saying mysqld started and mysqld ended.

> 

> I have done so many MySQL installs before and so I cannot understand why 

> I cannot install it now on this server.

> The tables are not created not even if I run mysql_install_db.

> 

> Is there any dependency that is missing? Any necessary library?

> 

> Any ideas?

> 

> Thank you,

> 

> C.F.

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

[C.F. Scheidecker Antunes]

Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not install it.
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm
It installs the server
Then I try to run MySQL but it does not run. Instead I have a .err file 
under /var/lib/mysql  saying mysqld started and mysqld ended.

I have done so many MySQL installs before and so I cannot understand why 
I cannot install it now on this server.
The tables are not created not even if I run mysql_install_db.

Is there any dependency that is missing? Any necessary library?
Any ideas?
Thank you,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing MySql...

[SGreen]

"Steve Grosz" <[EMAIL PROTECTED]> wrote on 02/09/2005 03:43:22 PM:

> I downloaded the MySql Administrator and simply run that. and 
> dragged the icon to the startup menu so it loads MySql on startup. 
> Not entirely sure how to load MySql as a 'service' on Win2003 Server.
> 
> The only message I get, and this is when trying to administer the 
> server through the Admin tool, is that it can't connect to 
> 'localhost' with 'root' and 'password' defined in my.ini
> Steve
> 
> 


Since you are on installation step 2.3.10, I can only guess that you 
haven't started your MySQL server. There are normally 2 programs you have 
to have going to use MySQL. The server and a client. I don't think you 
have your server going.

Follow the directions from 2.3.10 on and you should complete your 
installation just fine. (I would skip 2.3.11 since you are going to be 
running MySQL as a service anyway)

2.3.13 shows how to test your setup. 2.3.14 has troubleshooting advice. 

IF you finish the installation procedure and still cannot connect. Come 
back to the list again and we will be able to help you out some more, OK?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: Problems installing MySql...

[SGreen]

>> reconstituted from a munged response 
(original post)
Steve Grosz <[EMAIL PROTECTED]> wrote on 02/08/2005 06:04:48 PM:

> I already have a version of MySql 4.1.17 running on a different server, 
but
> am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
> software.
> 
> I'm finding that 4.0.23 isn't as easy to set up as the later versions.
> 
> I modified the my.ini file and put it in the \windows directory for 
Windows
> Server 2003.
> 
> When I try to use the MySql Administator, and put in the server name, 
root
> account and password defined in the my.ini file, it doesn't connect, 
using
> 'localhost'.
> 
> What am I doing incorrectly?
> 
> Steve
> 

Did you remember to cross your fingers and gnash your teeth? What about 
the blue button, did you press it? (Just kidding)


First off, you left out a lot of useful information about your situation:
How did you install the 4.0.23 (zip, msi,...)? 
Have you verified that the server is running? 
What other connection methods have you tried? Did they work?
Have you been following the documented installation procedure (
http://dev.mysql.com/doc/mysql/en/installing.html)? If you have, what step 

are you on?
Have you looked at the Troubleshooting guide (
http://dev.mysql.com/doc/mysql/en/problems.html)?
Besides posting to this list, what other things have you tried?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

> Steve's Reply <
"Steve Grosz" <[EMAIL PROTECTED]> wrote on 02/09/2005 02:01:14 PM:

> I guess I didn't hold my mouth right.hate it when that happens! :-) 
I installed from a ZIP file, and the Admin tool 
> does show that the server is running.
>
> I have tried to telnet into that server, and it fails, but that may 
> be due to the firewall.
>
> Currently I am on step #2.3.10 of the install process.
> If I didn't answer all your questions, let me know!  Thanks for the 
help!!
> Steve

Just curious, if you are being faithful to the installation docs How 
is the Admin tool running? You aren't to that step yet... ;-)

Anyway, it's odd that you cannot telnet to a server when you say it is up. 
Note: You DO NOT get a normal telnet session, all you should be able to 
see when you telnet to a MySQL server is the version number and some 
garbage characters. That tells you that you have port-to-port connectivity 
from your machine to the server. It would be prohibitively difficult to 
use telnet (read: practically impossible) to work directly with a MySQL 
server manually through telnet.

How did you start the server, is it installed as a service or are you 
running it manually from a command prompt? 

Is your problem connecting to the server through mysqladmin or getting the 
server running? Can you connect through the command line client mysql.exe? 
 What error messages are you getting and from what program?

And one last thing... please CC: the list on all responses. It will not 
only help the next dba through a similar issue but it will also make sure 
you get more responses. In the event that I became unavailable or gave you 
bad advice, anyone else on the list could kick in and help get you going, 
too.


Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine






 

Re: Problems installing MySql...

[SGreen]

Steve Grosz <[EMAIL PROTECTED]> wrote on 02/08/2005 06:04:48 PM:

> I already have a version of MySql 4.1.17 running on a different server, 
but
> am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
> software.
> 
> I'm finding that 4.0.23 isn't as easy to set up as the later versions.
> 
> I modified the my.ini file and put it in the \windows directory for 
Windows
> Server 2003.
> 
> When I try to use the MySql Administator, and put in the server name, 
root
> account and password defined in the my.ini file, it doesn't connect, 
using
> 'localhost'.
> 
> What am I doing incorrectly?
> 
> Steve
> 

Did you remember to cross your fingers and gnash your teeth? What about 
the blue button, did you press it? (Just kidding)


First off, you left out a lot of useful information about your situation:
How did you install the 4.0.23 (zip, msi,...)? 
Have you verified that the server is running? 
What other connection methods have you tried? Did they work?
Have you been following the documented installation procedure (
http://dev.mysql.com/doc/mysql/en/installing.html)? If you have, what step 
are you on?
Have you looked at the Troubleshooting guide (
http://dev.mysql.com/doc/mysql/en/problems.html)?
Besides posting to this list, what other things have you tried?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Problems installing MySql...

[Steve Grosz]

I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for Windows
Server 2003.
When I try to use the MySql Administator, and put in the server name, root
account and password defined in the my.ini file, it doesn't connect, using
'localhost'.
What am I doing incorrectly?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySql 4.1

[Artem Koltsov]

I had similar problem after incomplete removal MySQL 4.0.x which left dead 
service named MySQL that points to non-existing path c:\mysql. I changed the 
windows service name for MySQL 4.1 to MySQL41, and it works fine. Also you can 
try to execute mysqld from command line to see any extra details: mysqld 
--console --standalone

> -Original Message-
> From: Darrell and Lynda Adams [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 27, 2005 4:34 PM
> To: mysql@lists.mysql.com
> Subject: Installing MySql 4.1
> 
> 
> Trying to install MySql 4.1 on XP using the automated 
> installer. Have tried to install both the windows essentials 
> and windows X86 . Tried doing typical and custom versions. 
> Also used the Instance Configuration both detail and 
> standard. When I get to the dialog box with the execute 
> button I receive the following error message: "Cannot create 
> windows service for MySql. Error:0."  Also went into services 
> and tried to start and received the error message "Could not 
> start MySql service on local computer. Error 3: The system 
> cannot find the path specified. OBVIOUSLY I dont have 
> something set. Any help appreciated.
> 
 
Attention:
Any views expressed in this message are those of the individual sender, except 
where the message states otherwise and the sender is authorized to state them 
to be the views of any such entity. The information contained in this message 
and or attachments is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.  If you 
received this in error, please contact the sender and delete the material from 
any system and destroy any copies.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySql 4.1

[Darrell and Lynda Adams]

Trying to install MySql 4.1 on XP using the automated installer. Have tried to 
install both the windows essentials and windows X86 . Tried doing typical and 
custom versions. Also used the Instance Configuration both detail and standard. 
When I get to the dialog box with the execute button I receive the following 
error message: "Cannot create windows service for MySql. Error:0."  Also went 
into services and tried to start and received the error message "Could not 
start MySql service on local computer. Error 3: The system cannot find the path 
specified. OBVIOUSLY I dont have something set. Any help appreciated.

RE: installing mysql / error

[J.R. Bullington]

This error is caused when the server isn't started. Make sure that you start 
the server first, then
log in. When you skip the HOSTS.FRM tables (by doing mysqld 
--skip-grant-tables), you have to
restart the server normally to effect your changes in the mysql root user.

J.R.

-Original Message-
From: David Katz [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 03, 2005 10:30 AM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: Re: installing mysql / error

I did the first 2 step you listed below, but when I typed in the mysql -u root, 
I got a new error
message

ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)

Thanks
David.

- Original Message -
From: "Tom Crimmins" <[EMAIL PROTECTED]>
To: "David Katz" <[EMAIL PROTECTED]>
Cc: 
Sent: Thursday, December 30, 2004 2:32 PM
Subject: RE: installing mysql / error


> [snip]
>
> When I try 'mysql -u root'  I get the same error, except root is in the
> place of ODBC
>
> ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
> password: NO)
>
> [/snip]
>
> In that case, you may have a password set for root. To reset the password,
> shutdown the mysql server. Then start it from a command line using:
>
> [PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables
>
> Then open another command prompt and run 'mysql -u root' and run the
> following query:
>
> UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost';
>
> Then shutdown the server, and restart it normally. You should then be able
> to connect with 'mysql -u root'.
>
> ---
> Tom Crimmins
> Interface Specialist
> Pottawattamie County, Iowa
> office 712.328.4808
> mobile 402.677.1592
>
>
> -Original Message-
> From: David Katz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 30, 2004 1:25 PM
> To: Tom Crimmins
> Cc: mysql@lists.mysql.com
> Subject: Re: installing mysql / error
>
> When I try 'mysql -u root'  I get the same error, except root is in the
> place of ODBC
>
> ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
> password: NO)
>
>
>
> - Original Message -
> From: "Tom Crimmins" <[EMAIL PROTECTED]>
> To: "David Katz" <[EMAIL PROTECTED]>
> Cc: 
> Sent: Thursday, December 30, 2004 1:57 PM
> Subject: RE: installing mysql / error
>
>
> > [snip]
> > We loaded a new server with Windows XP professional, and mysql server
4.1.
> > We can't get Mysql to run.  After installing mysql and trying to execute
> it
> > we get the following message:
> >
> > ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
> > password: NO)
> > [/snip]
> >
> > Ignore my previous post, I misunderstood.
> >
> > ODBC is the default account on a windows server. You need to use run
> 'mysql
> > -u root' from a command-line. You should then be able to grant privs to
> > [EMAIL PROTECTED]
> >
> > ---
> > Tom Crimmins
> > Interface Specialist
> > Pottawattamie County, Iowa
>
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: installing mysql / error

[David Katz]

I did the first 2 step you listed below, but when I typed in the mysql -u
root, I got a new error message

ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)

Thanks
David.

- Original Message - 
From: "Tom Crimmins" <[EMAIL PROTECTED]>
To: "David Katz" <[EMAIL PROTECTED]>
Cc: 
Sent: Thursday, December 30, 2004 2:32 PM
Subject: RE: installing mysql / error


> [snip]
>
> When I try 'mysql -u root'  I get the same error, except root is in the
> place of ODBC
>
> ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
> password: NO)
>
> [/snip]
>
> In that case, you may have a password set for root. To reset the password,
> shutdown the mysql server. Then start it from a command line using:
>
> [PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables
>
> Then open another command prompt and run 'mysql -u root' and run the
> following query:
>
> UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost';
>
> Then shutdown the server, and restart it normally. You should then be able
> to connect with 'mysql -u root'.
>
> ---
> Tom Crimmins
> Interface Specialist
> Pottawattamie County, Iowa
> office 712.328.4808
> mobile 402.677.1592
>
>
> -Original Message-
> From: David Katz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 30, 2004 1:25 PM
> To: Tom Crimmins
> Cc: mysql@lists.mysql.com
> Subject: Re: installing mysql / error
>
> When I try 'mysql -u root'  I get the same error, except root is in the
> place of ODBC
>
> ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
> password: NO)
>
>
>
> - Original Message -
> From: "Tom Crimmins" <[EMAIL PROTECTED]>
> To: "David Katz" <[EMAIL PROTECTED]>
> Cc: 
> Sent: Thursday, December 30, 2004 1:57 PM
> Subject: RE: installing mysql / error
>
>
> > [snip]
> > We loaded a new server with Windows XP professional, and mysql server
4.1.
> > We can't get Mysql to run.  After installing mysql and trying to execute
> it
> > we get the following message:
> >
> > ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
> > password: NO)
> > [/snip]
> >
> > Ignore my previous post, I misunderstood.
> >
> > ODBC is the default account on a windows server. You need to use run
> 'mysql
> > -u root' from a command-line. You should then be able to grant privs to
> > [EMAIL PROTECTED]
> >
> > ---
> > Tom Crimmins
> > Interface Specialist
> > Pottawattamie County, Iowa
>
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: installing mysql / error

[Tom Crimmins]

[snip]

When I try 'mysql -u root'  I get the same error, except root is in the
place of ODBC

ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
password: NO)

[/snip]

In that case, you may have a password set for root. To reset the password,
shutdown the mysql server. Then start it from a command line using:

[PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables

Then open another command prompt and run 'mysql -u root' and run the
following query:

UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost';

Then shutdown the server, and restart it normally. You should then be able
to connect with 'mysql -u root'.

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
office 712.328.4808
mobile 402.677.1592


-Original Message-
From: David Katz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 30, 2004 1:25 PM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: Re: installing mysql / error

When I try 'mysql -u root'  I get the same error, except root is in the
place of ODBC

ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
password: NO)



- Original Message -
From: "Tom Crimmins" <[EMAIL PROTECTED]>
To: "David Katz" <[EMAIL PROTECTED]>
Cc: 
Sent: Thursday, December 30, 2004 1:57 PM
Subject: RE: installing mysql / error


> [snip]
> We loaded a new server with Windows XP professional, and mysql server 4.1.
> We can't get Mysql to run.  After installing mysql and trying to execute
it
> we get the following message:
>
> ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
> password: NO)
> [/snip]
>
> Ignore my previous post, I misunderstood.
>
> ODBC is the default account on a windows server. You need to use run
'mysql
> -u root' from a command-line. You should then be able to grant privs to
> [EMAIL PROTECTED]
>
> ---
> Tom Crimmins
> Interface Specialist
> Pottawattamie County, Iowa



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: installing mysql / error

[David Katz]

When I try 'mysql -u root'  I get the same error, except root is in the
place of ODBC

ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using
password: NO)



- Original Message - 
From: "Tom Crimmins" <[EMAIL PROTECTED]>
To: "David Katz" <[EMAIL PROTECTED]>
Cc: 
Sent: Thursday, December 30, 2004 1:57 PM
Subject: RE: installing mysql / error


> [snip]
> We loaded a new server with Windows XP professional, and mysql server 4.1.
> We can't get Mysql to run.  After installing mysql and trying to execute
it
> we get the following message:
>
> ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
> password: NO)
> [/snip]
>
> Ignore my previous post, I misunderstood.
>
> ODBC is the default account on a windows server. You need to use run
'mysql
> -u root' from a command-line. You should then be able to grant privs to
> [EMAIL PROTECTED]
>
> ---
> Tom Crimmins
> Interface Specialist
> Pottawattamie County, Iowa
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: installing mysql / error

[SGreen]

"David Katz" <[EMAIL PROTECTED]> wrote on 12/30/2004 01:32:41 PM:

> I'm going to the dos window on the server and typing "mysql" to kick it 
off.
> That's when I get the error.
> 

OK, "mysql" is the client that comes with the server. What you attempted 
to do was to login as "nobody" and you said you weren't going to provide a 
password. What you should have typed is 

mysql -u root

so that you attempt to connect as the mysql user "root". That is one of 
the two accounts set up by default when you install a new MySQL server.

I think you have accomplished all of the setup steps down to here:
http://dev.mysql.com/doc/mysql/en/Post-installation.html

I especially think that you are ready for step 2.9.3 - Securing the 
Initial MySQL Accounts
http://dev.mysql.com/doc/mysql/en/Default_privileges.html

Try it out and let me know if you need more information.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



> 
> - Original Message - 
> From: <[EMAIL PROTECTED]>
> To: "David Katz" <[EMAIL PROTECTED]>
> Cc: 
> Sent: Thursday, December 30, 2004 1:13 PM
> Subject: Re: Fw: installing mysql / error
> 
> 
> > "David Katz" <[EMAIL PROTECTED]> wrote on 12/30/2004 12:34:31 PM:
> >
> > >
> > >
> > > We loaded a new server with Windows XP professional, and mysql
> > > server 4.1. We can't get Mysql to run.  After installing mysql and
> > > trying to execute it we get the following message:
> > >
> > > ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost'
> > > (using password: NO)
> > >
> > > Any ideas on what we can try and do?
> > >
> > > Thanks
> > > David.
> >
> > Your server IS running or you wouldn't have that error, you would have
> > seen something else. You left out a critical detail from your original
> > post:
> >
> > What are you doing when you get that error?
> >
> > If you are attempting a connection through an ODBC driver, you need to 
be
> > aware that even the most up-to-date driver acts like a pre-4.1 client.
> > That means you may need to follow  one or more of the suggestions
> > documented here:
> >
> > http://dev.mysql.com/doc/mysql/en/Problems.html
> > especially read A.2.3 :
> > http://dev.mysql.com/doc/mysql/en/Old_client.html
> >
> > Let me know if I am on the right track, OK?
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 

RE: installing mysql / error

[Tom Crimmins]

[snip]
We loaded a new server with Windows XP professional, and mysql server 4.1.
We can't get Mysql to run.  After installing mysql and trying to execute it
we get the following message:

ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
password: NO)
[/snip] 

Ignore my previous post, I misunderstood.
 
ODBC is the default account on a windows server. You need to use run 'mysql
-u root' from a command-line. You should then be able to grant privs to
[EMAIL PROTECTED]

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: installing mysql / error

[Tom Crimmins]

[snip]
We loaded a new server with Windows XP professional, and mysql server 4.1.
We can't get Mysql to run.  After installing mysql and trying to execute it
we get the following message:

ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using
password: NO)
[/snip] 

Try starting mysqld-nt with the --skip-grant-tables option. Then attempt to
login from the command line. If this works, the privileges for the ODBC
account are wrong or there is a password set. You can fix the privileges or
reset the password once you are logged in. Then you can restart the server
normally.

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: installing mysql / error

[David Katz]

I'm going to the dos window on the server and typing "mysql" to kick it off.
That's when I get the error.


- Original Message - 
From: <[EMAIL PROTECTED]>
To: "David Katz" <[EMAIL PROTECTED]>
Cc: 
Sent: Thursday, December 30, 2004 1:13 PM
Subject: Re: Fw: installing mysql / error


> "David Katz" <[EMAIL PROTECTED]> wrote on 12/30/2004 12:34:31 PM:
>
> >
> >
> > We loaded a new server with Windows XP professional, and mysql
> > server 4.1. We can't get Mysql to run.  After installing mysql and
> > trying to execute it we get the following message:
> >
> > ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost'
> > (using password: NO)
> >
> > Any ideas on what we can try and do?
> >
> > Thanks
> > David.
>
> Your server IS running or you wouldn't have that error, you would have
> seen something else. You left out a critical detail from your original
> post:
>
> What are you doing when you get that error?
>
> If you are attempting a connection through an ODBC driver, you need to be
> aware that even the most up-to-date driver acts like a pre-4.1 client.
> That means you may need to follow  one or more of the suggestions
> documented here:
>
> http://dev.mysql.com/doc/mysql/en/Problems.html
> especially read A.2.3 :
> http://dev.mysql.com/doc/mysql/en/Old_client.html
>
> Let me know if I am on the right track, OK?
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: installing mysql / error

[SGreen]

"David Katz" <[EMAIL PROTECTED]> wrote on 12/30/2004 12:34:31 PM:

> 
> 
> We loaded a new server with Windows XP professional, and mysql 
> server 4.1. We can't get Mysql to run.  After installing mysql and 
> trying to execute it we get the following message:
> 
> ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' 
> (using password: NO)
> 
> Any ideas on what we can try and do?
> 
> Thanks
> David.

Your server IS running or you wouldn't have that error, you would have 
seen something else. You left out a critical detail from your original 
post:

What are you doing when you get that error?

If you are attempting a connection through an ODBC driver, you need to be 
aware that even the most up-to-date driver acts like a pre-4.1 client. 
That means you may need to follow  one or more of the suggestions 
documented here:

http://dev.mysql.com/doc/mysql/en/Problems.html
especially read A.2.3 :
http://dev.mysql.com/doc/mysql/en/Old_client.html

Let me know if I am on the right track, OK?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Fw: installing mysql / error

[David Katz]

We loaded a new server with Windows XP professional, and mysql server 4.1. We 
can't get Mysql to run.  After installing mysql and trying to execute it we get 
the following message:

ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password: 
NO)

Any ideas on what we can try and do?

Thanks
David.

Re: Problem installing Mysql 4.1 on Fedora 2

[Spenser]

I had the same problem.  It just won't seem to upgrade.  You need to
uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first.  Enter
something like this:

rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9


When it's done, then install version 4.x


On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED] wrote:
> Hi:
> 
> When i tried to install Mysql using the rpm on a Fedora 2 .. i received this 
> error:
> 
> shell>rpm -i MySQL-server-4.1.7-0.i386.rpm
> warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID
> 5072e1f5error: Failed dependencies:
> MySQL conflicts with mysql-3.23.58-9
> MySQL-server conflicts with mysql-server-3.23.58-9
> 
> 
> Any suggestions?
> 
> Thanks,
> 
> Oscar Fernando
> 
> 
> 
> 
> 
> 
> Telesat, más fácil...más Internet.
> http://www.telesat.com.co/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem installing Mysql 4.1 on Fedora 2

[ofz]

Hi:

When i tried to install Mysql using the rpm on a Fedora 2 .. i received this 
error:

shell>rpm -i MySQL-server-4.1.7-0.i386.rpm
warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5error: Failed dependencies:
MySQL conflicts with mysql-3.23.58-9
MySQL-server conflicts with mysql-server-3.23.58-9


Any suggestions?

Thanks,

Oscar Fernando






Telesat, más fácil...más Internet.
http://www.telesat.com.co/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error after installing mysql 4.1

[Gleb Paharenko]

Hello.



Not enough info to make a conclusion. 

Send us information about version of Windows you use, contents of my.ini.





Dave Dyer <[EMAIL PROTECTED]> wrote:

> 

> After installing mysql 4.1 over an existing mysql 4.0.x, the

> service refuses to start with this complaint:

> 

> Fatal error: Can't open privilege tables: File 
> '\\pumpkin\f\mysql\share\charsets\?.conf' not found (Errcode: 22)

> 

> This is windows, with mysql installed in a nondefault directory.

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

error after installing mysql 4.1

[Dave Dyer]

After installing mysql 4.1 over an existing mysql 4.0.x, the
service refuses to start with this complaint:

Fatal error: Can't open privilege tables: File 
'\\pumpkin\f\mysql\share\charsets\?.conf' not found (Errcode: 22)

This is windows, with mysql installed in a nondefault directory.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

terrible time installing MySql

[Jeff]

Please help I'm have a terrible time installing MySql 
 
 
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: j2d
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
 
>Description:

>How-To-Repeat:

>Fix:

 
>Submitter-Id:
>Originator:   Jeff
>Organization:
 
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis:
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:   <[ low | medium | high ] (one line)>
>Category:mysql
>Class: <[ sw-bug | doc-bug | change-request | support ]
(one line)>
>Release: mysql-4.0.21-standard (Official MySQL RPM)
 
>C compiler:2.95.3
>C++ compiler:  2.95.3
>Environment:

System: Linux localhost.localdomain 2.4.20-6 #1 Thu Feb 27 10:01:19 EST
2003 i686 athlon i386 GNU/Linux
Architecture: i686
 
Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake
 
Compilation info: CC='gcc'  CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce'
CXX='gcc'  CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti
'  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Dec 23  2002 /lib/libc.so.6
-> libc-2.3.2.so
-rwxr-xr-x1 root root  1566428 Feb 27  2003
/lib/libc-2.3.2.so
-rw-r--r--1 root root  2321334 Feb 27  2003 /usr/lib/libc.a
-rw-r--r--1 root root  204 Feb 27  2003 /usr/lib/libc.so
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--with-server-suffix=-standard' '--without-embedded-server'
'--without-berkeley-db' '--with-innodb' '--without-vio'
'--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql'
'--infodir=/usr/share/info' '--includedir=/usr/include'
'--mandir=/usr/share/man' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti
' 'CXX=gcc'
 

Re: Installing MySQL 4.1 from RPM on Fedora2

[Egor Egorov]

"Danesh Daroui" <[EMAIL PROTECTED]> wrote:

> I have installed Server, Client, Benhcmark, Share, Embeded and =
> Compact-Share RPMs version 4.1 on a Fedora2 system. The have been =
> installed successfully but when I type:
> 
> Shell> mysql -u root
> 
> it says that it can not open socket and I think it is because mysqld is =
> not alive. When I type:
> 
> Shell> mysqld
> 
> it returns a fatal error and refers me to Security notes about =
> installation. Also, I thought that an user account which name is mysql =
> should be created automatically when RPMs are installed, but there is no =
> user account with name mysql !!! Please help me to fix the problem and =
> install mysql on my linux system.

Maybe, you haven't removed the older mysql that comes with fedora? 
Let's clean your system. Save your data in a safe place, we will later remove
the MySQL data directory. 

Issue 
rpm -qa | grep -i mysql

And see what are the packages with mysql in it. Remove everything that has
relation to MySQL itself (but of course, not packages like postfix-sasl-mysql
or mod_php_mysql, etc). Ignore dependencies. 

After that, clean your system: remove /var/lib/mysql and delete the mysql user: 

userdel mysql

Again, don't forget to save your data!

Then do a fresh install of MySQL.com's downloaded packages. Install it like
that: 

rpm --install -v -h MySQL*4.1.4*rpm 

That should help.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL 4.1 from RPM on Fedora2

[Donny Simonton]

Start mysql on fc2 with 
/etc/rc.d/init.d/mysql start

If that fails then look at the mysql error log.

Donny

> -Original Message-
> From: Danesh Daroui [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 02, 2004 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: Installing MySQL 4.1 from RPM on Fedora2
> 
> Hi all,
> 
> I have installed Server, Client, Benhcmark, Share, Embeded and Compact-
> Share RPMs version 4.1 on a Fedora2 system. The have been installed
> successfully but when I type:
> 
> Shell> mysql -u root
> 
> it says that it can not open socket and I think it is because mysqld is
> not alive. When I type:
> 
> Shell> mysqld
> 
> it returns a fatal error and refers me to Security notes about
> installation. Also, I thought that an user account which name is mysql
> should be created automatically when RPMs are installed, but there is no
> user account with name mysql !!! Please help me to fix the problem and
> install mysql on my linux system.
> 
> Regards,
> 
> Danesh Daroui



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL 4.1 from RPM on Fedora2

[Danesh Daroui]

Hi all, 

I have installed Server, Client, Benhcmark, Share, Embeded and Compact-Share RPMs 
version 4.1 on a Fedora2 system. The have been installed successfully but when I type:

Shell> mysql -u root

it says that it can not open socket and I think it is because mysqld is not alive. 
When I type:

Shell> mysqld

it returns a fatal error and refers me to Security notes about installation. Also, I 
thought that an user account which name is mysql should be created automatically when 
RPMs are installed, but there is no user account with name mysql !!! Please help me to 
fix the problem and install mysql on my linux system.

Regards,

Danesh Daroui

RE: Installing MySQL Databases on RAM Drive

[Stephen Rasku]

Originally I had developed this application for the Berkeley DB but they
wanted an outrageous amount of money for licencing since we were using
transactions.  Memory and disk weren't really constraints when I
re-developed it.  Time and cost were constraints though and MySQL was
the fastest thing I could get running on QNX.

...Stephen

-Original Message-
From: mos [mailto:[EMAIL PROTECTED] 
Sent: Jul 30, 2004 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Installing MySQL Databases on RAM Drive


Ok, then it makes sense to use compact flash just for backup and not the

primary drive. But you still have to put the MySQL tempdir someplace and

that may still get some read/write activity. Of course if you are just 
doing data collection then this should be minimal. MySQL is pretty 
elaborate for something like this. So I'm wondering if MySQL because of
its 
disk activity is the right database for the job? There are memory based 
databases that are excellent for this type of application. They are
small 
and extremely fast and can load/save the table to disk and you can 
eliminate all disk activity. The one I'm thinking of is called
TkbmMemTable 
and runs in Delphi and I think there is a Kylix version for Linux. It
has 
built in compression, indexing, blob support, and it is free (they have
a 
pay version) and there are no 
royalties.http://www.components4programmers.com/products/kbmmemtable/

This means there is zero disk activity and the "database" (which is a
flat 
file system) and it gets compiled into the .exe file so there is a zero 
footprint install. You can then export the data to a CSV file for import

into another database. It is also possible to access the database over a

webserver too so you can access the data remotely.  Send me an email if
you 
want me to send you a compiled TkbmMemTable demo app if you want to see 
what it can do. (for Windows) -I'm not associated with their company but

I've been using it for years and it's great.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL Databases on RAM Drive

[Brent Baisley]

Could you store your BLOBs as files external to the database (in the OS 
file system) and just store the path name to the file? I don't know 
what your reasons for having the BLOB is, usually it's just for 
portability of the application.

As for "saving" the HEAP tables, you would just TRUNCATE the stored 
tables and do a SELECT INTO from the HEAP tables into the stored 
tables. Although I would keep two or more copies of the database and 
alternate between the databases when storing.

On Jul 30, 2004, at 1:10 PM, Stephen Rasku wrote:
I just looked into this.  It looks like HEAP tables don't support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive
Why use a RAM disk? Why not just load the tables into HEAP tables?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL Databases on RAM Drive

[Eamon Daly]

Just a thought, but perhaps you could set up a master/slave
on the box such that the master points to a RAM disk and the
slave points to disk. Then if someone pulls the plug or the
machine crashes, you'd still have almost all of the data on
disk. On startup, copy the slave's files to the RAM disk,
make a backup copy somewhere, and start both MySQL servers.
This setup wouldn't require changing any SQL.


Eamon Daly
NextWave Media Group LLC
Tel: 1 773 975-1115
Fax: 1 773 913-0970

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL Databases on RAM Drive

[mos]

Stephen,
At 11:16 AM 7/30/2004, Stephen Rasku wrote:
Flash drives have a limited number of writes that can be done before the
drive starts to fail:
http://www.kingston.com/tools/bits/bit17.asp
http://www.diskonkey.com/documents/Performance_reliability.pdf
(Look under "Flash Reliability")
Thanks for the info. I learned something today.

If I can write the database to a RAM disk and just archive to the flash
drive periodically, I can greatly reduce the number of writes to the
flash drives and extending its life.  These drives are going into
transmitter stations in remote locations that are only accessible in the
summer.  If we have a failure in the winter the system could be unusable
for 6 months.
Ok, then it makes sense to use compact flash just for backup and not the 
primary drive. But you still have to put the MySQL tempdir someplace and 
that may still get some read/write activity. Of course if you are just 
doing data collection then this should be minimal. MySQL is pretty 
elaborate for something like this. So I'm wondering if MySQL because of its 
disk activity is the right database for the job? There are memory based 
databases that are excellent for this type of application. They are small 
and extremely fast and can load/save the table to disk and you can 
eliminate all disk activity. The one I'm thinking of is called TkbmMemTable 
and runs in Delphi and I think there is a Kylix version for Linux. It has 
built in compression, indexing, blob support, and it is free (they have a 
pay version) and there are no 
royalties.http://www.components4programmers.com/products/kbmmemtable/

This means there is zero disk activity and the "database" (which is a flat 
file system) and it gets compiled into the .exe file so there is a zero 
footprint install. You can then export the data to a CSV file for import 
into another database. It is also possible to access the database over a 
webserver too so you can access the data remotely.  Send me an email if you 
want me to send you a compiled TkbmMemTable demo app if you want to see 
what it can do. (for Windows) -I'm not associated with their company but 
I've been using it for years and it's great.


The system is protected by a monitored UPS.  If the power fails, part of
the shutdown procedure would be to save the database to flash.
There is no user per se for this system but there are multiple processes
accessing the database.  There are actually two databases but one gets
backed up much more frequently than the other.  The whole operating
system and application is stored on the flash drive.
HEAP tables might be the solution.  How would I archive these to disk on
shutdown?
You can use SQL on a heap table like any other MySQL table.
Example:
insert into save_table select * from ram_table;
The ram_table should have the same columns as save_table.
BTW, you can now use a "Create ram_table like save_table".
Mike

...Stephen
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive
At 04:45 PM 7/28/2004, you wrote:
>Our customers are running MySQL 4.0.17 on QNX 6.2.1.
>
>We are currently using a flash drive to store our database but we want
>to store it in a RAM disk to prolong the life of the drive
Flash drives are solid state (no moving parts) so you can't break them.
I've never heard of anyone wearing them out. Compact Flash unless they
are
too slow or consume too much power, I'd recommend sticking with a flash
drive. With a RAM drive you need to handle times when the power fails.
Someone else mentioned HEAP tables which solves the speed problem and
you
could write everything to flash memory every 5 minutes or so as a back
up.
I assume  this is for a single user right? You're not running a database
server off of Compact Flash, right? If so you may want to try the
embedded
MySQL version which will speed things up a bit.
http://dev.mysql.com/doc/mysql/en/libmysqld_overview.html
Mike

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL Databases on RAM Drive

[Stephen Rasku]

I just looked into this.  It looks like HEAP tables don't support the
BLOB field type and we are using it.

...Stephen

-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED] 
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive


Why use a RAM disk? Why not just load the tables into HEAP tables?




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL Databases on RAM Drive

[Stephen Rasku]

Flash drives have a limited number of writes that can be done before the
drive starts to fail:

http://www.kingston.com/tools/bits/bit17.asp
http://www.diskonkey.com/documents/Performance_reliability.pdf 
(Look under "Flash Reliability")

If I can write the database to a RAM disk and just archive to the flash
drive periodically, I can greatly reduce the number of writes to the
flash drives and extending its life.  These drives are going into
transmitter stations in remote locations that are only accessible in the
summer.  If we have a failure in the winter the system could be unusable
for 6 months.

The system is protected by a monitored UPS.  If the power fails, part of
the shutdown procedure would be to save the database to flash.

There is no user per se for this system but there are multiple processes
accessing the database.  There are actually two databases but one gets
backed up much more frequently than the other.  The whole operating
system and application is stored on the flash drive.

HEAP tables might be the solution.  How would I archive these to disk on
shutdown?

...Stephen

-Original Message-
From: mos [mailto:[EMAIL PROTECTED] 
Sent: Jul 30, 2004 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases on RAM Drive


At 04:45 PM 7/28/2004, you wrote:
>Our customers are running MySQL 4.0.17 on QNX 6.2.1.
>
>We are currently using a flash drive to store our database but we want
>to store it in a RAM disk to prolong the life of the drive

Flash drives are solid state (no moving parts) so you can't break them. 
I've never heard of anyone wearing them out. Compact Flash unless they
are 
too slow or consume too much power, I'd recommend sticking with a flash 
drive. With a RAM drive you need to handle times when the power fails.

Someone else mentioned HEAP tables which solves the speed problem and
you 
could write everything to flash memory every 5 minutes or so as a back
up. 
I assume  this is for a single user right? You're not running a database

server off of Compact Flash, right? If so you may want to try the
embedded 
MySQL version which will speed things up a bit. 
http://dev.mysql.com/doc/mysql/en/libmysqld_overview.html

Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL Databases on RAM Drive

[mos]

At 04:45 PM 7/28/2004, you wrote:
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive
Flash drives are solid state (no moving parts) so you can't break them. 
I've never heard of anyone wearing them out. Compact Flash unless they are 
too slow or consume too much power, I'd recommend sticking with a flash 
drive. With a RAM drive you need to handle times when the power fails.

Someone else mentioned HEAP tables which solves the speed problem and you 
could write everything to flash memory every 5 minutes or so as a back up. 
I assume  this is for a single user right? You're not running a database 
server off of Compact Flash, right? If so you may want to try the embedded 
MySQL version which will speed things up a bit. 
http://dev.mysql.com/doc/mysql/en/libmysqld_overview.html

Mike

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL Databases on RAM Drive

[Brent Baisley]

Why use a RAM disk? Why not just load the tables into HEAP tables?
On Jul 29, 2004, at 11:51 AM, Egor Egorov wrote:
"Stephen Rasku" <[EMAIL PROTECTED]> wrote:
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive.  We want 
to
install the database on the RAM disk on startup and save it to flash 
on
shutdown.

There are two databases that we are using.  Neither is very big but 
one
is updated very frequently and the other one is not.  However, even
though the databases are small, the ibdata1 file is 136M.  Is there a
way to prevent this file from growing too big?
The InnoDB needs more disk space than MyISAM. Perhaps, you could use 
MyISAM?



--
For technical support contracts, goto 
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing MySQL Databases on RAM Drive

[Egor Egorov]

"Stephen Rasku" <[EMAIL PROTECTED]> wrote:

> We are currently using a flash drive to store our database but we want
> to store it in a RAM disk to prolong the life of the drive.  We want to
> install the database on the RAM disk on startup and save it to flash on
> shutdown.
> 
> There are two databases that we are using.  Neither is very big but one
> is updated very frequently and the other one is not.  However, even
> though the databases are small, the ibdata1 file is 136M.  Is there a
> way to prevent this file from growing too big?

The InnoDB needs more disk space than MyISAM. Perhaps, you could use MyISAM? 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL Databases on RAM Drive

[Stephen Rasku]

Our customers are running MySQL 4.0.17 on QNX 6.2.1.

We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive.  We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.

There are two databases that we are using.  Neither is very big but one
is updated very frequently and the other one is not.  However, even
though the databases are small, the ibdata1 file is 136M.  Is there a
way to prevent this file from growing too big?

...Stephen


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]