Re: how do I make utf8 the default encoding for my MySQL installation

[Reindl Harald]

Am 18.11.2011 04:31, schrieb Martin Mueller:
> [mysqld]
> init_connect=’SET collation_connection = utf8_general_ci’
> init_connect=’SET NAMES utf8′
> default-character-set=utf8
> character-set-server=utf8
> collation-server=utf8_general_ci
> skip-character-set-client-handshake

> On a Mac with MySQL 5.5.17 this produces the error
>  [ERROR] /usr/local/mysql/bin/mysqld: unknown variable
> 'default-character-set=utf8'


character-set-server = utf8
collation-server = utf8_general_ci

and done

"default-character-set" is an older option, was long time deprecated
and removed - you should NEVER paste options in your configs only
because some random guy say they do what you want before you
read the manuals what they are doing




signature.asc
Description: OpenPGP digital signature

Re: how do I make utf8 the default encoding for my MySQL installation

[Duane Hill]

On Friday, November 18, 2011 at 03:31:44 UTC, martin.muel...@mac.com 
confabulated:

> Is it possible to make utf8 the default for all databases and transactions
> in a MySQL installation?

> The current default is Latin1. There is a suggestion on the Web to edit
> the my.cnf file as follows


> [mysqld]
> init_connect=’SET collation_connection = utf8_general_ci’
> init_connect=’SET NAMES utf8′
> default-character-set=utf8
> character-set-server=utf8
> collation-server=utf8_general_ci
> skip-character-set-client-handshake

> On a Mac with MySQL 5.5.17 this produces the error

>  [ERROR] /usr/local/mysql/bin/mysqld: unknown variable
> 'default-character-set=utf8'

> The Reference Manual is very tortuous but lacks instructions that are
> clear to a not very technical user. 

http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-character-set

The above link says default-character-set is depreciated and you should
be   using  character-set-server. It also states default-character-set
was removed in v5.5.3.

You should be able to remove the option.

-- 
There  are  10  kinds  of  people in the world... Those who understand
binary, and those who don't.


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

how do I make utf8 the default encoding for my MySQL installation

[Martin Mueller]

Is it possible to make utf8 the default for all databases and transactions
in a MySQL installation?

The current default is Latin1. There is a suggestion on the Web to edit
the my.cnf file as follows


[mysqld]
init_connect=’SET collation_connection = utf8_general_ci’
init_connect=’SET NAMES utf8′
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake



On a Mac with MySQL 5.5.17 this produces the error

 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable
'default-character-set=utf8'

The Reference Manual is very tortuous but lacks instructions that are
clear to a not very technical user. 



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

Mysql installation - Innodb not enabled?

[Machiel Richards]

Good day all

We have downloaded the following MySQL version which untarred to
provide a list of RPM's:

MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.tar

The installations went through fine, however while doing some
configurations I found that Innodb is not enabled / installed.

When configuring the Innodb paramters in the log files, I get the
following errors when I try to start up the database:

101118 11:21:41 [ERROR] Plugin 'InnoDB' init function returned error.
101118 11:21:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
101118 11:23:51 [ERROR] Parsing options for plugin 'InnoDB' failed.
101118 11:23:51 [ERROR] /usr/sbin/mysqld: unknown variable
'innodb_flush_log_at_trx_commit=1'
101118 11:23:51 [ERROR] Aborting


 Could anyone please assist me with this issue. It would be much
appreciated.

FYI, the RPMS that came within the tar file are as follows:

MySQL-advanced-gpl-debuginfo-5.1.50-1.rhel5.x86_64.rpm  
MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm
MySQL-client-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm 
MySQL-shared-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm
MySQL-devel-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm  
MySQL-shared-compat-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm
MySQL-embedded-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm   
MySQL-test-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm

Regards
Machiel

Suggestion : Better error message for hostname resolution error during MySQL installation

[Jaikiran Pai]

Hello everyone,

Recently, while installing MySQL, I ran into an error[1] which complained about 
the hostname:
---
Neither host 'blahblah' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option
---

I looked a bit into the scripts/mysql_install_db script and was able to figure 
out what the "real" issue was (as explained in that blog[1]). In short, the 
/usr/bin/resolveip is a non-existent command (due to incorrect path). 

So, in such cases, would it be possible to print out a better error message 
which would tell the users what the real problem is? Something like:

"/usr/bin/resolveip" command not found. 
Make sure basedir (and other variables) point to the right location. 
Tip: resolveip can be located in the bin folder of MySQL download location.

[1] http://tinyurl.com/35l5lvg

regards,
-Jaikiran

MySQL Installation Not Working

[DPD]

Hi,
I've tried several times now to get a local installation of MySQL  
going on my iMac (w/ OS X ver. 10.5.6).   I've carefully tried  
everything I could comprehend to do per the mysql.com resource pages/ 
manual.   I have also tried several procedures I discovered via Google  
searches that seemed to be promising/authoritative.   Throughout this  
process I have encountered so many obstacles I've lost count.  I have  
deleted and reinstalled the whole MySQL package (mysql-5.1.32-osx10.5- 
x86.dmg)
4 times while trying to follow the documentation with excruciating  
attention to the detail and nuances.  I think I have encountered every  
version of 'permission denied', 'unable to open socket', unable to  
find 'my_print_defaults', 'unable to bind on port 3306', 'unable to  
access pid file' type of error possible.  I am absolutely drowning in  
barely comprehended documentation, tips and tricks  that have taken me  
down one dead end after another.   Is there any way an ordinary person  
who doesn't walk on water with UNIX and is not able to manufacture a  
supercomputer with his pocketknife can get a simple 'local' MySQL  
installation going on his Mac?  This is an appeal for help from  
someone who has wrestled with the official documentation to the point  
that it's liable to become a textbook case of 'terminal computer- 
frustration'.


I wasn't able to figure out exactly how to comply with your 'MUST use  
the ./bin/mysqlbug script!' directive so I've copied and pasted the  
results of running that script below (please accept my apologies if  
these results were supposed to be transmitted in a different way).



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: DPD
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]

>Description:

>How-To-Repeat:
lines)>

>Fix:
(multiple lines)>


>Submitter-Id:  
>Originator:
>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-5.1.32 (MySQL Community Server (GPL))

>C compiler:i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc.  
build 5465)
>C++ compiler:  i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc.  
build 5465)

>Environment:

System: Darwin DPD-Mac.local 9.6.0 Darwin Kernel Version 9.6.0: Mon  
Nov 24 17:37\

:00 PST 2008; root:xnu-1228.9.59~1/RELEASE_I386 i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using built-in specs.
Target: i686-apple-darwin9
Configured with: /var/tmp/gcc/gcc-5490~1/src/configure --disable- 
checking -enabl\
e-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c+ 
+,obj-c++\
 --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include- 
dir=/includ\
e/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with- 
arch=apple\
 --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple- 
darwin9

Thread model: posix
gcc version 4.0.1 (Apple Inc. build 5490)
**
Regards,
Dennis

Re: MySQL installation failure

[Greg 'groggy' Lehey]

On Wednesday,  1 February 2006 at 15:01:15 -0600, Hong Li wrote:
> Hi
>
> I am doing investigation to determine whether we can use MySQL in
> our project.  But I got error message when I try to install MySQL on
> Unix server.  Could you please help me?

> group name  not found in group table(s)

This suggests that you're using a BSD-style package.  BSD systems have
group wheel, many UNIX systems don't.  Can you give details of your
system and what version of MySQL you're trying to install?

Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286   Mobile: +61-418-838-708
VoIP:  sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]

Are you MySQL certified?  http://www.mysql.com/certification/


pgpTPx3cLWuAB.pgp
Description: PGP signature

MySQL installation failure

[Hong Li]

Hi 

I am doing investigation to determine whether we can use MySQL in our
project.
But I got error message when I try to install MySQL on Unix server.
Could you 
please help me?

First I uncompress with gunzip, then I use pkgadd to install, and I got
the following
error message:

group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of  failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of
 failed
group name  not found in group table(s)
ERROR: attribute verification of 
failed
group name  not found in group table(s)
ERROR: attribute verification of  failed
group name  not found in group table(s)
ERROR: attribute verification of  failed
group name  not found in group table(s)
## Executing postinstall script.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/mysql/bin/mysqladmin -u root -h zrc2s153 password
'new-password'
See the manual for more instructions.

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Installation of  partially failed.


Thanks,
Hong

Re: MySQL installation problems.

[Gleb Paharenko]

Hello.



Is this a clean new install of MySQL, or you have already installed

MySQL instance? Please provide more information about your OS version

