Re: Installation Problems

[Manish Gupta]

Hi Roland,
I wanted to know if you face the sae problems that i've faced or u get
somethng else.

@ Ian
I've already done that. I will do what Roland told me to, lets hope i have
some luck this time around.

On Wed, Mar 25, 2009 at 2:15 AM, Rolando Edwards redwa...@logicworks.netwrote:

 Ever since MySQL 5.0.27, I have never been able to install the MySQL
 Service either.
 I think this has something to do with the way Microsoft compiles its OS
 Services.

 I use the no installer version now.

 1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32
 2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a
 Windows Explorer Window in that new empty Folder.
 3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop
 4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window
 opens up containing the folder 'mysql-noinstall-5.1.32-win32'
 5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another
 window shows the folders 'bin','data','Docs' and so forth.
 6. Select all files and folders by hitting Ctrl-A
 7. Drag and Drop those selected files and folders into the 'C:\
 MySQL_5.1.32' Window
 8. Right-click on 'My Computer', and click on 'Properties'
 9. Click on the Advanced Tab
 10. Click the Environment Variables button
 11. Scroll the bottom listbox to the PATH variable
 12. Double Click the PATH variable
 13. Append ';C:\MySQL_5.1.32' to the PATH variable
 14. Click OK 3 times
 15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other
 words, copy mysql-small.ini to my.ini)
If you do not do this, you will be starting mysqld with all server
 defaults
 16. Create a DOS Batch File called start_mysqld.bat with the following
 lines@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
echo %MYSQL_BIN%
cd %MYSQL_BIN%
pause (This line is optional)
start mysqld
 17. Create a DOS Batch File called stop_mysqld.bat with the following lines
@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
%MYSQL_BIN%\mysqladmin -uroot shutdown
 18. Create a ShortCut for both batch files and place them on the Desktop
 19. Double Click the ShortCut for start_mysqld.bat
This should start up mysqld
Open the task manager and look for 'mysqld.exe'
 20. Goto a new DOS Window and type 'mysql -uroot'
You should be mysql now.

 If you got to this point successfully, have fun from here !!!

 Rolando A. Edwards
 MySQL DBA (CMDBA)

 155 Avenue of the Americas, Fifth Floor
 New York, NY 10013
 212-625-5307 (Work)
 201-660-3221 (Cell)
 AIM : RolandoLogicWorx
 Skype : RolandoLogicWorx
 redwa...@logicworks.net

 -Original Message-
 From: Manish Gupta [mailto:manish.in@gmail.com]
 Sent: Tuesday, March 24, 2009 4:05 PM
 To: mysql@lists.mysql.com
 Subject: Installation Problems

 I had MySQL 4.0.
 Today i downloaded the recent version, mysql5.12.32-Win32 installer.
 I deleted the older verison of mysql that i had. I didnt have any data
 there
 and thus no upgrade was needed as such.
 I used typical install option and after the install i used the standard
 configuration for the server configuration wizard. i typed the password
 required and the problems started.

 1. It couldnot install mysql as a service, named MySQL, although there is
 no
 service with that name. i checked with the service option in control panel.

 2. I went back and installed it with the service name MySQL5. This time, it
 installed the service, but could not apply the security setting and
 terminated with the error, saying root doesnot have the permission to log
 on
 from localhost.

 3. I opened the command line clien from the start menu. It asked for the
 password, i typed it in and the interface disappeared.

 I uninstalled and then installed it again a couple of times, but one or the
 other erroe kept reccuring. I'm still havent been able to use MySQL.

 Please Help.

RE: Installation Problems

[Rolando Edwards]

Ever since MySQL 5.0.27, I have never been able to install the MySQL Service 
either.
I think this has something to do with the way Microsoft compiles its OS 
Services.

I use the no installer version now.

1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32
2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a Windows 
Explorer Window in that new empty Folder.
3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop
4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window 
opens up containing the folder 'mysql-noinstall-5.1.32-win32'
5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another window 
shows the folders 'bin','data','Docs' and so forth.
6. Select all files and folders by hitting Ctrl-A
7. Drag and Drop those selected files and folders into the 'C:\ MySQL_5.1.32' 
Window
8. Right-click on 'My Computer', and click on 'Properties'
9. Click on the Advanced Tab
10. Click the Environment Variables button
11. Scroll the bottom listbox to the PATH variable
12. Double Click the PATH variable
13. Append ';C:\MySQL_5.1.32' to the PATH variable
14. Click OK 3 times
15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other words, 
copy mysql-small.ini to my.ini)
If you do not do this, you will be starting mysqld with all server 
defaults
16. Create a DOS Batch File called start_mysqld.bat with the following lines
@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
echo %MYSQL_BIN%
cd %MYSQL_BIN%
pause (This line is optional)
start mysqld
17. Create a DOS Batch File called stop_mysqld.bat with the following lines
@echo off
set MYSQL_HOME=C:\MySQL_5.1.32
set MYSQL_BIN=%MYSQL_HOME%\bin
%MYSQL_BIN%\mysqladmin -uroot shutdown
18. Create a ShortCut for both batch files and place them on the Desktop
19. Double Click the ShortCut for start_mysqld.bat
This should start up mysqld
Open the task manager and look for 'mysqld.exe'
20. Goto a new DOS Window and type 'mysql -uroot'
You should be mysql now.

If you got to this point successfully, have fun from here !!!