(I guess it is Windows, isn't it?). May be some tips from the manual

could be helpful:

  http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html

  http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html







Kevin Pollard wrote:

> Today I downloaded and installed MySQL 5.0 (the "Complete Package").

> 

> Everything seemed to go with the install until it got to the "Processing

> configuration..." stage.

> It successfully completed "Prepare configuration", and "Write

> configuration file", and "Start service".

> 

> But it failed when it got to "Apply security settings" with the error

> message "The security settings could not be applied. Error number 2003.

> Can't connect ot MySQL server on 'locahost' (10061)

> 

> What can I do about that?

> 

> 

> Kevin

> 

> 

> 



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

MySQL installation problems.

[Kevin Pollard]

Today I downloaded and installed MySQL 5.0 (the "Complete Package").

Everything seemed to go with the install until it got to the "Processing 
configuration..." stage.
It successfully completed "Prepare configuration", and "Write configuration 
file", and "Start service".


But it failed when it got to "Apply security settings" with the error 
message "The security settings could not be applied. Error number 2003. 
Can't connect ot MySQL server on 'locahost' (10061)


What can I do about that?


Kevin



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

RE: a question about MySQL installation

[Bartis, Robert M (Bob)]

Suggest you review the MySQL documentation 
http://dev.mysql.com/doc/mysql/en/installing.html and in particular 2.3.13. 
Testing The MySQL Installation and 2.3.14. Troubleshooting a MySQL Installation 
Under Windows 

Bob

-Original Message-
From: Terry Leung [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 22, 2005 7:12 AM
To: mysql@lists.mysql.com
Subject: a question about MySQL installation


Dear,

I have installed MySQL4.1. But why it can not startup when I open my computer?
Also, how can I test MySQL can run or not? Thanks for your advice.

Best Regards,
Terry

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

a question about MySQL installation

[Terry Leung]

Dear,

I have installed MySQL4.1. But why it can not startup when I open my computer?
Also, how can I test MySQL can run or not? Thanks for your advice.

Best Regards,
Terry

Trimming down a MySQL installation

[cristopher pierson ewing]

I am installing MySQL on a server with limited space available and I'd 
like to minimize the footprint of the installed database.  is there 
information available on what parts of the installation I can safely 
delete without harming functionality of the database?

I'd love to hear recommendations from the experts out there before I just 
hack-and-slash through the mysql directory.

Thanks in advance,
Cris

Cris Ewing
CME and Telehealth Web Services
University of Washington
School of Medicine
Work Phone: (206) 685-9116
Home Phone: (206) 365-3413
E-mail: [EMAIL PROTECTED]
***
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql installation information

[Kevin Cowley]

If the Redhat Enterprise edition is anything like the SuSE Enterprise
then you have Mysql installed already. It won't be 4.1.10a most likely
4.0.x.
Just down load the 4.1.10a rpm and install it over the top of the
existing version.

Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web: www.alchemetrics.co.uk
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Suryya Ghosh [mailto:[EMAIL PROTECTED]
> Sent: 01 April 2005 12:05
> To: mysql@lists.mysql.com
> Subject: Mysql installation information
> 
> Hi,
> 
> I have gone through the sites which you have recomended where it is
> suggested that the exact version depends on the requirement and the
> hardware.
> 
> According to our hardware & software specification which is given
below, I
> think we should use (Linux (x86, glibc-2.2, static, gcc),Standard
4.1.10a
> )  version of  mysql server.
> 
> I have no previous experience regarding installing mysql so it will be
a
> great help if  let me know your openion about it.
> Can you please review the URL
> http://dev.mysql.com/downloads/mysql/4.1.html and recomend the exact
> version which will go best with the server.
> 
> Server Configuration
> -
> Server:  Dual Xeon 2.8 GHz ( X86,32 bit,533MHz FSB,512KB L2 cache)
> Primary HDD:  73 GB SCSI
> RAM:  ECC Registered 1024MB RAM
> Bandwidth:  2000 GB Bandwidth
> Uplink Port Speed:  100 Mbps Uplink
> Operating System:  Red Hat Enterprise Linux, Version 3 (recommended)
> Drive Controller:  SCSI
> Chassis Control:  DRAC Card
> 
> 
> With Regards,
> 
> Suryya


**
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must 
not use, copy, disclose, otherwise disseminate or take any action based on this 
e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception and 
unauthorised amendment.  Alchemetrics does not accept any liability for 
any such corruption, interception, amendment or the consequences thereof.
**


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

Re: Mysql installation information

[Digvijoy Chatterjee]

download the source tar ball and
try installing mysql from the source the configure script does it all 
you , u dont need to worry,
for custom compilation use ./configure --help

Regards
Digvijoy Chatterjee
Suryya Ghosh wrote:
Hi,
I have gone through the sites which you have recomended where it is suggested that the exact version depends on the requirement and the hardware.
   
According to our hardware & software specification which is given below, I think we should use (Linux (x86, glibc-2.2, static, gcc),Standard 4.1.10a )  version of  mysql server.

I have no previous experience regarding installing mysql so it will be a great 
help if  let me know your openion about it.
Can you please review the URL http://dev.mysql.com/downloads/mysql/4.1.html and 
recomend the exact version which will go best with the server.
Server Configuration
-
Server:  Dual Xeon 2.8 GHz ( X86,32 bit,533MHz FSB,512KB L2 cache)
Primary HDD:  73 GB SCSI
RAM:  ECC Registered 1024MB RAM
Bandwidth:  2000 GB Bandwidth
Uplink Port Speed:  100 Mbps Uplink
Operating System:  Red Hat Enterprise Linux, Version 3 (recommended)
Drive Controller:  SCSI
Chassis Control:  DRAC Card
With Regards,
Suryya
 


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

Mysql installation information

[Suryya Ghosh]

Hi,

I have gone through the sites which you have recomended where it is suggested 
that the exact version depends on the requirement and the hardware.

According to our hardware & software specification which is given below, I 
think we should use (Linux (x86, glibc-2.2, static, gcc),Standard 4.1.10a )  
version of  mysql server.

I have no previous experience regarding installing mysql so it will be a great 
help if  let me know your openion about it.
Can you please review the URL http://dev.mysql.com/downloads/mysql/4.1.html and 
recomend the exact version which will go best with the server.

Server Configuration
-
Server:  Dual Xeon 2.8 GHz ( X86,32 bit,533MHz FSB,512KB L2 cache)
Primary HDD:  73 GB SCSI
RAM:  ECC Registered 1024MB RAM
Bandwidth:  2000 GB Bandwidth
Uplink Port Speed:  100 Mbps Uplink
Operating System:  Red Hat Enterprise Linux, Version 3 (recommended)
Drive Controller:  SCSI
Chassis Control:  DRAC Card


With Regards,

Suryya

Re: Mysql installation

[Andy Pieters]

Hi Suryya

I don't want to offend you but this information can be found on the MySql 
website.

Choosing wich version to install:
http://dev.mysql.com/doc/mysql/en/choosing-version.html

Choosing a distribution format
http://dev.mysql.com/doc/mysql/en/choosing-distribution-format.html

Download page
http://dev.mysql.com/downloads/

With kind regards

Andy Pieters

On Thursday 31 March 2005 14:55, Suryya Ghosh wrote:
> Hi,
>
> We have server with the following hardware specification:
>
>  Server:  Dual Xeon 2.8 GHz
>  Primary HDD:  73 GB SCSI
>  RAM:  ECC Registered 1024MB RAM
>  Bandwidth:  2000 GB Bandwidth
>  Uplink Port Speed:  100 Mbps Uplink
>  Operating System:  Red Hat Enterprise Linux, Version 3 (recommended)
>  Drive Controller:  SCSI
>  Chassis Control:  DRAC Card
>
> Can any body suggest which exact version of mysql will give optimum
> performance in this hard ware, will an RPM installation will be the best
> one we should  compile it from source using an particulat gcc compiler.
>
> With Regards,
>
> Suryya

-- 
Registered Linux User Number 379093
--
Feel free to check out these few
php utilities that I released under the GPL2 and 
that are meant for use with a php cli binary:
http://www.vlaamse-kern.com/sas/
--


pgpo80o6RLjwa.pgp
Description: PGP signature

Mysql installation

[Suryya Ghosh]

Hi,

We have server with the following hardware specification:

 Server:  Dual Xeon 2.8 GHz
 Primary HDD:  73 GB SCSI
 RAM:  ECC Registered 1024MB RAM
 Bandwidth:  2000 GB Bandwidth
 Uplink Port Speed:  100 Mbps Uplink
 Operating System:  Red Hat Enterprise Linux, Version 3 (recommended)
 Drive Controller:  SCSI
 Chassis Control:  DRAC Card

Can any body suggest which exact version of mysql will give optimum 
performance in this hard ware, will an RPM installation will be the best one we 
should  compile it from source using an particulat gcc compiler.

With Regards,

Suryya

 

Re: mysql installation

[SGreen]

I recommend starting with the online manual. It has a section on 
installation and a short tutorial section to help you get used to the 
MySQL client.

http://dev.mysql.com/doc/mysql/en/index.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Caulfield, Linda" <[EMAIL PROTECTED]> wrote on 09/17/2004 12:41:54 
PM:

> Hello,
> 
> I am trying to setup mysql and need some guidance -
> 
> thanks
> 
> Linda Caulfield
> Software Quality Engineer 
> Global Hawk Program 
> Rancho Bernardo X4680
> Phone:858.618.4680
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 

Re: mysql installation

[legalois]

Caulfield, Linda wrote:
Hello,
I am trying to setup mysql and need some guidance -
thanks
Linda Caulfield
Software Quality Engineer 
Global Hawk Program 
Rancho Bernardo X4680
Phone:858.618.4680


 

Linda -
MySQL, 2d Ed., by Paul Dubois is hard to beat.
It provides a lot of guidance.
- offbyone
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql installation

[Caulfield, Linda]

Hello,

I am trying to setup mysql and need some guidance -

thanks

Linda Caulfield
Software Quality Engineer 
Global Hawk Program 
Rancho Bernardo X4680
Phone:858.618.4680



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

Re: MySQL Installation Problem

[Kofirowster]

First, you'll get more help if you post to the list (Mysql General mailing
list <[EMAIL PROTECTED]>)

All the --console does is directs error messages to the console, i.e., the
dos window you have open.
If you leave it off the error messages go to a file.
What you describe below
> without --console as para I'm able to start the
> server.
 is _not_ the server starting correctly. It's _not_ starting and the error
message is going to file when you do it without the --console.
If it had started you would not have gotten back to the prompt, it would
just never come back until the server was stopped elsewhere.


- Original Message -
From: "Chukkala Bhaskar" <[EMAIL PROTECTED]>
To: "Kofirowster" <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 10:28 PM
Subject: Re: MySQL Installation Problem


> Hi guys,
> I'm new to MySQL.
>
> I tried the following on my test pc with Win98.
> It gave me error if I use --console as para.
> Any clue?
>
> without --console as para I'm able to start the
> server.
>
> Regards
>
> D:\MySQL\bin>mysqld --console
> 040618 13:11:07  InnoDB: Operating system error number
> 32 in a file operation.
> InnoDB: See http://www.innodb.com/ibman.php for
> installation help.
> InnoDB: See section 13.2 at
> http://www.innodb.com/ibman.php
> InnoDB: about operating system error numbers.
> InnoDB: File name .\ibdata1
> InnoDB: File operation call: 'open'.
> InnoDB: Cannot continue operation.
>
> D:\MySQL\bin>mysqld
>
> D:\MySQL\bin>
>
>
>
> --- Kofirowster <[EMAIL PROTECTED]> wrote:
> > I have a windows installation of myql. The links
> > Michael gave give correct
> > info.
> > Here's a synopsis:
> > To test a mysql install on windows open the
> > mysql/bin dir in a dos window.
> > At the prompt type
> > mysqld --console
> >
> > you should get a message back that indicates the
> > server is running, such as
> > mysqld: ready for connections
> >
> > open a second dos window at the same location and at
> > the prompt type
> > mysql
> >
> > you should get a message back similar to this where
> > the x's are replaced by
> > the version you are running:
> > Welcome to the MySQL monitor.  Commands end with ;
> > or \g.
> > Your MySQL connection id is 1 to server version:
> > x.xx.xx-debug
> >
> > Type 'help' for help.
> >
> > mysql>
> >
> > HTH,
> > Johnny
> > - Original Message -
> > From: "Michael Stassen"
> > <[EMAIL PROTECTED]>
> > To: "Singh, Bijay" <[EMAIL PROTECTED]>
> > Cc: "Mysql General mailing list"
> > <[EMAIL PROTECTED]>
> > Sent: Thursday, June 17, 2004 11:01 AM
> > Subject: Re: MySQL Installation Problem
> >
> >
> > >
> > > I'm including the list on this.  In general, you
> > will get better and
> > faster
> > > responses if you keep threads on the list.
> > >
> > > I've never run the mysql server under Windows, but
> > I assume the manual is
> > > accurate
> >
> <http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html>
> > > and
> > <http://dev.mysql.com/doc/mysql/en/NT_start.html>.
> > >
> > > You must configure phpmyadmin so that when it
> > attempts to connect to
> > mysql,
> > > it uses a username-password combination that mysql
> > will accept.  If you
> > have
> > > a mysql user with no password, you can use that,
> > but I wouldn't recommend
> > > allowing any unauthenticated connections to mysql.
> >  See the manual for
> > more
> > >
> >
> <http://dev.mysql.com/doc/mysql/en/Default_privileges.html>.
> > >
> > > Michael
> > >
> > > Singh, Bijay wrote:
> > >
> > > > I am using localhost with no password. how do
> > check whether MySQL is
> > > running or not. If not how do I start the MySQL on
> > Windows ?
> > > >
> > > >
> > > > -Original Message-
> > > > From: Michael Stassen
> > [mailto:[EMAIL PROTECTED]
> > > > Sent: Thursday, June 17, 2004 1:29 PM
> > > > To: [EMAIL PROTECTED]
> > > > Cc: Singh, Bijay; [EMAIL PROTECTED]
> > > > Subject: Re: MySQL Installation Problem
> > > >
> > > >
> > > > First, make sure mysql server is running.
> > > >
> > > > Second, make sure you have properly

Re: MySQL Installation Problem

[Kofirowster]

I have a windows installation of myql. The links Michael gave give correct
info.
Here's a synopsis:
To test a mysql install on windows open the mysql/bin dir in a dos window.
At the prompt type
mysqld --console

you should get a message back that indicates the server is running, such as
mysqld: ready for connections

open a second dos window at the same location and at the prompt type
mysql

you should get a message back similar to this where the x's are replaced by
the version you are running:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: x.xx.xx-debug

Type 'help' for help.

mysql>

HTH,
Johnny
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Singh, Bijay" <[EMAIL PROTECTED]>
Cc: "Mysql General mailing list" <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 11:01 AM
Subject: Re: MySQL Installation Problem


>
> I'm including the list on this.  In general, you will get better and
faster
> responses if you keep threads on the list.
>
> I've never run the mysql server under Windows, but I assume the manual is
> accurate
<http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html>
> and <http://dev.mysql.com/doc/mysql/en/NT_start.html>.
>
> You must configure phpmyadmin so that when it attempts to connect to
mysql,
> it uses a username-password combination that mysql will accept.  If you
have
> a mysql user with no password, you can use that, but I wouldn't recommend
> allowing any unauthenticated connections to mysql.  See the manual for
more
> <http://dev.mysql.com/doc/mysql/en/Default_privileges.html>.
>
> Michael
>
> Singh, Bijay wrote:
>
> > I am using localhost with no password. how do check whether MySQL is
> running or not. If not how do I start the MySQL on Windows ?
> >
> >
> > -Original Message-----
> > From: Michael Stassen [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 17, 2004 1:29 PM
> > To: [EMAIL PROTECTED]
> > Cc: Singh, Bijay; [EMAIL PROTECTED]
> > Subject: Re: MySQL Installation Problem
> >
> >
> > First, make sure mysql server is running.
> >
> > Second, make sure you have properly configured phpmyadmin in file
> > config.inc.php.  In particular, you have to set how phpmyadmin will
connect
> > to mysql (user and pass).
> >
> > Michael
> >
> > Daniel Clark wrote:
> >
> >
> >>After the phpmyadmin login I got the same error.
> >>
> >>In the phpmyadmin config files I had to set the local IP address that
> >>phpmyadmin was on.
> >
> >
> > Strange.  Didn't it default to localhost?
> >
> >
> >>>Dear Michael,
> >>>
> >>>I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m
not
> >>>able to get this rite.
> >>>
> >>>
> >>>I am trying to instal MySQL with phpMyAdmin and i get the error  when
view
> >>
> >>>from :
> >>
> >>>http://localhost/phpMyAdmin/
> >>>
> >>>
> >>>#2003 - Can't connect to MySQL server on 'localhost' (10061)
> >>>
> >>>OS - WinXP Pro
> >>>Apache
> >>>phpMyAdmin 2.5.7
> >>>
> >>>I tried reinstalling but not able to get. I checked Apache and php they
> >>>work fine except mySQL.
> >>>
> >>>Any help will be appreciated. Feel free to email or contact me on phone
#
> >>>below.
> >>
> >>
> >
> >
>
>
> --
> 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: MySQL Installation Problem

[Michael Stassen]

I'm including the list on this.  In general, you will get better and faster 
responses if you keep threads on the list.

I've never run the mysql server under Windows, but I assume the manual is 
accurate <http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html> 
and <http://dev.mysql.com/doc/mysql/en/NT_start.html>.

You must configure phpmyadmin so that when it attempts to connect to mysql, 
it uses a username-password combination that mysql will accept.  If you have 
a mysql user with no password, you can use that, but I wouldn't recommend 
allowing any unauthenticated connections to mysql.  See the manual for more 
<http://dev.mysql.com/doc/mysql/en/Default_privileges.html>.

Michael
Singh, Bijay wrote:
I am using localhost with no password. how do check whether MySQL is
running or not. If not how do I start the MySQL on Windows ?

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 1:29 PM
To: [EMAIL PROTECTED]
Cc: Singh, Bijay; [EMAIL PROTECTED]
Subject: Re: MySQL Installation Problem
First, make sure mysql server is running.
Second, make sure you have properly configured phpmyadmin in file 
config.inc.php.  In particular, you have to set how phpmyadmin will connect 
to mysql (user and pass).

Michael
Daniel Clark wrote:

After the phpmyadmin login I got the same error.
In the phpmyadmin config files I had to set the local IP address that
phpmyadmin was on.

Strange.  Didn't it default to localhost?

Dear Michael,
I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not
able to get this rite.
I am trying to instal MySQL with phpMyAdmin and i get the error  when view

from :

http://localhost/phpMyAdmin/
#2003 - Can't connect to MySQL server on 'localhost' (10061)
OS - WinXP Pro
Apache
phpMyAdmin 2.5.7
I tried reinstalling but not able to get. I checked Apache and php they
work fine except mySQL.
Any help will be appreciated. Feel free to email or contact me on phone #
below.



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

Re: MySQL Installation Problem

[Michael Stassen]

First, make sure mysql server is running.
Second, make sure you have properly configured phpmyadmin in file 
config.inc.php.  In particular, you have to set how phpmyadmin will connect 
to mysql (user and pass).

Michael
Daniel Clark wrote:
After the phpmyadmin login I got the same error.
In the phpmyadmin config files I had to set the local IP address that
phpmyadmin was on.
Strange.  Didn't it default to localhost?

Dear Michael,
I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not
able to get this rite.
I am trying to instal MySQL with phpMyAdmin and i get the error  when view
from :
http://localhost/phpMyAdmin/
#2003 - Can't connect to MySQL server on 'localhost' (10061)
OS - WinXP Pro
Apache
phpMyAdmin 2.5.7
I tried reinstalling but not able to get. I checked Apache and php they
work fine except mySQL.
Any help will be appreciated. Feel free to email or contact me on phone #
below.



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

Re: MySQL Installation Problem

[Daniel Clark]

After the phpmyadmin login I got the same error.

In the phpmyadmin config files I had to set the local IP address that
phpmyadmin was on.

> Dear Michael,
>
> I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not
> able to get this rite.
>
>
> I am trying to instal MySQL with phpMyAdmin and i get the error  when view
> from :
>
> http://localhost/phpMyAdmin/
>
>
> #2003 - Can't connect to MySQL server on 'localhost' (10061)
>
> OS - WinXP Pro
> Apache
> phpMyAdmin 2.5.7
>
> I tried reinstalling but not able to get. I checked Apache and php they
> work fine except mySQL.
>
> Any help will be appreciated. Feel free to email or contact me on phone #
> below.


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

MySQL Installation Problem

[Singh, Bijay]

Dear Michael,
 
I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get 
this rite.
 
 
I am trying to instal MySQL with phpMyAdmin and i get the error  when view from :
 
http://localhost/phpMyAdmin/
 
 
#2003 - Can't connect to MySQL server on 'localhost' (10061)
 
OS - WinXP Pro
Apache 
phpMyAdmin 2.5.7
 
I tried reinstalling but not able to get. I checked Apache and php they work fine 
except mySQL.
 
Any help will be appreciated. Feel free to email or contact me on phone # below.
 
Thanks,

Bijay K. Singh 
(757) 664-6808 
Information Technology
City of Norfolk, VA. 
www.norfolk.gov  

 

Re: MySQL installation in Fedora Core 1

[Sami Maisniemi]

Daevid Vincent wrote:

Just make a symbolic link... Probably it's in /tmp

So as root,
 "ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock"
This is always an annoyance with mysql and redhat it seems. *sigh*

How exactly? I mean there cannot be a socket file in /tmp either, 
because MySQL does not even start properly. For example:

[EMAIL PROTECTED] smaisnie]# ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock
create symbolic link `/var/lib/mysql/mysql.sock' to `/tmp/mysql.sock'
ln: creating symbolic link `/var/lib/mysql/mysql.sock' to 
`/tmp/mysql.sock': No such file or directory

Regards Sami


 

-Original Message-
From: Sami Maisniemi [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 30, 2004 3:11 PM
To: [EMAIL PROTECTED]
Subject: MySQL installation in Fedora Core 1

I intend to build up a web server that is based on Fedora Core 1. 
Installation and configuration of Apache and PHP4 was pretty 
simple, but 
there are some problems in configuration of MySQL. I 
installed the MySQL 
server RPM included in the distribution.

Even in the MySQL pages it is mentioned that running 
"/etc/rc.d/init.d/mysqld start" is enough for 
post-installation process. 
However, there is no such file. Running "mysql" leads to an error:

[EMAIL PROTECTED] smaisnie]# mysql
ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)

Does anyone have any idea how to carry out post-installation process?

Regards Sami Maisniemi



--
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: MySQL Installation???

[Kirti S. Bajwa]

Hello List:

I have installed and tested freeRADIUS 0.9.3 & MySQL 5.?.? (latest dev
version). Now I want to install & test freeRADIUS & MySQL with InnoDB
tables.

I have researched GOOGLE & MySQL web site for information on installing
MySQL with InnoDB tables without success. I would appreciate if somebody
direct me to:

What version of MySQL do I need to install (with freeRADIUS) so I can use
InnoDB tables? I understand that installing MySQL with freeRADIUS requires a
specific MySQL version? Is it correct?

I would be more than happy to read the procedure if someone point me to the
chapter in MySQL Doc! I have not been able to find out myself.

Is it possible that there is no special separate procedure and that is why I
am missing it?

Thanks in advance.

Kirt

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

Re: MySQL installation in Fedora Core 1

[Victor Medina]

Hi!

simply put a pair of lines like these pointing out to the correct 
location of your mysql.sock:

socket  = /opt/mysql-4.0.18/mysql.sock

You'll need a line in your client and in your mysqld section of your 
my.cnf (mysql config file)

Best Regards!
Sami Maisniemi wrote:
I intend to build up a web server that is based on Fedora Core 1. 
Installation and configuration of Apache and PHP4 was pretty simple, but 
there are some problems in configuration of MySQL. I installed the MySQL 
server RPM included in the distribution.

8<

--

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|Tel: +58-241-8507325 - ext. 325   |
 ||Cel: +58-412-8859934  |
 ||geek by nature - linux by choice  |
 |...|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL installation in Fedora Core 1

[Daevid Vincent]

Just make a symbolic link... Probably it's in /tmp

So as root,
  "ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock"

This is always an annoyance with mysql and redhat it seems. *sigh*


> -Original Message-
> From: Sami Maisniemi [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, March 30, 2004 3:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL installation in Fedora Core 1
> 
> I intend to build up a web server that is based on Fedora Core 1. 
> Installation and configuration of Apache and PHP4 was pretty 
> simple, but 
> there are some problems in configuration of MySQL. I 
> installed the MySQL 
> server RPM included in the distribution.
> 
> Even in the MySQL pages it is mentioned that running 
> "/etc/rc.d/init.d/mysqld start" is enough for 
> post-installation process. 
> However, there is no such file. Running "mysql" leads to an error:
> 
> [EMAIL PROTECTED] smaisnie]# mysql
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/var/lib/mysql/mysql.sock' (2)
> 
> Does anyone have any idea how to carry out post-installation process?
> 
> Regards Sami Maisniemi
> 
> 
> 
> -- 
> 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: MySQL installation in Fedora Core 1

[jeffrey_n_Dyke]

I intend to build up a web server that is based on Fedora Core 1.
Installation and configuration of Apache and PHP4 was pretty simple, but
there are some problems in configuration of MySQL. I installed the MySQL
server RPM included in the distribution.

Even in the MySQL pages it is mentioned that running
"/etc/rc.d/init.d/mysqld start" is enough for post-installation process.
However, there is no such file. Running "mysql" leads to an error:


i'm not that familar with FC1, but
can you just cd into /path/to/mysql
and run
bin/mysqld_safe --user=mysql &

did you run scripts/mysql_install_db from /path/to/mysql ?  or is that
included as part of the rpm install.
that may not be needed, i've always installed the binaries on Solaris/RH8&9

HTH
jeff

--
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: MySQL installation in Fedora Core 1

[Donny Simonton]

Sami,
I run Fedora core 1 and haven't had any problems.

This is all you do if you want MySQL 4.1.1.

wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.1-1.i386.rpm/f
rom/http://mysql.mirrors.pair.com/
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.1-0.i386.rpm/f
rom/http://mysql.mirrors.pair.com/
wget
http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.1-0.i386.rpm/fr
om/http://mysql.mirrors.pair.com/
rpm -i MySQL-server-4.1.1-1.i386.rpm 
rpm -i MySQL-client-4.1.1-0.i386.rpm 
rpm -i MySQL-devel-4.1.1-0.i386.rpm 


Sorry, word wrap sucks.

Donny

> -Original Message-
> From: Sami Maisniemi [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 5:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL installation in Fedora Core 1
> 
> I intend to build up a web server that is based on Fedora Core 1.
> Installation and configuration of Apache and PHP4 was pretty simple, but
> there are some problems in configuration of MySQL. I installed the MySQL
> server RPM included in the distribution.
> 
> Even in the MySQL pages it is mentioned that running
> "/etc/rc.d/init.d/mysqld start" is enough for post-installation process.
> However, there is no such file. Running "mysql" leads to an error:
> 
> [EMAIL PROTECTED] smaisnie]# mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> 
> Does anyone have any idea how to carry out post-installation process?
> 
> Regards Sami Maisniemi
> 
> 
> 
> --
> 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]

MySQL installation in Fedora Core 1

[Sami Maisniemi]

I intend to build up a web server that is based on Fedora Core 1. 
Installation and configuration of Apache and PHP4 was pretty simple, but 
there are some problems in configuration of MySQL. I installed the MySQL 
server RPM included in the distribution.

Even in the MySQL pages it is mentioned that running 
"/etc/rc.d/init.d/mysqld start" is enough for post-installation process. 
However, there is no such file. Running "mysql" leads to an error:

[EMAIL PROTECTED] smaisnie]# mysql
ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)

Does anyone have any idea how to carry out post-installation process?

Regards Sami Maisniemi



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

Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server

[Mike Mapsnac]

Weird.  I cannot find the my.cnf (configuration file).. How that's possible?

Thanks


From: Victor Medina <[EMAIL PROTECTED]>
To: Mike Mapsnac <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Mysql Installation on Linux:  ERROR 2002: Can't connect 
tolocal MySQL server th
Date: Sun, 18 Jan 2004 10:24:53 -0400

Probably your server is not using any sockets, check out your my.cnf.

man mysql
to see how to connect to a ip based mysql host. C/ya!
On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote:

> I just install MYSQL on Linux (Red Hat 9)
> using this manual:http://www.mysql.com/doc/en/Installing_binary.html
> Have no idea what's wrong. I looked on the mysql.log file and the file 
is
> empty.
>
> ERROR MESSAGE:
> [EMAIL PROTECTED] bin]# ./mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
> [EMAIL PROTECTED] bin]# ./mysql status
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> _
> Scope out the new MSN Plus Internet Software  optimizes dial-up to the 
max!
>http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1

--

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325  |
 ||geek by nature - linux by choice  |
 |...|
...
"Programming today is a race between software engineers striving
to build bigger and better idiot-proof programs, and the Universe
trying to produce bigger and better idiots.
So far, the Universe is winning."
Rich Cook
_
Check out the new MSN 9 Dial-up — fast & reliable Internet access with prime 
features! http://join.msn.com/?pgmarket=en-us&page=dialup/home&ST=1

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

Re: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

[Victor Medina]

Probably your server is not using any sockets, check out your my.cnf. 

man mysql 
to see how to connect to a ip based mysql host. C/ya!


On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote:

> I just install MYSQL on Linux (Red Hat 9)
> using this manual:http://www.mysql.com/doc/en/Installing_binary.html
> Have no idea what's wrong. I looked on the mysql.log file and the file is 
> empty.
> 
> ERROR MESSAGE:
> [EMAIL PROTECTED] bin]# ./mysql
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/tmp/mysql.sock' (2)
> [EMAIL PROTECTED] bin]# ./mysql status
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/tmp/mysql.sock'
> 
> _
> Scope out the new MSN Plus Internet Software  optimizes dial-up to the max! 
>http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1

-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325  |
 ||geek by nature - linux by choice  |
 |...|

...
"Programming today is a race between software engineers striving 
to build bigger and better idiot-proof programs, and the Universe 
trying to produce bigger and better idiots. 
So far, the Universe is winning."

Rich Cook

RE: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

[Nicholas]

Hi Mike,

You have to start the mysql server before you 
can run the client.  Try running "mysqld_safe --user=mysql"
from /usr/bin or /usr/local/bin, depending on where 
you installed it.

To see if it is running currently on your machine, 
try this:  ps -ef | grep mysqld

Hope this helps...

~~Nick




 --- On Sat 01/17, Mike Mapsnac < [EMAIL PROTECTED] > wrote:
From: Mike Mapsnac [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sat, 17 Jan 2004 22:51:29 +0000
Subject: Mysql Installation on Linux:  ERROR 2002: Can't connect to local MySQL server 
th

I just install MYSQL on Linux (Red Hat 9)using this 
manual:http://www.mysql.com/doc/en/Installing_binary.htmlHave no idea what's 
wrong. I looked on the mysql.log file and the file is empty.ERROR 
MESSAGE:[EMAIL PROTECTED] bin]# ./mysqlERROR 2002: Can't connect to local 
MySQL server through socket '/tmp/mysql.sock' (2)[EMAIL PROTECTED] bin]# 
./mysql statusERROR 2002: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock'_Scope
 out the new MSN Plus Internet Software — optimizes dial-up to the max!
http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1-- MySQL 
General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo 
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

___
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

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

Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

[Mike Mapsnac]

I just install MYSQL on Linux (Red Hat 9)
using this manual:http://www.mysql.com/doc/en/Installing_binary.html
Have no idea what's wrong. I looked on the mysql.log file and the file is 
empty.

ERROR MESSAGE:
[EMAIL PROTECTED] bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)
[EMAIL PROTECTED] bin]# ./mysql status
ERROR 2002: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock'

_
Scope out the new MSN Plus Internet Software — optimizes dial-up to the max! 
  http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1

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

MySQL installation on HP-UX 10.20

[Gagneet Singh]

Hi!

Can anybody guide me to the link for MySQL on a HP-UX 10.20 system. I
have found the binaries for HP-UX 11 and 11.11, but nothing for 10.20.

Thanx for the help in advance,

Gagneet


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

mySQL Installation!!

[Kirti S. Bajwa]

Hello List:

This is my first post & you can easily figure out that I am a complete
newbie to mySQL. I have a fresh install of RH9 on a (test) server. It also
has mySQL 3.23 installed (part of RH9). My question is:

1) Considering the above setup, do I upgrade (and How?) from 3.23 to 4.0.??
2) or remove mySQL 3.23 from RH9 installation and re-install mySQL 4.0.??
(tar)

I have spent better part of today reading the archives but I still have not
gotten any satisfactory answer. Please Help!!!

Kirti

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

Re: MySQL installation with SuSE Linux 9.0 and YaST

[Thomas Spahni]

Franz,

it could not be easier.

1. install MySQL using Yast's software menu.

2. use the Yast run level editor to have MySQL up at run levels 3 and 5
   and to start the application.

3. be root in a xterm window and type:
mybox:~ # mysql

 ... and you will see:

mysql>

here you are accessing a running system from the client. Use GRANT to set
a password for root and to add new users.

Where is the problem?
Liebe Grüsse
Thomas Spahni


On Sun, 7 Dec 2003, Franz Edler wrote:

> I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
> very comfortable for me to install various SW-packages. Therefore I try to
> install also MySQL with YaST.
>
> There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0
> distribution and I try to install the server and the client with YaST.
>
> But after installation of these packages with YaST - which is the easy part
> - one has to configure various parameters for MySQL to work properly e.g.
> create the database files, define group and user, grant access ...
> Unfortunately the MySQL-manual (which is a big document) does not give any
> guidelines for installing with YaST.
>
> After several times re- and de-installing mysql and also SuSE-Linux itself I
> still have troubles to get the server running.
>
> Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST?
> Is there any "quick installation guide" for this task?
>
> I would be very happy to get some help.
>
> Franz


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

Re: MySQL installation with SuSE Linux 9.0 and YaST

[Bernard Clement]

Hello Franz,

On Sunday 07 December 2003 12:42, Franz Edler wrote:

I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my 
distributor) but I do with previous versions of SuSE (7.x and 8.x),

> I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
> very comfortable for me to install various SW-packages. Therefore I try to
> install also MySQL with YaST.
>
> There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0
> distribution and I try to install the server and the client with YaST.
>
> But after installation of these packages with YaST - which is the easy part
> - one has to configure various parameters for MySQL to work properly e.g.
> create the database files, define group and user, grant access ...
> Unfortunately the MySQL-manual (which is a big document) does not give any
> guidelines for installing with YaST.

Unfortunately you cannot use YaST to confiture MySQL.  Although your may want 
the server to start at boot time and that is done in the "System->Run Level 
Editor" in YaST.
>
> After several times re- and de-installing mysql and also SuSE-Linux itself
> I still have troubles to get the server running.

What kind of troubles?  Probably this is the place this group can start to 
help you.
>
> Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST?
> Is there any "quick installation guide" for this task?

I think you have done all it could be done using YaST.

You need now to jump into the documentation of MySQL.