Rolando A. Edwards
MySQL DBA (CMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
redwa...@logicworks.net

-Original Message-
From: Manish Gupta [mailto:manish.in@gmail.com] 
Sent: Tuesday, March 24, 2009 4:05 PM
To: mysql@lists.mysql.com
Subject: Installation Problems

I had MySQL 4.0.
Today i downloaded the recent version, mysql5.12.32-Win32 installer.
I deleted the older verison of mysql that i had. I didnt have any data there
and thus no upgrade was needed as such.
I used typical install option and after the install i used the standard
configuration for the server configuration wizard. i typed the password
required and the problems started.

1. It couldnot install mysql as a service, named MySQL, although there is no
service with that name. i checked with the service option in control panel.

2. I went back and installed it with the service name MySQL5. This time, it
installed the service, but could not apply the security setting and
terminated with the error, saying root doesnot have the permission to log on
from localhost.

3. I opened the command line clien from the start menu. It asked for the
password, i typed it in and the interface disappeared.

I uninstalled and then installed it again a couple of times, but one or the
other erroe kept reccuring. I'm still havent been able to use MySQL.

Please Help.

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

Re: Installation problems with MySql 5.0.41 (source distribution)

[Geoffroy Cogniaux]

Hi,

You're running MySQL with a mysql linux user, verify that he have
write access on mysql datadir. You should specify it with --datadir=
at command line invoking mysql_install_db too.

2007/6/16, [EMAIL PROTECTED] [EMAIL PROTECTED]:


Hi everybody,

I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box.

In doing so, I am getting some errors with mysql_install_db (ERROR: 1049
Unknown database 'mysql', Installation of system tables failed!)

Please let me know how to solve the problem.

Thanks in advance for your time and help.

Anand

Here are the details pertaining to my problem:

I used this as a guide:
http://dev.mysql.com/doc/refman/5.0/en/quick-install.html:

and followed all the steps. The following error(s) comes when I try using
mysql_install_db

/usr/local/mysql/bin/mysql_install_db --user=mysql
Installing MySQL system tables...
ERROR: 1049  Unknown database 'mysql'
070616  1:24:38 [ERROR] Aborting
070616  1:24:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
Installation of system tables failed!

Examine the logs in /usr/local/mysql/var for more information.
You can try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant 
and use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:

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

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

And then, when I do /usr/local/mysql/libexec/mysqld --skip-grant  as
suggested in the above error message, it just aborts.

Here is the architecture info. from mysqlbug
--
Release:   mysql-5.0.41 (Source distribution)
C compiler:gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
C++ compiler:  g++ (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
Environment:
machine, os, target, libraries (multiple lines)
System: Linux 2.6.3-7mdk #1 Wed Mar 17 15:56:42 CET 2004 i686 unknown
unknown GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.3.2/specs
Configured with: ../configure --prefix=/usr --libdir=/usr/lib
--with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info
--enable-shared --enable-threads=posix --disable-checking
--enable-long-long --enable-__cxa_atexit --enable-clocale=gnu
--enable-languages=c,c++,ada,f77,objc,java,pascal
--host=i586-mandrake-linux-gnu --with-system-zlib
Thread model: posix
gcc version 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx  1 root root 13 Sep 13  2004 /lib/libc.so.6 - libc-2.3.3.so
-rwxr-xr-x  1 root root 1281788 Feb 16  2004 /lib/libc-2.3.3.so
-rw-r--r--  1 root root 204 Feb 16  2004 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-unix\
-socket-path=/usr/local/mysql/tmp/mysql.sock'
--


--
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: Installation problems with W2K

[David M Friscia]

Murdoch Mactaggart ,
The WINDOWS Environment needs the --console switch in order to output the
return of mysqld to DOS commands.
Please ref to: http://lists.mysql.com/list.php?list=win32#b

my.cnf will never be looked for by the WINDOWS Binary. Return to using
my.ini from the C:\%Windows Directory%

WinMySqlAdmin is an administration GUI automatically installed in the
mysql\bin subdirectory.
The 'Control Center', MySQL Control Center, can be downloaded and installed
as the Operational GUI. Several Others are available.

RE:  I'm somewhat unclear (and can find nothing particular relevant on the
site or in the manual) as to whether MySQL functions merely as an engine or
whether there is an associated UI. That is, can it be used with ordinary
desktop clients and, if so how, or is it intended purely for use through
appropriate programmed interfaces?
That depends on your installation. Your options are explained at the MySQL
Products WWW Site page.

David M Friscia
friscia.rootsweb.com http://friscia.rootsweb.com
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


-Original Message-
From: Murdoch Mactaggart [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 8:54 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Installation problems with W2K


Hi

I'm unclear whether the address I'm using here (referenced on page 29
of the manual) is the correct one but I hope one of them may either
get me an answer or a reference to where else I might seek help.

DETAILS

OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195
MySQL version 4.0.13 for Windows, binary (mysql-4.0.13-win.zip)

System: self constructed with AMD750MHz Athlon on Biostar M7MKE system
board with VIA VT8371 and Award BIOS v6.00PG; 785,904KB RAM; ATI
All-in-Wonder Pro video card; part of an Ethernet LAN on a 192.168.1
subnet, connecting to the internet through a Vigor 2000 router using
ISDNe. TCP/IP is installed and working.

There are two physical HDD, Disc0 of 12.66GB and Disc1 of 12.64GB.
These are divided into logical drives C: (Windows, 2.00GB), D:
(programs, 3.00GB), E: (Data, 4.00GB), F: (Backup_Store, 3.65GB)
[Disc0], G: (Large_Data, 1.95GB) and F: (Recordings, 10.69GB). There
is also a DVD drive designated as Z:. All HDDs are formatted as NTFS.


PROBLEM

The binary download was unzipped to a temporary file and setup run.
This appeared to work correctly and the installation was made to
D:\Program Files\MySQL with the data directory being set to
e:\MySQL\data (and everything from the original ..\data directory
moved to there).

I then followed the instructions and created a file My.ini containing
the installation address and data location addresses and placed this
in C:\winnt.

I then followed the instructions in the manual at 2.1.2, brought up a
DOS box, changed to the ..\bin directory and entered mysqld
--standalone. This gave some disc activity, the cursor moved to the
next line and nothing else happened. I was unable to move the cursor
or to enter anything further but I could close the command line
window.

Checking showed that the mysqld process had run for one second and
could duly be removed.

I have:
  renamed the my.ini file my.cnf and moved it to c:\
  reinstalled from the exisitng zip file
  redownloaded the zipped binaries and reinstalled
  moved the ..\data directory back to the default (and duly edited the
  configuration files)

getting in each case identical results.

If I run mysqld.exe from the Windows desktop then the command
window flashes up briefly and nothing further happens.

Suggestions, help or pointers elsewhere here would be much
appreciated.


Secondly, I'm somewhat unclear (and can find nothing particular
relevant on the site or in the manual) as to whether MySQL functions
merely as an engine or whether there is an associated UI. That is, can
it be used with ordinary desktop clients and, if so how, or is it
intended purely for use through appropriate programmed interfaces?


Thanks in advance

Regards

Murdoch Mactaggart  mailto:[EMAIL PROTECTED]


--
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: Installation problems

[Sherif D Mohamad]

Thanks you
I didn't see this client as I installed MySQL-MAX from
http://www.mysql.com/downloads/mysql-max-3.23.html (no client here) :)

instead of
http://www.mysql.com/downloads/mysql-3.23.html


Best regards and thank you again
Sherif

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 6:59 AM
Subject: re: Installation problems


 Sherif,
 Tuesday, September 24, 2002, 2:16:13 AM, you wrote:

 SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
 SDM While installation it asked me to change DB root password using
mysqladmin

 SDM I looked for mysqladmin and didn't find it !! not all the files were
 SDM installed.

 SDM I looked into the documentation and it said for linux, using RPM,
install
 SDM these 2 files  MySQL-VERSION.i386.rpm  and
MySQL-client-VERSION.i386.rpm

 SDM I have the rpm for the server but I looked on www.mysql.com for
 SDM MySQL-client-VERSION.i386.rpm but could not find any RPMs for the
client (or
 SDM any installation files to install clinet)

 Yes, you need to install MySQL-client-VERSION.i386.rpm, too. Take a
 look carefully here:
  http://www.mysql.com/downloads/mysql-3.23.html


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





 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Installation problems

[Victoria Reznichenko]

Sherif,
Tuesday, September 24, 2002, 2:16:13 AM, you wrote:

SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm
SDM While installation it asked me to change DB root password using mysqladmin

SDM I looked for mysqladmin and didn't find it !! not all the files were
SDM installed.

SDM I looked into the documentation and it said for linux, using RPM, install
SDM these 2 files  MySQL-VERSION.i386.rpm  and MySQL-client-VERSION.i386.rpm

SDM I have the rpm for the server but I looked on www.mysql.com for
SDM MySQL-client-VERSION.i386.rpm but could not find any RPMs for the client (or
SDM any installation files to install clinet)

Yes, you need to install MySQL-client-VERSION.i386.rpm, too. Take a
look carefully here:
 http://www.mysql.com/downloads/mysql-3.23.html


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





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installation problems on AIX 4.3.3

[Morris Ford]

I have picked up the 3.23.51 binary install and I
am getting the same errors as with 3.23.50.
What's next?
Morris Ford

--- Victoria Reznichenko
[EMAIL PROTECTED] wrote:
 Morris,
 Thursday, June 06, 2002, 6:17:57 AM, you wrote:
 
 MF I am having a problem installing version
 3.23.50
 MF on AIX 4.3.3. When I execute
 mysql_install_db or
 MF try to start mysqld I get errors like
 
 MF 0509-036 Cannot load program
 MF ./bin/my_print_defaults because of the
 following
 MF errors:
 
 [skip]
 
 MF I have chased through the mail archives and
 found
 MF messages with errors like this but found no
 fix
 MF but to try 2.23.50 (the one I am loading).
 Has
 MF this been resolved? Any help would be
 greatly
 MF appreciated.
 
 It's because of our wrong build. It's fixed in
 3.23.51 which should be
 out soon.
 
 MF Morris Ford
 
 
 
 
 -- 
 For technical support contracts, goto
 https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net
 http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria
 Reznichenko
  / /|_/ / // /\ \/ /_/ / /__  
 [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB /
 Ensita.net
___/   www.mysql.com
 
 
 
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the
 manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail

[EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 
 
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installation problems on AIX 4.3.3

[Morris Ford]

Borus,
Thanks for responding. I am attempting to
install a binary release not build from source.
Do you have any information regarding the errors
in my original post?
Thanks
Morris Ford

--- é¾?æf æ¨?(Borus.Kung)
[EMAIL PROTECTED] wrote:
 FYI
 
 this may help
 
 Borus
 
 - Original Message -
 å¯?件è??: Morris Ford [EMAIL PROTECTED]
 æ?¶ä»¶è??: [EMAIL PROTECTED]
 å,³é??æ-¥æ?Y: 2002å¹´6æ?^6æ-¥ AM 11:17
 主æ-¨: Installation problems on AIX 4.3.3
 
 
  I am having a problem installing version
 3.23.50
  on AIX 4.3.3. When I execute mysql_install_db
 or
  try to start mysqld I get errors like
 
  0509-036 Cannot load program
  ./bin/my_print_defaults because of the
 following
  errors:
 
  0509-130 Symbol resolution failed for
  my_print_defaults because:
 
  0509-136 Symbol stpcpy (number 45) is not
  exported from dependent module
  /usr/lib/libc.a(shr.o)
 
  0509-136 Symbol strnlen (number 46) is not
  exported from dependent module
  /usr/lib/libc.a(shr.o)
 
  I have chased through the mail archives and
 found
  messages with errors like this but found no
 fix
  but to try 2.23.50 (the one I am loading).
 Has
  this been resolved? Any help would be greatly
  appreciated.
  Morris Ford
 
 

__
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World
 Cup
  http://fifaworldcup.yahoo.com
 
 

-
  Before posting, please check:
 http://www.mysql.com/manual.php   (the
 manual)
 http://lists.mysql.com/   (the
 list archive)
 
  To request this thread, e-mail
 [EMAIL PROTECTED]
  To unsubscribe, e-mail

[EMAIL PROTECTED]
  Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 
 

 ATTACHMENT part 2 message/rfc822 name=Re_ Bug_
-_ AIX 4.3.3 ML10, IBM C_C++ 5.0.2.eml
 From: é¾?æf æ¨?(Borus.Kung)
 [EMAIL PROTECTED]
 To: morgan henning [EMAIL PROTECTED],
 [EMAIL PROTECTED]
 Subject: Re: Bug? - AIX 4.3.3 ML10, IBM C/C++
 5.0.2
 Date: Tue, 21 May 2002 09:17:14 +0800
 
 I encountered the same problem, then I simply
 commented the line in the
 system header file
 curses.h.
 but the error I got is a bit different, it
 said:
 declaration is not declaring anything
 something like this...
 
 another header I modified is the pthread.h
 
 but there is a problem with the AIX version,
 MySQL cannot shutdown
 I must use kill -9 [PID] to kill the
 safe_mysqld script and mysql processes.
 
 my AIX version is 4.3.3
 but the good news is the binary compiled in
 4.3.3 machine can run in 4.3.1
 
 my way is absolutely not good, but it seems
 work.
 
 I used this to configure:
 CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure
 --prefix=/mysql/mysql \
 --with-extra-charsets=complex --with-low-memory
 
 and you?
 
 Borus
 
 - Original Message -
 å¯?件è??: morgan henning
 [EMAIL PROTECTED]
 æ?¶ä»¶è??: [EMAIL PROTECTED]
 å,³é??æ-¥æ?Y: 2002å¹´5æ?^21æ-¥ AM 08:49
 主æ-¨: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2
 
 
  Hi.  I am trying to build MySQL 3.23.49, and
 I am having some problems.
  If anyone has any suggestions, they would be
 **much** appreciated :)
 
  I have tried to compile MySQL 3.23.49 a
 couple of ways under AIX, and
  I have gotten this twice (more info below):
 
  xlC -DUNDEF_THREADS_HACK -I./../include
 -I../include -I./.. -I.. -I.. -O3
  -DDBUG_OFF   -Wa,-many
 -DUNDEF_HAVE_INITGROUPS
 -DSIGNALS_DONT_BREAK_READ
  -c mysql.cc /usr/include/curses.h, line
 1751.14: 1540-0063 (S) The text
  bool is unexpected.
  gmake[2]: *** [mysql.o] Error 1
  gmake[2]: Leaving directory
 `/home/morgan/mysql-3.23.49/client'
  gmake[1]: *** [all-recursive] Error 1
  gmake[1]: Leaving directory
 `/home/morgan/mysql-3.23.49'
  gmake: *** [all-recursive-am] Error 2
 
  I got this on both AIX 4.3.3 (maintenance
 level 10 applied), and AIX 5.1.0
  (maintenance level 2 applied).  Both times I
 got the error, I was using
  the IBM C Compiler v5.0.2 and IBM C++
 Compiler v5.0.2 (Visual Age C++
  packages).
 
  The configure command line was CC=xlc
 CXX=xlC ./configure
  --prefix=/opt/mysql.
 
  I am using GNU make 3.79.1.
 
  The machine both times was an RS6000 43P-132
 (type 7248-132).
 
  I can provide all kinds of more information
 if you like :)
 
  I tried gcc-3.0.4, but that failed also,
 although I forget the exact
  error.  I am build gcc-2.95.3 in an effort to
 try the recommended gcc now.
  Nothing on that front yet.
 
  Am I just missing something with IBM C/C++ ??
  The compiler is not patched
  to the latest level, although I can patch it.
  It's just a big download (
  500 MB).  Please advise if you think that's
 the solution.
 
  Thanks!! :)
 
  --
  Morgan Henning
  [EMAIL PROTECTED]
 
 
 
 
 

-
  Before posting, please check:
 http://www.mysql.com/manual.php   (the
 manual)
 http://lists.mysql.com/   (the
 list archive)
 
  To request this thread, e-mail
 [EMAIL PROTECTED]
  To 

Re: Installation problems on AIX 4.3.3

[Victoria Reznichenko]

Morris,
Thursday, June 06, 2002, 6:17:57 AM, you wrote:

MF I am having a problem installing version 3.23.50
MF on AIX 4.3.3. When I execute mysql_install_db or
MF try to start mysqld I get errors like

MF 0509-036 Cannot load program
MF ./bin/my_print_defaults because of the following
MF errors:

[skip]

MF I have chased through the mail archives and found
MF messages with errors like this but found no fix
MF but to try 2.23.50 (the one I am loading). Has
MF this been resolved? Any help would be greatly
MF appreciated.

It's because of our wrong build. It's fixed in 3.23.51 which should be
out soon.

MF Morris Ford




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




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: installation problems on freebsd

[Defryn NZ]

I have started all over again on a fresh Freebsd installation.
I have all the files in my /usr/local/mysql directory and I run
Scripts/mysql_install_db

After that I take the following action

$ chown -R root /usr/local/mysql
$ chgrp -R mysql /usr/local/mysql
$ chown  -R mysql /usr/local/mysql/data