I will suggest that you read the tutorial in section 3 of MySQL's 
documentation. (URL: http://www.mysql.com/doc/en/Tutorial.html).

>
> I would be very happy to get some help.

Hope I have been usefull.
>
> Franz

Bernard


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

MySQL installation with SuSE Linux 9.0 and YaST

[Franz Edler]

I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
very comfortable for me to install various SW-packages. Therefore I try to
install also MySQL with YaST. 

There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0
distribution and I try to install the server and the client with YaST.

But after installation of these packages with YaST - which is the easy part
- one has to configure various parameters for MySQL to work properly e.g.
create the database files, define group and user, grant access ... 
Unfortunately the MySQL-manual (which is a big document) does not give any
guidelines for installing with YaST.

After several times re- and de-installing mysql and also SuSE-Linux itself I
still have troubles to get the server running. 

Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST?
Is there any "quick installation guide" for this task?

I would be very happy to get some help.

Franz



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

Re: MySQL installation problem

[Chris Elsworth]

On Sat, Dec 06, 2003 at 08:20:57PM +0100, Franz Edler wrote:
> > 
> > Errno 13 is Permission Denied. Is the mysql daemon running with
> > sufficient privileges to read the directory and files within it?
> > All the database files should be owned by the mysql user, and are
> > generally in the mysql group, mode 660. Check that's the case.
>  
> All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and
> group=root, mode =660.
> There is no mysql group.
> 
> I installed as user "root" (using YaST) and created the database-files with
> mysql_install_db also as user "root".

During normal operation, mysql should run as the user "mysql", so it
can't read those. You'll want to chown them. Not having a mysql group
isn't critical, but if you haven't got a mysql user then I dare say
you need to check the installation process, because it probably hasn't
worked correctly.

-- 
Chris

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

RE: MySQL installation problem

[Franz Edler]

> From: Chris Elsworth  Sent: Saturday, December 06, 2003 5:09 PM
> 
> > The msqld.log file shows:
> > 031206 15:05:20  mysqld started
> > 031206 15:05:20   Fatal error: Can't open privilege tables:
> > Can't find file: './mysql/host.frm' (errno: 13)
> > 031206 15:05:20  Aborting
> > 031206 15:05:20  /usr/sbin/mysqld: Shutdown Complete
> 
> Errno 13 is Permission Denied. Is the mysql daemon running with
> sufficient privileges to read the directory and files within it?
> All the database files should be owned by the mysql user, and are
> generally in the mysql group, mode 660. Check that's the case.
 
All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and
group=root, mode =660.
There is no mysql group.

I installed as user "root" (using YaST) and created the database-files with
mysql_install_db also as user "root".

Franz


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

Re: MySQL installation problem

[Chris Elsworth]

On Sat, Dec 06, 2003 at 03:52:05PM +0100, Franz Edler wrote:
> 
> The msqld.log file shows:
> 031206 15:05:20  mysqld started
> 031206 15:05:20   Fatal error: Can't open privilege tables: 
>   Can't find file: './mysql/host.frm' (errno: 13)
> 031206 15:05:20  Aborting
> 031206 15:05:20  /usr/sbin/mysqld: Shutdown Complete
> 
> What is wrong?

Errno 13 is Permission Denied. Is the mysql daemon running with
sufficient privileges to read the directory and files within it?
All the database files should be owned by the mysql user, and are
generally in the mysql group, mode 660. Check that's the case.

-- 
Chris

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

MySQL installation problem

[Franz Edler]

Hello,

I have made a fresh installation of SuSE Linux 9.0.
Now I try to install MySQL, but I cannot start mysqld, it always terminates.

These are the two installation commands I used after installing with YaST:

LPC:~ # mysql_install_db
-> all tables have been created in /var/lib/mysql/mysql/  
   including host.frm

LPC:~ # mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
031206 15:05:20  mysqld ended


The msqld.log file shows:
031206 15:05:20  mysqld started
031206 15:05:20   Fatal error: Can't open privilege tables: 
Can't find file: './mysql/host.frm' (errno: 13)
031206 15:05:20  Aborting
031206 15:05:20  /usr/sbin/mysqld: Shutdown Complete

What is wrong?
What can I do now?

Franz


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

mysql installation error - version SUNW 1.2 not found

[Manjunath . Sangappan]

Description:
I am trying to install mysql 4.0.16 on Solaris 8 on a i86pc. I
created the user and group and everything went fine until I ran
scripts/mysql_install_db.
When I run the script I come acoss the error
ld.so.1: ./bin/mysqld: fatal: librt.so.1: version `SUNW_1.2' not found
(required by file ./bin/mysqld)
Searching the web I came across a solution to circumvent by setting the
LD_VERSION to non-null. But dont know how to set it to non-null. Can you
help me with this please?

>How-To-Repeat:
Run the install script

>Fix:

>MySQL support: none

>Synopsis:  mysql installation error
>Severity:  Priority:  Category:  mysql
>Class: Release:   mysql-4.0.16-standard (Official MySQL-standard binary)

>C compiler:gcc (GCC) 3.2.3
>C++ compiler:  gcc (GCC) 3.2.3
>Environment:

System: SunOS cbr03_ux 5.7 Generic_106542-15 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/loc
al/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2
/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'
CXX
FLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions
-fno-rtt
i'  LDFLAGS=''  ASFLAGS=''
LIBC:
-rw-r--r--   1 bin  bin  1572352 Mar 24  2001 /lib/libc.a
lrwxrwxrwx   1 root root  11 Feb  7  2000 /lib/libc.so ->
./libc.so.
1
-rwxr-xr-x   1 bin  bin   959172 Mar 24  2001 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1572352 Mar 24  2001 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Feb  7  2000 /usr/lib/libc.so ->
./libc
.so.1
-rwxr-xr-x   1 bin  bin   959172 Mar 24  2001 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr
/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-st
andard' '--enable-thread-safe-client' '--enable-local-infile'
'--disable-shared'
 '--with-embedded-server' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3
-fno-omit-frame-p
ointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptio
ns -fno-rtti' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for i86pc-solaris


Warm Regards,
Manjunath Sangappan

Unix Systems Administrator
United KFPW
p : +61 (2) 6245 5892
f : +61 (2) 6245 6813
e : mailto:[EMAIL PROTECTED]
w: www.unitedkfpw.com.au
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.  If you received
this in error, please contact the sender and delete the material from any
computer.


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

MySQL installation and starting problems on LynxOS

[Sp.Raja]

Hello,

I tried installing MySQL on LynxOS, and it went fine. After installation I started 
mysqld and but was not able to communicate with it.

When I ran mysqladmin it reported the following

arjuna# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
arjuna# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'

Then I tried telnet to 3306 port on which mysqld was listening

arjuna# telnet arjuna 3306
Trying 192.168.0.21 ...
Connected to arjuna.
Escape character is '^]'.
,
4.0.15a-log>*VQtulA, 

Bad handshakeConnection closed by foreign host.
arjuna# telnet arjuna 3306
Trying 192.168.0.21 ...
Connected to arjuna.
Escape character is '^]'.
,
4.0.15a-logOVB&8%N=, 

Bad handshakeConnection closed by foreign host.


Server side log at time were

arjuna# tail -f arjuna.err
Version: '4.0.15a-log'  socket: '/tmp/mysql.sock'  port: 3306

Number of processes running now: 0
030930 12:47:06  mysqld restarted
/usr/local/mysql/libexec/mysqld: File or directory doesn't exist
030930 12:47:06  mysqld ended

030930 12:47:37  mysqld started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.15a-log'  socket: '/tmp/mysql.sock'  port: 3306

030930 12:55:28  Error on new connection socket: Socket operation on non-socket

030930 12:55:33  Error on new connection socket: Socket operation on non-socket

Could some one help me to resolve this??

Regards
Sp.Raja

Re: mysql installation problems (RPM errors)

[Misao]

First off to maybe make this easy on you, you do not need the 
MySQL-bench rpm if you do not plan on using the benchmarking tools. It 
is an optional install.
Otherwise, I do not think rpm cares about capitalization. I believe this 
problem is discussed in the MySQL manual, and might have the solution, 
but then I am sure others on this list can help out. Most important 
thing to remember, is that you don't need benchmarking to run the MySQL 
server. In the past, I always used a tarball of the perl DBI and it 
worked fine.

Gale Stafford wrote:

Hey Folks

Hi there! My first post to the list ...

I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed.

I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by "Mysql-DBI-perl...rpm) not having capitals in all the right places?

I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file?

thanks,
Gale 

 



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

mysql installation problems (RPM errors)

[Gale Stafford]

Hey Folks

Hi there! My first post to the list ...

I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL 
server software, client software, but when I try to install the MySQL-bench...rpm, I 
get the failed dependencies error, MySQL-DBI-perl-bin is needed.

I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But 
when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies 
error. Is this a problem caused by "Mysql-DBI-perl...rpm) not having capitals in all 
the right places?

I dont understand enough about how rpm works, to troubleshoot this! Can anyone help 
point me to the right MySQL-DBI-perl...rpm file?

thanks,
Gale 

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

Re: MySQL Installation problem

[James Hughbanks]

Andrew,
One, it sound like you have downloaded a binary distro, and this does 
not require a make.  If your want to compile from source, you will need 
to grab the source distro instead.  If you would like to continue with 
the binary, you can untar the package under /usr/local , and then add 
the group mysql, add a user mysql with membership to the mysql group, 
cd to the mysql dir(this should have been created when you untar'd the 
file under /usr/local, run scripts/mysql_install_db, which sets up all 
the mysql databases for privledges and stuff, chown -R root .   , chown 
-R mysql data, chgrp -R mysql .   , then start the server with 
bin/mysqld_safe --user=mysql &
This should let your db server start, after which you will need to run
shell> mysqladmin password 'your_new_password'
if you try to do the same command again, it should complain about auth 
errors.
If you need any other help, just ask.

--James Hughbanks
Mikro-Data Engineering Dept.
[EMAIL PROTECTED]
1-866-457-6287
http://www.mikro-data.net
On Monday, Aug 18, 2003, at 05:49 America/New_York, Andrew Keating 
wrote:

To whom it may concern,

We are having some trouble installing a MySQL database onto one of our
servers and would appreciate some assistance, details are below.
Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1.

We have downloaded the source files from your website and have had a 
go at
trying to install the software following the instructions on the user
manual. We get to the point of configure and we get the following 
output:

[EMAIL PROTECTED] > ./configure --prefix=/usr/local/mysql
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, 
please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
030818 10:39:06  ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy 
support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h stats1 password 'new-password'
See the manual for more instructions.
NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[EMAIL PROTECTED] > Starting mysqld daemon with databases from
/opt/clients/stats/mark/mysql-standard-4.0.14-sun-solaris2.8-sparc/data
030818 10:39:07  mysqld ended
This seems to be all ok, but then I try to compile the program using 
the
'make' command and I get this message:

[EMAIL PROTECTED] > make
make: *** No targets specified and no makefile found.  Stop.
Has this error ever happened before and how could we go further on 
this.

A point to note would be that in the directory /usr/local/ there is no 
mysql
directory created!

Regards,
Mark A. Cauchi


--James Hughbanks
Mikro-Data Engineering Dept.
[EMAIL PROTECTED]
1-866-457-6287
http://www.mikro-data.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Installation problem

[Andrew Keating]

To whom it may concern,

We are having some trouble installing a MySQL database onto one of our
servers and would appreciate some assistance, details are below.

Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1.

We have downloaded the source files from your website and have had a go at
trying to install the software following the instructions on the user
manual. We get to the point of configure and we get the following output:

[EMAIL PROTECTED] > ./configure --prefix=/usr/local/mysql
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
030818 10:39:06  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h stats1 password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[EMAIL PROTECTED] > Starting mysqld daemon with databases from
/opt/clients/stats/mark/mysql-standard-4.0.14-sun-solaris2.8-sparc/data
030818 10:39:07  mysqld ended

This seems to be all ok, but then I try to compile the program using the
'make' command and I get this message:

[EMAIL PROTECTED] > make
make: *** No targets specified and no makefile found.  Stop.

Has this error ever happened before and how could we go further on this.

A point to note would be that in the directory /usr/local/ there is no mysql
directory created!

Regards,
Mark A. Cauchi

Re: MySQL Installation Challenges

[Andreas]

Chris Moy wrote:

$mysqld_safe --user mysql &
[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
030812 13:24:04  mysqld ended
but you can see that the deamon has "ended" right away.  This should not
happen, correct?
look in the err-file.
It's named laptop.err and lies in the data directory.
/usr/local/mysql/data
Did you enable innodb in /etc/my.cnf ?
If yes, did you create it's data-folder ?
Check if the user mysql can read/write there.
* IMPORTANT *
Don't use a file-manager like   mc   on the shell where you start mysql.
It will look exactly like that if you run
./bin/mysqld_safe &
from within mc though
./bin/mysqld_safe
will work nut block the shell.
Plain bash is fine.


Then I go to connect to the server (locally) by entering in a mysqladmin
command to check the version and the output is below:
... mysql ended


error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
While we are at it.
Some distributions put this socket elsewhere.
SuSE has it's mysql package compiled to store data and socket in 
/var/lib/mysql. All client programs that came with the distribution will 
expect the stuff there.

You have to symlink the socket to /var/lib/mysql to get the libraries 
working.



Configured with: ../configure --prefix=/usr
> '--bindir=/usr/bin'
There you are ... RedHat's bin-directory is /usr/bin not 
/usr/local/mysql/bin

'--datadir=/usr/share'
and default data folder

'--localstatedir=/var/lib/mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
and socket





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

Re: MySQL Installation Challenges

[Victoria Reznichenko]

Chris Moy <[EMAIL PROTECTED]> wrote:
>>Description:
> 
>  the installation procedure. I have installed the binaries as described
> in the manual for installation and I am able to start mysql through 
> 
> $mysqld_safe --user mysql &
> [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
> /var/lib/mysql
> 030812 13:24:04  mysqld ended
> 
> but you can see that the deamon has "ended" right away.  This should not
> happen, correct?

Look into error log file to see error message.

> 
> Then I go to connect to the server (locally) by entering in a mysqladmin
> command to check the version and the output is below:
> 
> bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!
> 
> It does not seem like the deamon is running at all when I go to check
> (ps -aux | grep mysql). Any ideas. I am a little new to MySql.
> 
> Note: I have tried the latest version of MySQL and still get the same
> problems but on a diff computer running the same OS (Linux RH 9.0)>
> 


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





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

MySQL Installation Challenges

[Chris Moy]

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: moyc
To: [EMAIL PROTECTED]
Subject: Installation challenges - mysqld

>Description:



>Fix:


>Submitter-Id:  
>Originator:Chris Moy
>Organization:
 
>MySQL support: [none]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.54 (Source distribution)

>Environment:

System: Linux bioserver 2.4.20-18.9 #1 Thu May 29 07:08:16 EDT 2003 i686
i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --with-system-zlib --enable-__cxa_atexit
--host=i386-redhat-linux
Thread model: posix
gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Compilation info: CC='i386-redhat-linux-gcc'  CFLAGS='-O2 -march=i386
-mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 
CXX='i386-redhat-linux-g++'  CXXFLAGS='-O2 -march=i386 -mcpu=i686 -g
-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti
-fno-exceptions'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 May 27 07:49 /lib/libc.so.6
-> libc-2.3.2.so
-rwxr-xr-x1 root root  1549556 Mar 13 19:43
/lib/libc-2.3.2.so
-rw-r--r--1 root root  2321376 Mar 13 18:35 /usr/lib/libc.a
-rw-r--r--1 root root  204 Mar 13 17:58 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 May 27 08:36
/usr/lib/libc-client.a -> c-client.a
Configure command: ./configure '--host=i386-redhat-linux'
'--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu'
'--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr'
'--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc'
'--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib'
'--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--without-readline' '--without-debug'
'--enable-shared' '--with-extra-charsets=complex' '--with-bench'
'--localstatedir=/var/lib/mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb'
'--enable-local-infile' '--enable-large-files=yes'
'--enable-largefile=yes' '--with-berkeley-db-includes=/usr/include'
'--with-berkeley-db-libs=/usr/lib' '--enable-thread-safe-client'
'CFLAGS=-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386
-mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE
-fno-rtti -fno-exceptions' 'build_alias=i386-redhat-linux'
'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu'




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

Re: mysql installation problem

[Lenz Grimmer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

On Wed, 6 Aug 2003, Anil Garg wrote:

> I am trying to install myql on redhat.

Red Hat Linux?

> mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz

This is the wrong package - this one is for FreeBSD! Please use the Linux
binaries instead.

> scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1:
> bad ELF interpreter: No such file or directory
> scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF
> interpreter: No such file or directory

FreeBSD binaries do not run on Linux.

Bye,
LenZ
- -- 
 Lenz Grimmer <[EMAIL PROTECTED]>
 Senior Production Engineer
 MySQL GmbH, http://www.mysql.de/
 Hamburg, Germany

 For technical support contracts, visit https://order.mysql.com/?ref=mlgr
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQE/MhEhSVDhKrJykfIRAqNGAJkBJYbw9uzsIOv48A+wQ9ol/BWOHQCfeAu7
yXzHGHVLi4tLINiXyomftLM=
=3+9Z
-END PGP SIGNATURE-

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

mysql installation problem

[Anil Garg]

Hi,
I am trying to install myql on redhat.
mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz

While following the instructions in install document..when i run the
follwing command..
scripts/mysql_install_db

following errors appear:
-
scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1:
bad ELF interpreter: No such file or directory
WARNING: The host 'njsupport.niksun.com' 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 deamon, 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 !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF
interpreter: No such file or directory
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can 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.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
--
As i am new bie to mysql ..please tell how can i make mysql work.

Thanks and Regards
Anil.
p.s.(Can i get precomplied package (.tgz) to which i can directly pkg_add?).




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

Re: question about mysql installation

[shirly cohen]

Hi again
I looked in the site and in some place they write:

"you should create an option file for each server. In your startup script 
that is executed at boot time you should specify for both servers
safe_mysqld --defaults-file=path-to-option-file "

What is the startup script? is it somthing that i need to ceate?

Thanks for all the ones who replied me.





From: "Jerry" <[EMAIL PROTECTED]>
Reply-To: "Jerry" <[EMAIL PROTECTED]>
To: "shirly cohen" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: Re: question about mysql installation
Date: Thu, 20 Feb 2003 12:05:18 -

Yes,

http://www.mysql.com/doc/en/Installing_many_servers.html


- Original Message -
From: "shirly cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:42 AM
Subject: question about mysql installation


>
> Hi all,
> Can i install mysql twice on the same comuter?
> And on the same hard disk?
>
> Thanks, Shilry
>
>
>
> _
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
> -
> 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
>



_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


-
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: question about mysql installation

[Victoria Reznichenko]

On Thursday 20 February 2003 13:42, shirly cohen wrote:

> Can i install mysql twice on the same comuter?
> And on the same hard disk?

Yes and Yes:
http://www.mysql.com/doc/en/Installing_many_servers.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: question about mysql installation

[Jerry]

Yes,

http://www.mysql.com/doc/en/Installing_many_servers.html


- Original Message -
From: "shirly cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:42 AM
Subject: question about mysql installation


>
> Hi all,
> Can i install mysql twice on the same comuter?
> And on the same hard disk?
>
> Thanks, Shilry
>
>
>
> _
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
> -
> 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

question about mysql installation

[shirly cohen]

Hi all,
Can i install mysql twice on the same comuter?
And on the same hard disk?

Thanks, Shilry



_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


-
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

MySQL Installation Problem

[John R. Porter]

I'm having difficulty installing MySQL 3.23.54 on a Windows 2000 server.

I downloaded the file mysql-3.23.54-win.zip. It unzipped and installed
smoothly on my Windows 2000 PC, but when I tried to install on the server
Setup failed with the Windows message: 'Cannot find file C:\...SETUP.EXE (or
one of its components)' etc.

I currently have version 3.23.49-nt installed. There were no problems
installing it.

Can anyone suggest what might be wrong?


John R. Porter
I.T.Services
University of Strathclyde
Jordanhill Campus
76 Southbrae Drive
Glasgow
G13 1PP
e-mail: [EMAIL PROTECTED]
Tel. 0141 950 3289


-
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

MySQL-Installation on a Windows 2000 Cluster

[Sollinger Rainer (dienstlich)]

I must install MySQL on a Windows 2000 Cluster-Server. 
What´s the best way to do it?
How must the my.ini configured so that it works as fail over?
 
Thanks
 
Rainer

SQL, Query

-
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: Mysqladmin command not installed via rpm mysql installation

[Victoria Reznichenko]

slickmik,
Thursday, November 21, 2002, 6:58:18 PM, you wrote:

saedodedn> Description:

saedodedn> When mysql is installed via linux rpm file, it does not install
saedodedn> mysqladmin command?

saedodedn> How-To-Repeat:
saedodedn> just install mysql from redhat linux rpm.

You need to install client RPM package.



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

Mysqladmin command not installed via rpm mysql installation

[slickmik]

>Description:

When mysql is installed via linux rpm file, it does not install
mysqladmin command?

>How-To-Repeat:
just install mysql from redhat linux rpm.

>Fix:
?


>Submitter-Id:  
>Originator:MikeL
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  Mysqladmin command not installed via rpm mysql installation
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.53a (Official MySQL RPM)

>Environment:

System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 12:13:11 EDT 2002 i686 
athlon i386 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/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man 
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking 
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   14 Nov 20 15:30 /lib/libc.so.6 -> 
libc-2.2.93.so
-rwxr-xr-x2 root root  1235468 Sep  5 19:12 /lib/libc-2.2.93.so
-rw-r--r--1 root root  2233342 Sep  5 18:59 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep  5 18:50 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb 
--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 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man 
'--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer 
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer   -felide-constructors 
-fno-exceptions -fno-rtti -mpentium' CXX=gcc



-
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

MySQL Installation

[Alice Tan]

Hi, i am doing a setup program that eventually install mySQL, myODBC, and my
system.
during my system installation, it require mySQL is installed and already run
the WinMySQLAdmin.exe,
where by from there i will be able to do some record insertion on the db.

but now, since for the first time we run WinMySQLAdmin.exe,
it actually require to login,
i wonder can i skip this login process,
in order for the end-user be more easier while they do the installation.
if yes, may i know how to skip the first time WinMySQLAdmin.exe login
process ?

and besides that, i would like to know,
before we running WinMySQLAdmin.exe, the my.ini file still not created yet,
therefore, we will not know where's the mySQL installed.

May i know how to locate where's the mySQL folder located in this case,
so that i can have a shortcut for the end user to click on it and run the
WinMySQLAdmin.exe ?





/---\

Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for 
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received 
in  error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the 
official business of this company shall be understood as neither given
nor endorsed by this company.

This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) 
*Scanner Engine powered by Norman Virus Control

\--/


-
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: Mysql installation

[Hao Tran]

Hi,

 

I need some help to install mysql.

I downloaded the rpm for Linux. I installed it successfully based on the
messages I received at the end of the installation. However, I could not
find the mysqladmin tool any where and I do not know what else is missing
from my installation. I would like to re-install mysql. Could some one help
me out. I am looking for a simple way to make this happen. Thanks so much.

 

Hao


-
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: RE: MysQL Installation

[Egor Egorov]

SpyProductions,
Friday, November 08, 2002, 10:50:33 PM, you wrote:

SST> Well hells bells!

SST> Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
SST> page?  :)

Yes.



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




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

[Black, Kelly W [PCS]]

-Mike

>I know this is OT a bit, but now I need to either re-compile PHP to get
>mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I
>need to do this at all?

Not sure where PHP came into the picture here.

Let's not confuse phpMyAdmin with MySqladmin. Different animals all
together.

For Mysqladmin you will simply need to download the rpm (rpmfind.net for
MySqlClient)
or build Mysql from scratch with source (how I like it done)

Note:I have had nothing but trouble from the RedHat default Mysqld installs,
so 
now (by default) as soon as the server is set up the first thing I do is
disable the
mysqld in services and re-compile both PHP and MySql (4.0 MAX of course) on
the system
without even asking.


If you are talking about getting mysql working with PHP you need to compile
PHP from source with (everyone flog me with wet cron jobs if I am wrong :)

(in pseudo)

./configure --with-mysql=/usr/local/thelocationofyourmyslq.hfile

and make.

Note that if compiling PHP from source you should use the completed
configure (see docs)
something like (PLEASE KNOW THIS WILL VARY MACHINE TO MACHINE RESEARCH THIS)

(This is a snapshot from my Davis, Ca. server and will NOT work with your
PHP configure...)

 './configure' '--with-apxs=/usr/www.0727/bin/apxs' '--with-db'
'--with-mysql=/usr/local/mysql' '--with-msql=/usr/local/Hughes' '--with-xml'
'--with-gd=/usr/local' '--enable-ftp'
'--with-imap-ssl=/usr/home/colossus/pine4.33/imap'
'--with-jpeg-dir=/usr/lib' '--with-zlib' '--with-openssl=/usr/local/ssl'
'--with-png-dir=/usr/lib' '--enable-magic-quotes=yes'
'--enable-memory-limit' '--enable-trackvars=yes'

If this didn't confuse you let me know I will try to confuse you again.

~Kelly W. Black

sql, query

-Original Message-----
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 2:26 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: MySQL Installation



I know this is OT a bit, but now I need to either re-compile PHP to get
mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I
need to do this at all?

Even at rpmfind.net is seems hard to distinguish what it is I need.  Is
there anyway to get a 'complete' PHP rpm somewhere?

Thanks!

-Mike


> -Original Message-
> From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> Sent: Friday, November 08, 2002 5:12 PM
> To: '[EMAIL PROTECTED]'
> Cc: [EMAIL PROTECTED]
> Subject: RE: MySQL Installation
>
>
> Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
> server package, but MySql.com has it in the client's:
> $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin
>
> /usr/bin/mysqladmin
> /usr/share/man/man1/mysqladmin.1.gz
>
> sql, query
>
> ~Kelly W. Black
>
> PS IN the future check out http://www.rpmfind.net/
>
> -Original Message-
> From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> Sent: Friday, November 08, 2002 12:51 PM
> To: Black, Kelly W [PCS]
> Cc: [EMAIL PROTECTED]
> Subject: RE: MysQL Installation
>
>
>
> Well hells bells!
>
> Would that be the 'Client programs (i386) (2.3M)' mentioned on
> the download
> page?  :)
>
> Thanks,
>
> Mike
>
>
>
> > -Original Message-
> > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> > Sent: Friday, November 08, 2002 2:17 PM
> > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> > Subject: RE: MysQL Installation
> >
> >
> > Mysqladmin is seperate rpm
> >
> > ~K Black
> >
> > -Original Message-
> > From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> > Sent: Friday, November 08, 2002 11:13 AM
> > To: [EMAIL PROTECTED]
> > Subject: MysQL Installation
> >
> >
> >
> > I just installed the most recent version of MySQL with an RPM (through
> > webmin interface), but it doesn't seem to have installed a
> > mysqladmin.anyone know why?  :)
> >
> > Thanks!
> >
> > -Mike
> >
> >
> >
> > -
> > 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
> >
>


-Original Mes

RE: MySQL Installation

[SpyProductions Support Team]

I know this is OT a bit, but now I need to either re-compile PHP to get
mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I
need to do this at all?

Even at rpmfind.net is seems hard to distinguish what it is I need.  Is
there anyway to get a 'complete' PHP rpm somewhere?

Thanks!

-Mike


> -Original Message-
> From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> Sent: Friday, November 08, 2002 5:12 PM
> To: '[EMAIL PROTECTED]'
> Cc: [EMAIL PROTECTED]
> Subject: RE: MySQL Installation
>
>
> Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
> server package, but MySql.com has it in the client's:
> $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin
>
> /usr/bin/mysqladmin
> /usr/share/man/man1/mysqladmin.1.gz
>
> sql, query
>
> ~Kelly W. Black
>
> PS IN the future check out http://www.rpmfind.net/
>
> -Original Message-
> From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> Sent: Friday, November 08, 2002 12:51 PM
> To: Black, Kelly W [PCS]
> Cc: [EMAIL PROTECTED]
> Subject: RE: MysQL Installation
>
>
>
> Well hells bells!
>
> Would that be the 'Client programs (i386) (2.3M)' mentioned on
> the download
> page?  :)
>
> Thanks,
>
> Mike
>
>
>
> > -Original Message-
> > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> > Sent: Friday, November 08, 2002 2:17 PM
> > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> > Subject: RE: MysQL Installation
> >
> >
> > Mysqladmin is seperate rpm
> >
> > ~K Black
> >
> > -Original Message-
> > From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> > Sent: Friday, November 08, 2002 11:13 AM
> > To: [EMAIL PROTECTED]
> > Subject: MysQL Installation
> >
> >
> >
> > I just installed the most recent version of MySQL with an RPM (through
> > webmin interface), but it doesn't seem to have installed a
> > mysqladmin.anyone know why?  :)
> >
> > Thanks!
> >
> > -Mike
> >
> >
> >
> > -
> > 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: MySQL Installation

[Black, Kelly W [PCS]]

Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
server package, but MySql.com has it in the client's:
$ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin

/usr/bin/mysqladmin
/usr/share/man/man1/mysqladmin.1.gz

sql, query

~Kelly W. Black

PS IN the future check out http://www.rpmfind.net/

-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 12:51 PM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: MysQL Installation



Well hells bells!

Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
page?  :)

Thanks,

Mike



> -Original Message-
> From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> Sent: Friday, November 08, 2002 2:17 PM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: MysQL Installation
>
>
> Mysqladmin is seperate rpm
>
> ~K Black
>
> -Original Message-
> From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> Sent: Friday, November 08, 2002 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: MysQL Installation
>
>
>
> I just installed the most recent version of MySQL with an RPM (through
> webmin interface), but it doesn't seem to have installed a
> mysqladmin.anyone know why?  :)
>
> Thanks!
>
> -Mike
>
>
>
> -
> 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: MysQL Installation

[SpyProductions Support Team]

Well hells bells!

Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
page?  :)

Thanks,

Mike



> -Original Message-
> From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
> Sent: Friday, November 08, 2002 2:17 PM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: MysQL Installation
>
>
> Mysqladmin is seperate rpm
>
> ~K Black
>
> -Original Message-
> From: SpyProductions Support Team [mailto:support@;spyproductions.com]
> Sent: Friday, November 08, 2002 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: MysQL Installation
>
>
>
> I just installed the most recent version of MySQL with an RPM (through
> webmin interface), but it doesn't seem to have installed a
> mysqladmin.anyone know why?  :)
>
> Thanks!
>
> -Mike
>
>
>
> -
> 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: MysQL Installation

[John Coder]

On Fri, 2002-11-08 at 14:12, SpyProductions Support Team wrote:
> 
> I just installed the most recent version of MySQL with an RPM (through
> webmin interface), but it doesn't seem to have installed a
> mysqladmin.anyone know why?  :)
> 
> Thanks!
> 
> -Mike
> 
Probably you just installed the server not the client you need both.


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

[Black, Kelly W [PCS]]

Mysqladmin is seperate rpm

~K Black

-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation



I just installed the most recent version of MySQL with an RPM (through
webmin interface), but it doesn't seem to have installed a
mysqladmin.anyone know why?  :)

Thanks!

-Mike



-
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

MysQL Installation

[SpyProductions Support Team]

I just installed the most recent version of MySQL with an RPM (through
webmin interface), but it doesn't seem to have installed a
mysqladmin.anyone know why?  :)

Thanks!

-Mike



-
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: NEWBIE: problems with mysql installation

[Paul DuBois]

At 16:01 -0500 11/1/02, [EMAIL PROTECTED] wrote:

Hello,

 I am relatively new to using MySQL and cannot understand why when I
use mysqladmin or mysql client with any other id than root I get the cannot
connect to local MySQL Server though socket '/var/lib/mysql/mysql.sock. Can
someone tell me if it's a permission's problem or something else. My my.cnf
file has the socket definition defined and mysql works fine for the root
user.


It may be that the /var/lib/mysql directory isn't publicly accessible.
What are the permissions on that directory?



I have installed MySQL 4.04 client and server on Linux 7.0


Can someone tell me what I am missing?


Thanks

-Eric PFeifer



-
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

NEWBIE: problems with mysql installation

[Eric . Pfeifer]

Hello,

 I am relatively new to using MySQL and cannot understand why when I
use mysqladmin or mysql client with any other id than root I get the cannot
connect to local MySQL Server though socket '/var/lib/mysql/mysql.sock. Can
someone tell me if it's a permission's problem or something else. My my.cnf
file has the socket definition defined and mysql works fine for the root
user.

I have installed MySQL 4.04 client and server on Linux 7.0


Can someone tell me what I am missing?


Thanks

-Eric PFeifer



-
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

mysql installation error... mysql.sock file not found

[anand v]

Hi,

I have redhat linux 7.1 server and I have downloaded the
binary version of mysql 3.23.52 and I have installed the same version on
other servers and it was all fine but on this server I am getting the 
following
error

[root@abacusweb mysql]# bin/safe_mysqld &
[1] 21278
[root@abacusweb mysql]# Starting mysqld daemon with databases from 
/var/lib/mysq
l
020910 19:12:53  mysqld ended

and I can not see the file mysql.sock in /varlib/mysql area but it has all 
the
tables etc that are needed. And I followed the README and all the docs and
did all the steps one by one.. and also I don't know how to run mysqlbug 
program??

How can direct mysqlbug program to a file so that I can send that file as an 
attachment
to this mailing list??

Please help me.. seems like I am stuck here... I created mysql user and the 
group
and I changed all the permissions according to the document

Thanks

Anand



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
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: I need some help in MySql installation ..

[Egor Egorov]

sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:

ss> Description:

[skip]

ss> I got this
ss> MySQL-3.23.52-1


ss> That means mysql is installed successfully.

ss> What is the step by step procedure for post
ss> Installation configuration of MySql server?

Check chapter "2.4 Post-installation Setup and Testing":
  http://www.mysql.com/doc/en/Post-installation.html

ss> I really do not know that...Could you pls. tell me!
ss> If I have done anything wrong pls. make me aware of
ss> that also.


ss> Following are the few commands I gave and also given
ss> is the corresponding message displayed on the screen.
ss> That could be helpful to you to analyse the case.

ss> 1.

ss> [root@FireWall2 init.d]# mysql
ss> ERROR 1045: Access denied for user: 'root@localhost'
ss> (Using password: NO)

ss> 2.

ss> [root@FireWall2 bin]# mysqladmin -u root password
ss> 'PASSTHEWORD'
ss> mysqladmin: connect to server at 'localhost' failed
ss> error: 'Access denied for user: 'root@localhost'
ss> (Using password: NO)'

Did you have installed MySQL server before?

ss> 3.

ss> [root@FireWall2 bin]# mysqld --skip-grant-tables
ss> 020828 16:08:42  Can't start server: Bind on TCP/IP
ss> port: Address already in use
ss> 020828 16:08:42  Do you already have another mysqld
ss> server running on port: 3306 ?
ss> 020828 16:08:42  Aborting

ss> 020828 16:08:42  mysqld: Shutdown Complete

ss> 4.

ss> My mysqld daemon is in directory /usr/sbin/

ss> I tried to run it and gave me the following ...

ss> [root@FireWall2 sbin]# mysqld
ss> 020830 12:05:22  Can't start server: Bind on TCP/IP
ss> port: Address already in use
ss> 020830 12:05:22  Do you already have another mysqld
ss> server running on port: 3306 ?
ss> 020830 12:05:22  Aborting

ss> 020830 12:05:22  mysqld: Shutdown Complete

CHECK if MySQL server is already running with
   ps ax | grep mysqld

If so, take down mySQL server and then start mysqld with
--skip-grant-tables option





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



-
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

I need some help in MySql installation ..

[sachin sontakke]

From: root

To: [EMAIL PROTECTED]

Subject: I need some help in MySql installation

Description:

I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name is FireWall2. My OS is Red hat Linux
7.1 with kernel version 2.4.2-2.

>From that directory I gave commands 

# rpm -ivh MySQL-3.23.52-1.i386.rpm
# rpm -ivh MySQL-client-3.23.52-1.i386.rpm 
# rpm -ivh MySQL-shared-3.23.52-1.i386.rpm

After doing that it showed me installing MySQL on
machine.

So when I ran following command 

# rpm -q MySQL

I got this
MySQL-3.23.52-1


That means mysql is installed successfully.

What is the step by step procedure for post
Installation configuration of MySql server?

I really do not know that...Could you pls. tell me!
If I have done anything wrong pls. make me aware of
that also.



Following are the few commands I gave and also given
is the corresponding message displayed on the screen.
That could be helpful to you to analyse the case.


1.

[root@FireWall2 init.d]# mysql
ERROR 1045: Access denied for user: 'root@localhost'
(Using password: NO)


2.

[root@FireWall2 bin]# mysqladmin -u root password
'PASSTHEWORD'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost'
(Using password: NO)'


3.

[root@FireWall2 bin]# mysqld --skip-grant-tables
020828 16:08:42  Can't start server: Bind on TCP/IP
port: Address already in use
020828 16:08:42  Do you already have another mysqld
server running on port: 3306 ?
020828 16:08:42  Aborting

020828 16:08:42  mysqld: Shutdown Complete

   
4.

My mysqld daemon is in directory /usr/sbin/

I tried to run it and gave me the following ...

[root@FireWall2 sbin]# mysqld
020830 12:05:22  Can't start server: Bind on TCP/IP
port: Address already in use
020830 12:05:22  Do you already have another mysqld
server running on port: 3306 ?
020830 12:05:22  Aborting

020830 12:05:22  mysqld: Shutdown Complete



Kindly let me know where I am going wrong.

Thanks a lot..


Originator:root
Organization:  CSS Ltd.
Category:  mysql


sachin s.



__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.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

MySQL installation problem

[Tang, Lianhong]

Hi guys,
I am trying to install MySql on Linux (Mandrake 8). And everytime 
when I try to start the server. like this
[mysql@127 support-files]# ./mysql.server start
I get the message like:
"./mysql.server: @hostname@ command not found
 ./mysql.server: my_print_defaults command not found
[mysql@127 support-files]# Starting mysqld daemon with database 
from  /usr/local/mysql/data
020709 09:07:03 mysqld ended"

Anybody can give me a hint?
I really appreciate it!
Tang

---
Tang, Lianhong
Vanderbilt University
Email: [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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie MySQL installation problems (specific)

[Bhavin Vyas]

Ah...give up not for we have been using mysql for quite a long time and it
is pretty stable. Try this...
instead of trouble shooting this install and getting it work...
go to www.mysql.com, download an rpm if you are on Red hat linux (or
Mandrake) and do an
rpm -i mysql...rpm and
rpm -i mysq..client..rpm (this file is for insalling the client).
If not, just download the binary and follow the instructions. We haven't had
any trouble at all installing mysql and this might be a system specific
problem. Let me know how it works out.

Regards,
Bhavin.

- Original Message -
From: "Colin Cooler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 6:42 PM
Subject: Re: Newbie MySQL installation problems (specific)


> Thanks Bhavin,
>
> I tried your suggestion ("safe_mysqld start") and get a lot of "Permission
> denied" errors.  So, I "su" to root and try it, and it appears that it
does
> start ("Starting mysqld daemon with databases from
/usr/local/mysql/data").
>
> However, when I try to connect, either as root (which I understand is not
a
> good idea) or under my normal login, I get the same error, i.e., that the
> socket can't be found.
>
> Very puzzling and I'm quickly approaching the point of concluding that the
> amount of time trying to troubleshoot this mess not warranting the
potential
> benefits.
>
> Colin
>
> > Have you tried .../bin/safe_mysqld start to start the DB first? This is
what
> > will create /tmp/mysql.sock socket file & start the DB server. Then you
can
> > use the 'mysql' client for connecting to the DB. Also, if you don't want
to
> > use transactional database, meaning, if you don't want support for
rollback
> > and stuff, which I am guessing you might not, then you can download the
> > 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc
> > Liyanage's site). Since it's giving errors regarding innodb, my guess is
> > that the server is configured to create inno db tables and not myisam
> > tables, which is what the default binaries/rpm are configured to do
(i.e.
> > create myisam tables, but they are non-transactional).
> >
> > Regards,
> > Bhavin.
> >
> > - Original Message -
> > From: "Colin Cooler" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, June 09, 2002 3:55 PM
> > Subject: Newbie MySQL installation problems (specific)
> >
> >
> >> Buying Paul DuBois' most excellent book "MySQL" has made me more
> > comfortable
> >> with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as
> > the
> >> web database for a redesigneed site at Right Moves For Youth (trying to
> > keep
> >> "at risk" kids in school).
> >>
> >> After running his "cleanup instructions" and then downloading and
> > installing
> >> the mysql package from Marc Liyanage's site, I tried to run the
following
> >> command (as per instructions):
> >> "sudo ./scripts/mysql_install_db;"  I then get the following results:
> >>
> >>> Preparing db table
> >>> Preparing host table
> >>> Preparing user table
> >>> Preparing func table
> >>> Preparing tables_priv table
> >>> Preparing columns_priv table
> >>> Installing all prepared tables
> >>> ERROR: 1062  Duplicate entry 'localhost-root' for key 1
> >>> ERROR: 1062  Duplicate entry 'localhost-root' for key 1
> >>> 020609  0:35:05  ./bin/mysqld: Shutdown Complete
> >>
> >>
> >> When I try to start mysql from the command line, I then get the
ubiquitous
> >> error message:  "ERROR 2002: Can't connect to local MySQL server
through
> >> socket '/tmp/mysql.sock' (2) "
> >>
> >> I also discovered a "localhost.err" file in my data directory which
yields
> >> the following information:
> >>
> >>> 020609 01:09:50  mysqld started
> >>> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> >>> If you do not want to use transactional InnoDB tables, add a line
> > skip-innodb
> >>> to the [mysqld] section of init parameters in your my.cnf
> >>> or my.ini. If you want to use InnoDB tables, add for example,
> >>> innodb_data_file_path = ibdata1:30M
> >>> But to get good performance you should adjust for your hardware
> >>> the InnoDB startup options listed in section 2 at
&

Re: Newbie MySQL installation problems (specific)

[Colin Cooler]

Thanks Bhavin,

I tried your suggestion ("safe_mysqld start") and get a lot of "Permission
denied" errors.  So, I "su" to root and try it, and it appears that it does
start ("Starting mysqld daemon with databases from /usr/local/mysql/data").

However, when I try to connect, either as root (which I understand is not a
good idea) or under my normal login, I get the same error, i.e., that the
socket can't be found.

Very puzzling and I'm quickly approaching the point of concluding that the
amount of time trying to troubleshoot this mess not warranting the potential
benefits.

Colin

> Have you tried .../bin/safe_mysqld start to start the DB first? This is what
> will create /tmp/mysql.sock socket file & start the DB server. Then you can
> use the 'mysql' client for connecting to the DB. Also, if you don't want to
> use transactional database, meaning, if you don't want support for rollback
> and stuff, which I am guessing you might not, then you can download the
> 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc
> Liyanage's site). Since it's giving errors regarding innodb, my guess is
> that the server is configured to create inno db tables and not myisam
> tables, which is what the default binaries/rpm are configured to do (i.e.
> create myisam tables, but they are non-transactional).
> 
> Regards,
> Bhavin.
> 
> - Original Message -----
> From: "Colin Cooler" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 09, 2002 3:55 PM
> Subject: Newbie MySQL installation problems (specific)
> 
> 
>> Buying Paul DuBois' most excellent book "MySQL" has made me more
> comfortable
>> with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as
> the
>> web database for a redesigneed site at Right Moves For Youth (trying to
> keep
>> "at risk" kids in school).
>> 
>> After running his "cleanup instructions" and then downloading and
> installing
>> the mysql package from Marc Liyanage's site, I tried to run the following
>> command (as per instructions):
>> "sudo ./scripts/mysql_install_db;"  I then get the following results:
>> 
>>> Preparing db table
>>> Preparing host table
>>> Preparing user table
>>> Preparing func table
>>> Preparing tables_priv table
>>> Preparing columns_priv table
>>> Installing all prepared tables
>>> ERROR: 1062  Duplicate entry 'localhost-root' for key 1
>>> ERROR: 1062  Duplicate entry 'localhost-root' for key 1
>>> 020609  0:35:05  ./bin/mysqld: Shutdown Complete
>> 
>> 
>> When I try to start mysql from the command line, I then get the ubiquitous
>> error message:  "ERROR 2002: Can't connect to local MySQL server through
>> socket '/tmp/mysql.sock' (2) "
>> 
>> I also discovered a "localhost.err" file in my data directory which yields
>> the following information:
>> 
>>> 020609 01:09:50  mysqld started
>>> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
>>> If you do not want to use transactional InnoDB tables, add a line
> skip-innodb
>>> to the [mysqld] section of init parameters in your my.cnf
>>> or my.ini. If you want to use InnoDB tables, add for example,
>>> innodb_data_file_path = ibdata1:30M
>>> But to get good performance you should adjust for your hardware
>>> the InnoDB startup options listed in section 2 at
>>> http://www.innodb.com/ibman.html
>> 
>>> 020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write
> to
>> file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>>> 020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>>> 020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>>> 020609 01:09:52  mysqld ended
>> 
>> Finally, when I try the following: "mysqladmin -u root status" I also get
>> the "can't connect through /tmp/myssql.sock" error message.
>> 
>> 
>> No matter what I try, I can't seem to connect to mysql so that I can even
>> BEGIN to figure out how to correct the 1062 problem!  Can anyone tell me
> how
>> to what the "ERROR: 1062" message means and how to resolve this mess?
> I've
>> searched the archives, and this error appears to have occurred
> o

Re: Newbie MySQL installation problems (specific)

[Bhavin Vyas]

Have you tried .../bin/safe_mysqld start to start the DB first? This is what
will create /tmp/mysql.sock socket file & start the DB server. Then you can
use the 'mysql' client for connecting to the DB. Also, if you don't want to
use transactional database, meaning, if you don't want support for rollback
and stuff, which I am guessing you might not, then you can download the
3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc
Liyanage's site). Since it's giving errors regarding innodb, my guess is
that the server is configured to create inno db tables and not myisam
tables, which is what the default binaries/rpm are configured to do (i.e.
create myisam tables, but they are non-transactional).

Regards,
Bhavin.

- Original Message -
From: "Colin Cooler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 09, 2002 3:55 PM
Subject: Newbie MySQL installation problems (specific)


> Buying Paul DuBois' most excellent book "MySQL" has made me more
comfortable
> with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as
the
> web database for a redesigneed site at Right Moves For Youth (trying to
keep
> "at risk" kids in school).
>
> After running his "cleanup instructions" and then downloading and
installing
> the mysql package from Marc Liyanage's site, I tried to run the following
> command (as per instructions):
> "sudo ./scripts/mysql_install_db;"  I then get the following results:
>
> >Preparing db table
> >Preparing host table
> >Preparing user table
> >Preparing func table
> >Preparing tables_priv table
> >Preparing columns_priv table
> >Installing all prepared tables
> >ERROR: 1062  Duplicate entry 'localhost-root' for key 1
> >ERROR: 1062  Duplicate entry 'localhost-root' for key 1
> >020609  0:35:05  ./bin/mysqld: Shutdown Complete
>
>
> When I try to start mysql from the command line, I then get the ubiquitous
> error message:  "ERROR 2002: Can't connect to local MySQL server through
> socket '/tmp/mysql.sock' (2) "
>
> I also discovered a "localhost.err" file in my data directory which yields
> the following information:
>
> >020609 01:09:50  mysqld started
> >Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> >If you do not want to use transactional InnoDB tables, add a line
skip-innodb
> >to the [mysqld] section of init parameters in your my.cnf
> >or my.ini. If you want to use InnoDB tables, add for example,
> >innodb_data_file_path = ibdata1:30M
> >But to get good performance you should adjust for your hardware
> >the InnoDB startup options listed in section 2 at
> >http://www.innodb.com/ibman.html
>
> >020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write
to
> file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
> >020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> >020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of
> '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
> >020609 01:09:52  mysqld ended
>
> Finally, when I try the following: "mysqladmin -u root status" I also get
> the "can't connect through /tmp/myssql.sock" error message.
>
>
> No matter what I try, I can't seem to connect to mysql so that I can even
> BEGIN to figure out how to correct the 1062 problem!  Can anyone tell me
how
> to what the "ERROR: 1062" message means and how to resolve this mess?
I've
> searched the archives, and this error appears to have occurred
occasionally,
> but being a newbie to MySQL, I can't understand the solutions to the
> problem.  Usually this problem has occurred AFTER someone has been able to
> successfully connect to mysql.
>
> Oh Woe is me,
> Colin
>
>
> -
> 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

Newbie MySQL installation problems (specific)

[Colin Cooler]

Buying Paul DuBois' most excellent book "MySQL" has made me more comfortable
with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the
web database for a redesigneed site at Right Moves For Youth (trying to keep
"at risk" kids in school).

After running his "cleanup instructions" and then downloading and installing
the mysql package from Marc Liyanage's site, I tried to run the following
command (as per instructions):
"sudo ./scripts/mysql_install_db;"  I then get the following results:

>Preparing db table
>Preparing host table
>Preparing user table
>Preparing func table
>Preparing tables_priv table
>Preparing columns_priv table
>Installing all prepared tables
>ERROR: 1062  Duplicate entry 'localhost-root' for key 1
>ERROR: 1062  Duplicate entry 'localhost-root' for key 1
>020609  0:35:05  ./bin/mysqld: Shutdown Complete


When I try to start mysql from the command line, I then get the ubiquitous
error message:  "ERROR 2002: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) "

I also discovered a "localhost.err" file in my data directory which yields
the following information:

>020609 01:09:50  mysqld started
>Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
>If you do not want to use transactional InnoDB tables, add a line skip-innodb
>to the [mysqld] section of init parameters in your my.cnf
>or my.ini. If you want to use InnoDB tables, add for example,
>innodb_data_file_path = ibdata1:30M
>But to get good performance you should adjust for your hardware
>the InnoDB startup options listed in section 2 at
>http://www.innodb.com/ibman.html

>020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to
file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
>020609  1:09:51  /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of
'/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13)
>020609 01:09:52  mysqld ended

Finally, when I try the following: "mysqladmin -u root status" I also get
the "can't connect through /tmp/myssql.sock" error message.
 

No matter what I try, I can't seem to connect to mysql so that I can even
BEGIN to figure out how to correct the 1062 problem!  Can anyone tell me how
to what the "ERROR: 1062" message means and how to resolve this mess?  I've
searched the archives, and this error appears to have occurred occasionally,
but being a newbie to MySQL, I can't understand the solutions to the
problem.  Usually this problem has occurred AFTER someone has been able to
successfully connect to mysql.

Oh Woe is me,
Colin


-
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: php+apache+mysql installation. Help

[Andy Cheng]

Do I need to uninstall the old Apache before installing the newer version?  
How do I uninstall the old Apache in linux?  Do I just use the package 
manager to remove the package?  What does make do? I don't know how linux 
work.  Please advise.  Thanks.


>From: Andrew Lietzow <[EMAIL PROTECTED]>
>To: "Andy Cheng" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: Re: php+apache+mysql installation.  Help!
>Date: Thu, 23 May 2002 21:34:37 -0500
>
>Dear Andy,
>
>Here's a thought.   Before you go much further, install Apache 2.0.36.  
>It's
>easy to install and lots of improvements will be gained that you'll
>appreciate down the road, i.e. mod_ssl is preconfigured into the system.
>
>Andrew Lietzow
>The ACL Group, Inc.
>
>
>On Thursday 23 May 2002 06:33 pm, you wrote:
> > Hi,
> >
> > I am new to linux and trying to install Apache, php and mysql on my 
>Redhat
> > 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error:
> >
> > checking whether build environment is sane..configure error:newly 
>created
> > file is older than distributed files!
> >
> > I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my 
>box.
> > Would appreciated if some one could advise how to install PHP.  Thanks
> >
> > P.S.
> > I have start Mysql manually.  How do I make it auto start and shutdown?
> >
> >
> >
> >
> >
> > _
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > -
> > 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
>
>--
>Andrew Lietzow
>The ACL Group, Inc.
>515-274-0300 v/f
>515-710-1955 c


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
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: php+apache+mysql installation. Help!

[Andrew Lietzow]

Dear Andy, 

Here's a thought.   Before you go much further, install Apache 2.0.36.  It's 
easy to install and lots of improvements will be gained that you'll 
appreciate down the road, i.e. mod_ssl is preconfigured into the system.  

Andrew Lietzow
The ACL Group, Inc.  


On Thursday 23 May 2002 06:33 pm, you wrote:
> Hi,
>
> I am new to linux and trying to install Apache, php and mysql on my Redhat
> 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error:
>
> checking whether build environment is sane..configure error:newly created
> file is older than distributed files!
>
> I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box.
> Would appreciated if some one could advise how to install PHP.  Thanks
>
> P.S.
> I have start Mysql manually.  How do I make it auto start and shutdown?
>
>
>
>
>
> _
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
> -
> 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

-- 
Andrew Lietzow   
The ACL Group, Inc.
515-274-0300 v/f
515-710-1955 c

-
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

php+apache+mysql installation. Help!

[Andy Cheng]

Hi,

I am new to linux and trying to install Apache, php and mysql on my Redhat 
7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error:

checking whether build environment is sane..configure error:newly created 
file is older than distributed files!

I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. 
Would appreciated if some one could advise how to install PHP.  Thanks

P.S.
I have start Mysql manually.  How do I make it auto start and shutdown?





_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
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

MySQL Installation Problem

[Jagadeesh Suryadevara]

Hello,

I downloaded all the following files to load MYSQL software.

  mysql-4.0.0a-alpha-win-src.zip
  mysql-4.0.0a-alpha-win.zip

  mysql-4.0.1a-alpha-win-src.zip
  mysql-4.0.1a-alpha-win.zip

I installed mysql after unzipping the above two versions of
.zip files.

After installation it is not coming to the programs
but it is installing all the files.
What i have to do to show the shortcut in programs and to
use mysql database so plese send me all the required files or
URLS which will give me correct information to solve my problem

Thanks

_
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs


-
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

MySQL Installation Problem

[Jagadeesh Suryadevara]

Hello,

I downloaded all the following files to load MYSQL software.

  mysql-4.0.0a-alpha-win-src.zip
  mysql-4.0.0a-alpha-win.zip

  mysql-4.0.1a-alpha-win-src.zip
  mysql-4.0.1a-alpha-win.zip

I installed mysql after unzipping the above two versions of
.zip files.

After installation it is not coming to the programs
but it is installing all the files.
What i have to do to show the shortcut in programs and to
use mysql database so plese send me all the required files or
URLS which will give me correct information to solve my problem

Thanks

_
Click below to visit monsterindia.com and review jobs in India or 
Abroad
http://monsterindia.rediff.com/jobs


-
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: Help with mysql installation

[mike]

Should be able to find the right rpm's from your Linux distribution's 
website. Just a guess here but www.redhat.com.

Mike
sqp,mysql

Balteo wrote:

> Hello,
> 
> I am trying to install mysql from RPMs.  My installation guide requires:
> 
> -Mysql server
> -Mysql shared
> -Mysql client
> 
> However those files are not present on mysql's website.  Where do I find 
> them??
> 
> Is the file available at Mysql.com sufficient for a server + client 
> installation?
> 
> Thanks in advance,
> 
> Balteo.
> 
> 
> -
> 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
> 


-- 
Mike


-
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: Help with mysql installation

[Paras Mukadam]

> Hello,
>
> I am trying to install mysql from RPMs.  My installation guide requires:
>
> -Mysql server
> -Mysql shared
> -Mysql client
>
> However those files are not present on mysql's website.  Where do I find
> them??
Where do you want to install .. on 1) Unix like OS or 2) windows or 3) any
other?
For 1 goto http://www.mysql.com/downloads/mysql-3.23.html and all RPM's are
present under heading Linux Downloads
For 2 server/client programs are all present in the .zip file on SAME site
(under Windows Downloads)

>
> Is the file available at Mysql.com sufficient for a server + client
> installation?
>
> Thanks in advance,
>
> Balteo.
>
>
> -
> 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

Help with mysql installation

[Balteo]

Hello,

I am trying to install mysql from RPMs.  My installation guide requires:

-Mysql server
-Mysql shared
-Mysql client

However those files are not present on mysql's website.  Where do I find 
them??

Is the file available at Mysql.com sufficient for a server + client 
installation?

Thanks in advance,

Balteo.


-
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: MySql installation - DB dies

[Victoria Reznichenko]

D,
Wednesday, April 24, 2002, 6:16:31 PM, you wrote:

DO> Having followed instructions from various sources and installed from source 
(twice) and binary (once), I still get the following problem.
DO> ---
DO> [root mysql]# /usr/local/mysql/bin/safe_mysqld &
DO> [1] 16168
DO> [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
DO> 020425 00:11:37  mysqld ended

Please, look in the your .err file in the MySQL data dir
and show me the contents of this file (but not the whole file! about last 20-40
rows ...)

DO> 
DO> Please help!
DO> I am using "Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586"
DO> Thank you in advance.
DO> Daniel.




-- 
For technical support contracts, goto https://order.mysql.com/
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: MySql installation - DB dies - SOLVED

[D Okonkwo]

Opps sorry.
Found the problem. Not starting as proper user.
Thanks.
D.
--
On Wed, 24 April 2002, D Okonkwo wrote:
> 
> Having followed instructions from various sources and installed from source (twice) 
>and binary (once), I still get the following problem.
> ---
> [root mysql]# /usr/local/mysql/bin/safe_mysqld &
> [1] 16168
> [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
> 020425 00:11:37  mysqld ended
> 
> 
> Please help!
> I am using "Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586"
> Thank you in advance.
> Daniel.
> 
> 
> 
> -
> 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

MySql installation - DB dies

[D Okonkwo]

Having followed instructions from various sources and installed from source (twice) 
and binary (once), I still get the following problem.
---
[root mysql]# /usr/local/mysql/bin/safe_mysqld &
[1] 16168
[root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
020425 00:11:37  mysqld ended


Please help!
I am using "Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586"
Thank you in advance.
Daniel.



-
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: Mysql Installation problem with 3.23.49 Linux Source release on RH7.3 Beta 1.

[Christopher Thompson]

Do you have g++ installed?  It doesn't look like you do.

On Friday 19 April 2002 1:45 pm, Ricky Sun wrote:
> I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1
> workstation... Encountered the following gcc C++ compiler executable
> creation problem
>
> when ./configure checks for C++ compiler it complains :
>
> 
> checking for gcc... gcc
> checking whether the C compiler (gcc   ) works... yes
> checking whether the C compiler (gcc   ) is a cross-compiler... no
> checking whether we are using GNU C... yes
> checking whether gcc accepts -g... yes
> checking for c++... no
> checking for g++... no
> checking for gcc... gcc
> checking whether the C++ compiler (gcc   ) works... no
> configure: error: installation or configuration problem: C++ compiler =
> =3D
> cannot create executables.
>
>
>
> The version of gcc I am using is 2.96 2731...  any hints? Why it's not
> recognized as a C++ compiler?
>
>
> $gcc -v
> Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-109)
>
>
>
> -
> 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: Mysql Installation problem with 3.23.49 Linux Source release on RH7.3 Beta 1.

[Ricky Sun]

I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1 workstation...
Encountered the following gcc C++ compiler executable creation problem 

when ./configure checks for C++ compiler it complains :


checking for gcc... gcc
checking whether the C compiler (gcc   ) works... yes
checking whether the C compiler (gcc   ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for c++... no
checking for g++... no
checking for gcc... gcc
checking whether the C++ compiler (gcc   ) works... no
configure: error: installation or configuration problem: C++ compiler =
=3D
cannot create executables.



The version of gcc I am using is 2.96 2731...  any hints? Why it's not recognized 
as a C++ compiler?


$gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-109)



-
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

Help for MYSQL installation

[Chip Yu]

Dear Sir/Madam,

I downloaded the latest mysql-3.23.49 and wanted to
install MYSQL in my FreeBSD 2.2.7 OS. The
configuration ("./configure") and Make both went
smoothly, but it failed when I installed ("make
install") and here is the error message:

--
mv -f .libs/get_password.lo get_password.lo
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\"" 
   -DDATADIR="\"/usr/local/mysql/var\""   
   
-DSHAREDIR="\"/usr/local/mysql/share/mysql\""
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include
-I../include  -I./.. -I.. -I..-O3
-DDBUG_OFF -c errmsg.c
rm -f .libs/errmsg.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\"
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include
-I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c
errmsg.c  -fPIC -DPIC -o .libs/errmsg.lo
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/usr/local/mysql/var\"
-DSHAREDIR=\"/usr/local/mysql/share/mysql\"
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include
-I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c
errmsg.c -o errmsg.o >/dev/null 2>&1
mv -f .libs/errmsg.lo errmsg.lo
make: don't know how to make my_init.c. Stop
*** Error code 1


Please help.

Chip
Thanks!

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.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