Than something happens that I don't really understand

When I run bin/safe_mysqld -user=mysql 

The daemon starts followed by the message that mysqld ended.
This does not seem to happen when I run bin/safe_mysqld . I don't know the
difference but the service keeps on running with the latter

I have copied support-files/mysql.server to /usr/local/etc/rc.d (the startup
directory) but when I reboot I have to start mysqld manual again

The ./bin/mysqladmin -p password does not seem to let me update the
password.

Any ideas?

Cheers


-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, 6 May 2002 8:27 a.m.
To: Defryn NZ
Cc: [EMAIL PROTECTED]
Subject: Re: installation problems on freebsd

On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote:


 Is /tmp/mysql.sock missing after you start the MySQL server using
 `bin/safe_mysqld'?

 When I run bin/safe_mysqld I get the message that it is unable to
 connect to 'hostname' through /tmp/mysql.sock and that it is missing

That's really strange.  Starting a MySQL server shouldn't ever result
in it attempting to contact itself via /tmp/mysql.sock.  It sounds
like something is rather messed up in your configuration.

Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 87 days, processed 2,267,702,000 queries (300/sec.
avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: installation problems on freebsd

[Defryn NZ]

Is /tmp/mysql.sock missing after you start the MySQL server using
`bin/safe_mysqld'?
  When I run bin/safe_mysqld I get the message that it is unable
to connect to 'hostname' through /tmp/mysql.sock and that it is missing

Cheers





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: installation problems on freebsd

[Jeremy Zawodny]

On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote:
 
 
 Is /tmp/mysql.sock missing after you start the MySQL server using
 `bin/safe_mysqld'?

 When I run bin/safe_mysqld I get the message that it is unable to
 connect to 'hostname' through /tmp/mysql.sock and that it is missing

That's really strange.  Starting a MySQL server shouldn't ever result
in it attempting to contact itself via /tmp/mysql.sock.  It sounds
like something is rather messed up in your configuration.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 87 days, processed 2,267,702,000 queries (300/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: installation problems on freebsd

[Jeremy Zawodny]

On Sun, May 05, 2002 at 04:02:44PM +1200, Defryn NZ wrote:
 I have been trying to install mysql on my freebsd box but it won't work.
 When I use a freebsd package it works but it does not put it where I want
 it. It seems like there is little control over it
 The freebsd package is also an older version (3.23.42)
 
 I have downloaded the binary for freebsd from the mysql website.
 I followed the instructions from the o'reilly book ,the mysql manual and the
 php/mysql web applications.
 
 Everything seems to work until I run ./mysqladmin or I want to start mysql.
 
 I get the error that /tmp/mysql.sock cannot be found. I can't see it
 there either.  It was there when installed it as a package

Is /tmp/mysql.sock missing after you start the MySQL server using
`bin/safe_mysqld'?
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 86 days, processed 2,253,883,132 queries (301/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installation Problems

[Miguel Angel Solorzano]

At 16:46 12/01/02 -0800, Mark Peterson wrote:
I'm having trouble with the installation of MySQL. The database was
installed on the C drive.
cut

Please follow the steps below:

- The instructions below assume that you have opened a prompt
   screen at c:\mysql\bin directory.

- After a boot, open the Task Manager (ALT+CTRL+DEL) and verify
   if exists a process for an MySQL server (mysqld.exe, mysqld-max.exe,
   mysqld-nt.exe, mysqld-max-nt.exe, mysqld-opt.exe).

   If yes, stop it with the following command at the prompt:

 net stop mysql (if the server was started as service)

 or

 mysqladmin shutdown (if the server was started as
 standalone mode).
 For NT server is necessary to make twice this command due a bug
 which should be fixed in the next release.
- If you had installed the service before, type the command:

   mysqld-max-nt --remove

- Type: mysqld-max-nt --install

- Go to c:\winnt directory and create a file named my.ini.
   Edit the lines below:

   [mysqld]
   basedir=c:\mysql
   datadir=c:\mysql\data
   skip-innodb

   Save the file and close it.

- Start the server:
   net start mysql

NOTE
If you want the support of InnoDB tables (I recommend to test), you
should need to read the Manual and remove the line skip-innodb from
the my.ini file.

Regards,
Miguel


-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Installation problems

[Mark Coetser]

Hi 

You need to start the server first, using the safe_mysqld daemon


-Original Message-
From: Rudi von Fintel [mailto:[EMAIL PROTECTED]]
Sent: 26 January 2001 13:30
To: [EMAIL PROTECTED]
Subject: Installation problems


I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL 
command, I get the following error: "Warning: MySQL Connection 
Failed: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (111)"
 What can I do to rectify this?
Rudi von Fintel
N Dip Electrical Engineering Light Current
Sugar Milling Research Institute
Durban
(tel) 031 2616882 ext 210
(fax) 031 2616886



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php