Re: MySQL installation failure

2006-02-01 Thread 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 wheel 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


Re: MySQL installation problems.

2005-11-21 Thread 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]



Re: Mysql installation information

2005-04-01 Thread 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]


RE: Mysql installation information

2005-04-01 Thread 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

2005-03-31 Thread 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


Re: mysql installation

2004-09-20 Thread 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

2004-09-18 Thread 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]


Re: MySQL Installation Problem

2004-06-18 Thread 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\binmysqld --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\binmysqld

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

Re: MySQL Installation Problem

2004-06-17 Thread 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]



Re: MySQL Installation Problem

2004-06-17 Thread 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

2004-06-17 Thread 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

2004-06-17 Thread 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 in Fedora Core 1

2004-03-31 Thread 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???

2004-03-31 Thread 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

2004-03-31 Thread 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 in Fedora Core 1

2004-03-30 Thread 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]



Re: MySQL installation in Fedora Core 1

2004-03-30 Thread 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/RH89

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

2004-03-30 Thread 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 on Linux: ERROR 2002: Can't connect to local MySQL server th

2004-01-18 Thread 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-uspage=byoa/plusST=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 tolocal MySQL server

2004-01-18 Thread 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-uspage=byoa/plusST=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-uspage=dialup/homeST=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

2004-01-17 Thread 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 +
Subject: Mysql Installation on Linux:  ERROR 2002: Can't connect to local MySQL server 
th

I just install MYSQL on Linux (Red Hat 9)brusing this 
manual:http://www.mysql.com/doc/en/Installing_binary.htmlbrHave no idea what's 
wrong. I looked on the mysql.log file and the file is brempty.brbrERROR 
MESSAGE:br[EMAIL PROTECTED] bin]# ./mysqlbrERROR 2002: Can't connect to local 
MySQL server through socket br'/tmp/mysql.sock' (2)br[EMAIL PROTECTED] bin]# 
./mysql statusbrERROR 2002: Can't connect to local MySQL server through socket 
br'/tmp/mysql.sock'brbr_brScope
 out the new MSN Plus Internet Software — optimizes dial-up to the max! br   
http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1brbrbr-- brMySQL 
General Mailing ListbrFor list archives: http://lists.mysql.com/mysqlbrTo 
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]brbr

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



Re: MySQL installation with SuSE Linux 9.0 and YaST

2003-12-09 Thread 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

2003-12-07 Thread 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]



Re: MySQL installation problem

2003-12-06 Thread 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]



RE: MySQL installation problem

2003-12-06 Thread 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

2003-12-06 Thread 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 problems (RPM errors)

2003-08-26 Thread 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]


Re: MySQL Installation problem

2003-08-18 Thread 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]


Re: MySQL Installation Challenges

2003-08-14 Thread Victoria Reznichenko
Chris Moy [EMAIL PROTECTED] wrote:
Description:
 
 I've never installed MySql before and I am having a little trouble with
 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]



Re: MySQL Installation Challenges

2003-08-14 Thread 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 problem

2003-08-09 Thread 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]



RE: Mysql installation

2002-11-11 Thread 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

2002-11-09 Thread 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

2002-11-08 Thread 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




Re: MysQL Installation

2002-11-08 Thread 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

2002-11-08 Thread 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

2002-11-08 Thread 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

2002-11-08 Thread 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

2002-11-08 Thread 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 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

Re: MySql installation - DB dies - SOLVED

2002-04-24 Thread 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




Re: MySql installation - DB dies

2002-04-24 Thread 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 host_name.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 problem with 3.23.49 Linux Source release on RH7.3 Beta 1.

2002-04-19 Thread 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




Re: Mysql Installation problem with 3.23.49 Linux Source release on RH7.3 Beta 1.

2002-04-19 Thread 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 error

2002-04-03 Thread Murali Prakash

Jane,
Probably u downloaded the file on your windows box and ftp'ed it using
ascii mode instead of binary as Egor has suggested.
 -Prakash.   

-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:40 PM
To: [EMAIL PROTECTED]
Subject: Mysql installation error


Jane,
Wednesday, April 03, 2002, 12:27:33 AM, you wrote:

JT We have encountered the problem to install Mysql-3.23.49 version on
Linux
JT Redhat 7.1.

JT 1.  Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
JT 2.  Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed
JT data--format violated.

JT Can anyone offer some assistance on what's happening here?

Are you sure you have downloaded rpm and tar.gz files in binary format and
correctly?

JT Thanks,
JT Jane Tsai





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

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

2002-03-11 Thread ds

 
 I don't understand the code. I copy it from a book. I am trying to print out 
 the records returned from a query.  I have a table named client in database 
 andy. The table has 2 records.  When I run the above code, I have 2 blank 
 lines return.  Could any one tell me what the problem is?  Where could I 
 find better documentation on DBI::DBD::mysql stuff for beginner?  man 
 DBD::mysql is difficult to understand.  Thanks again for the info.

 #!/usr/bin/perl
 
 use DBI;
 $dbh=DBI-connect('DBI:mysql:andy');
 my $query=select * from client;
 my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
 $sth-execute;
 my $rows;
 while(@row=$sth-fetchrow_array)
 {my $i;
 for $i (0..($sth-{num_of_fields}-1))
 {print [.$row[$i].];}
 print(\n);
 }
 $sth-finish;
 $dbh-disconnect

Hi, 

I'm not an expert in perl too, but i would correct your code to this:

 #!/usr/bin/perl
 
 use DBI;
 $dbh=DBI-connect('DBI:mysql:andy');
 my $query=select * from client;
 my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
 $sth-execute;
 my $rows;
 while(@row=$sth-fetchrow_array)
 {my $i;
 for $i (0..($sth-{NUM_OF_FIELDS}-1))
 {print [.$row[$i].];}
 print(\n);
 }
 $sth-finish;
 $dbh-disconnect

Note the uppercase in $sth-{NUM_OF_FIELDS}.
Also remove the line my $rows... It's doing nothing there.


 
 From: Chuck \PUP\ Payne [EMAIL PROTECTED]
 To: Doug Thompson [EMAIL PROTECTED],   Andy Cheng 
 [EMAIL PROTECTED], Intrex [EMAIL PROTECTED],   
 [EMAIL PROTECTED] [EMAIL PROTECTED]
 Subject: Re: Mysql installation.  Help!
 Date: Sun, 10 Mar 2002 14:18:13 -0500
 
 Ok, if never run it then you have to start once, if I remember right undex
 Red Hat, you have to go to /etc/rc.d/init.d and do this...
 
 ./mysql start that will start it
 
 Then you will need to set it up so it will start later. SuSE you have to
 start it once
 
 You will then need to set a password for mysql.
 
 I hope that helps.
 
 
   
   | Chuck Payne  |
   | Magi Design and Support  |
   | www.magidesign.com   |
   | [EMAIL PROTECTED]   |
   
 
 BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
 Web Design you can afford.
 
 Fortune for today --
 
 Q:  How many Zen masters does it take to screw in a light bulb?
 A:  None.  The Universe spins the bulb, and the Zen master stays out
  of the way.
 
 
 
   If mysql.sock doesn't exist, that is because the server is not running.
  
   I fought the same battle as Mark and ultimately downloaded and installed 
 the
   RPM for 3.23.49a from MySQL in place of
   the copy that came with RH.  The MySQL RPM installed and came up just 
 like it
   says in the book.  Saves a lot of hair
   and dain bramage.
  
   If the server process _is_ running, it may be useful to go through the 
 section
   on binary installation and check those
   items to see if your RPM set everything up correctly.  Don't bet on 
 finding
   anything, but it doesn't take long to do
   these checks.
   http://www.mysql.com/doc/I/n/Installing_binary.html
  
   Regards,
   Doug
  
   Perfection is finally attained not when there is no longer anything to 
 add,
   but when there is no longer anything to
   take away. -- Antoine de Saint Exup?ry
  
   On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
  
   What I did was beat my brains out on the same exact problem.  In the 
 end I
   have no clue what I did to get it actually working.  I had re-installed 
 the
   mysql from the .tar.gz, I installed all the RPM's several times. 
 Everytime,
   I fully rebooted the system, and finally I have to run
   safe_mysqld --user=root
  
   I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
   rebooted the system, then re-ran safe_mysqld --user=root.
  
   Mark
  
   - Original Message -
   From: Andy Cheng [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Sunday, March 10, 2002 10:01 AM
   Subject: Mysql installation. Help!
  
  
   Hi all,
   I got this error message when trying to connect to mysql at the shell
   command:
  
   Error 2002:Can't connect to local MySql server through socket
   '/var/lib/mysql/mysql.sock
  
  
   There is no mysql.sock in the /var/lib/mysql directory. Did I miss 
 some
   thing in the mysql installation?  Where could I find the mysql.sock?  
 I
   install mysql that came with redhat 7.2. Thank for the help.
  
  
  
  
  
  
  
  
  
   -
   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

Re: Mysql installation. Help!

2002-03-11 Thread Andy Cheng

Great, the uppercase in $sth-{NUM_OF_FIELDS} works.  Now I can start to 
learn perl.  Any advice on where could I find a good source for beginner on 
the web?  Thank you very much.


From: ds [EMAIL PROTECTED]
To: Andy Cheng [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Mysql installation. Help!
Date: 11 Mar 2002 19:41:08 +


I don't understand the code. I copy it from a book. I am trying to print 
out
the records returned from a query.  I have a table named client in database
andy. The table has 2 records.  When I run the above code, I have 2 blank
lines return.  Could any one tell me what the problem is?  Where could I
find better documentation on DBI::DBD::mysql stuff for beginner?  man
DBD::mysql is difficult to understand.  Thanks again for the info.

#!/usr/bin/perl

use DBI;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect

Hi,

I'm not an expert in perl too, but i would correct your code to this:

#!/usr/bin/perl

use DBI;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{NUM_OF_FIELDS}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect

Note the uppercase in $sth-{NUM_OF_FIELDS}.
Also remove the line my $rows... It's doing nothing there.



_
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: Mysql installation. Help!

2002-03-10 Thread Intrex

What I did was beat my brains out on the same exact problem.  In the end I
have no clue what I did to get it actually working.  I had re-installed the
mysql from the .tar.gz, I installed all the RPM's several times. Everytime,
I fully rebooted the system, and finally I have to run
safe_mysqld --user=root

I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.

Mark

- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!


 Hi all,
 I got this error message when trying to connect to mysql at the shell
 command:

 Error 2002:Can't connect to local MySql server through socket
 '/var/lib/mysql/mysql.sock


 There is no mysql.sock in the /var/lib/mysql directory. Did I miss some
 thing in the mysql installation?  Where could I find the mysql.sock?  I
 install mysql that came with redhat 7.2. Thank for the help.

 _
 Join the world's largest e-mail service with MSN Hotmail.
 http://www.hotmail.com


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

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




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

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




Re: Mysql installation. Help!

2002-03-10 Thread Doug Thompson

If mysql.sock doesn't exist, that is because the server is not running.

I fought the same battle as Mark and ultimately downloaded and installed the RPM for 
3.23.49a from MySQL in place of
the copy that came with RH.  The MySQL RPM installed and came up just like it says in 
the book.  Saves a lot of hair
and dain bramage.

If the server process _is_ running, it may be useful to go through the section on 
binary installation and check those
items to see if your RPM set everything up correctly.  Don't bet on finding anything, 
but it doesn't take long to do
these checks.
http://www.mysql.com/doc/I/n/Installing_binary.html

Regards,
Doug

Perfection is finally attained not when there is no longer anything to add, but when 
there is no longer anything to
take away. -- Antoine de Saint Exup‚ry

On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:

What I did was beat my brains out on the same exact problem.  In the end I
have no clue what I did to get it actually working.  I had re-installed the
mysql from the .tar.gz, I installed all the RPM's several times. Everytime,
I fully rebooted the system, and finally I have to run
safe_mysqld --user=root

I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.

Mark

- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!


 Hi all,
 I got this error message when trying to connect to mysql at the shell
 command:

 Error 2002:Can't connect to local MySql server through socket
 '/var/lib/mysql/mysql.sock


 There is no mysql.sock in the /var/lib/mysql directory. Did I miss some
 thing in the mysql installation?  Where could I find the mysql.sock?  I
 install mysql that came with redhat 7.2. Thank for the help.









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

2002-03-10 Thread Chuck \PUP\ Payne

Ok, if never run it then you have to start once, if I remember right undex
Red Hat, you have to go to /etc/rc.d/init.d and do this...

./mysql start that will start it

Then you will need to set it up so it will start later. SuSE you have to
start it once

You will then need to set a password for mysql.

I hope that helps. 


 
 | Chuck Payne  |
 | Magi Design and Support  |
 | www.magidesign.com   |
 | [EMAIL PROTECTED]   |
 

BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.

Fortune for today --

Q:  How many Zen masters does it take to screw in a light bulb?
A:  None.  The Universe spins the bulb, and the Zen master stays out
of the way.



 If mysql.sock doesn't exist, that is because the server is not running.
 
 I fought the same battle as Mark and ultimately downloaded and installed the
 RPM for 3.23.49a from MySQL in place of
 the copy that came with RH.  The MySQL RPM installed and came up just like it
 says in the book.  Saves a lot of hair
 and dain bramage.
 
 If the server process _is_ running, it may be useful to go through the section
 on binary installation and check those
 items to see if your RPM set everything up correctly.  Don't bet on finding
 anything, but it doesn't take long to do
 these checks.
 http://www.mysql.com/doc/I/n/Installing_binary.html
 
 Regards,
 Doug
 
 Perfection is finally attained not when there is no longer anything to add,
 but when there is no longer anything to
 take away. -- Antoine de Saint Exup?ry
 
 On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
 
 What I did was beat my brains out on the same exact problem.  In the end I
 have no clue what I did to get it actually working.  I had re-installed the
 mysql from the .tar.gz, I installed all the RPM's several times. Everytime,
 I fully rebooted the system, and finally I have to run
 safe_mysqld --user=root
 
 I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
 rebooted the system, then re-ran safe_mysqld --user=root.
 
 Mark
 
 - Original Message -
 From: Andy Cheng [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, March 10, 2002 10:01 AM
 Subject: Mysql installation. Help!
 
 
 Hi all,
 I got this error message when trying to connect to mysql at the shell
 command:
 
 Error 2002:Can't connect to local MySql server through socket
 '/var/lib/mysql/mysql.sock
 
 
 There is no mysql.sock in the /var/lib/mysql directory. Did I miss some
 thing in the mysql installation?  Where could I find the mysql.sock?  I
 install mysql that came with redhat 7.2. Thank for the help.
 
 
 
 
 
 
 
 
 
 -
 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. Help!

2002-03-10 Thread Andy Cheng

Thanks for the help.  I got it working. I could connect to mysql from shell 
command. Now I try to connect to mysql using perl.  I installed the DBI::DBD 
module for perl.  I think the DBI::DBD also working since I don't see error 
return running the following code:


#!/usr/bin/perl

use DBI;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect

I don't understand the code. I copy it from a book. I am trying to print out 
the records returned from a query.  I have a table named client in database 
andy. The table has 2 records.  When I run the above code, I have 2 blank 
lines return.  Could any one tell me what the problem is?  Where could I 
find better documentation on DBI::DBD::mysql stuff for beginner?  man 
DBD::mysql is difficult to understand.  Thanks again for the info.





From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED],   Andy Cheng 
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],   
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql installation.  Help!
Date: Sun, 10 Mar 2002 14:18:13 -0500

Ok, if never run it then you have to start once, if I remember right undex
Red Hat, you have to go to /etc/rc.d/init.d and do this...

./mysql start that will start it

Then you will need to set it up so it will start later. SuSE you have to
start it once

You will then need to set a password for mysql.

I hope that helps.


  
  | Chuck Payne  |
  | Magi Design and Support  |
  | www.magidesign.com   |
  | [EMAIL PROTECTED]   |
  

BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.

Fortune for today --

Q:  How many Zen masters does it take to screw in a light bulb?
A:  None.  The Universe spins the bulb, and the Zen master stays out
 of the way.



  If mysql.sock doesn't exist, that is because the server is not running.
 
  I fought the same battle as Mark and ultimately downloaded and installed 
the
  RPM for 3.23.49a from MySQL in place of
  the copy that came with RH.  The MySQL RPM installed and came up just 
like it
  says in the book.  Saves a lot of hair
  and dain bramage.
 
  If the server process _is_ running, it may be useful to go through the 
section
  on binary installation and check those
  items to see if your RPM set everything up correctly.  Don't bet on 
finding
  anything, but it doesn't take long to do
  these checks.
  http://www.mysql.com/doc/I/n/Installing_binary.html
 
  Regards,
  Doug
 
  Perfection is finally attained not when there is no longer anything to 
add,
  but when there is no longer anything to
  take away. -- Antoine de Saint Exup?ry
 
  On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
 
  What I did was beat my brains out on the same exact problem.  In the 
end I
  have no clue what I did to get it actually working.  I had re-installed 
the
  mysql from the .tar.gz, I installed all the RPM's several times. 
Everytime,
  I fully rebooted the system, and finally I have to run
  safe_mysqld --user=root
 
  I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
  rebooted the system, then re-ran safe_mysqld --user=root.
 
  Mark
 
  - Original Message -
  From: Andy Cheng [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Sunday, March 10, 2002 10:01 AM
  Subject: Mysql installation. Help!
 
 
  Hi all,
  I got this error message when trying to connect to mysql at the shell
  command:
 
  Error 2002:Can't connect to local MySql server through socket
  '/var/lib/mysql/mysql.sock
 
 
  There is no mysql.sock in the /var/lib/mysql directory. Did I miss 
some
  thing in the mysql installation?  Where could I find the mysql.sock?  
I
  install mysql that came with redhat 7.2. Thank for the help.
 
 
 
 
 
 
 
 
 
  -
  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





_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Re: Mysql installation. Help

2002-03-10 Thread Chuck \PUP\ Payne

Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.

Chuck Payne
Magi Design and Support

on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:

 Thanks for the help.  I got it working. I could connect to mysql from shell
 command. Now I try to connect to mysql using perl.  I installed the DBI::DBD
 module for perl.  I think the DBI::DBD also working since I don't see error
 return running the following code:
 
 
 #!/usr/bin/perl
 
 use DBI;
 $dbh=DBI-connect('DBI:mysql:andy');
 my $query=select * from client;
 my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
 $sth-execute;
 my $rows;
 while(@row=$sth-fetchrow_array)
 {my $i;
 for $i (0..($sth-{num_of_fields}-1))
 {print [.$row[$i].];}
 print(\n);
 }
 $sth-finish;
 $dbh-disconnect
 
 I don't understand the code. I copy it from a book. I am trying to print out
 the records returned from a query.  I have a table named client in database
 andy. The table has 2 records.  When I run the above code, I have 2 blank
 lines return.  Could any one tell me what the problem is?  Where could I
 find better documentation on DBI::DBD::mysql stuff for beginner?  man
 DBD::mysql is difficult to understand.  Thanks again for the info.
 
 
 
 
 
 From: Chuck \PUP\ Payne [EMAIL PROTECTED]
 To: Doug Thompson [EMAIL PROTECTED],   Andy Cheng
 [EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
 [EMAIL PROTECTED] [EMAIL PROTECTED]
 Subject: Re: Mysql installation.  Help!
 Date: Sun, 10 Mar 2002 14:18:13 -0500
 
 Ok, if never run it then you have to start once, if I remember right undex
 Red Hat, you have to go to /etc/rc.d/init.d and do this...
 
 ./mysql start that will start it
 
 Then you will need to set it up so it will start later. SuSE you have to
 start it once
 
 You will then need to set a password for mysql.
 
 I hope that helps.
 
 
  
  | Chuck Payne  |
  | Magi Design and Support  |
  | www.magidesign.com   |
  | [EMAIL PROTECTED]   |
  
 
 BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
 Web Design you can afford.
 
 Fortune for today --
 
 Q:  How many Zen masters does it take to screw in a light bulb?
 A:  None.  The Universe spins the bulb, and the Zen master stays out
 of the way.
 
 
 
 If mysql.sock doesn't exist, that is because the server is not running.
 
 I fought the same battle as Mark and ultimately downloaded and installed
 the
 RPM for 3.23.49a from MySQL in place of
 the copy that came with RH.  The MySQL RPM installed and came up just
 like it
 says in the book.  Saves a lot of hair
 and dain bramage.
 
 If the server process _is_ running, it may be useful to go through the
 section
 on binary installation and check those
 items to see if your RPM set everything up correctly.  Don't bet on
 finding
 anything, but it doesn't take long to do
 these checks.
 http://www.mysql.com/doc/I/n/Installing_binary.html
 
 Regards,
 Doug
 
 Perfection is finally attained not when there is no longer anything to
 add,
 but when there is no longer anything to
 take away. -- Antoine de Saint Exup?ry
 
 On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
 
 What I did was beat my brains out on the same exact problem.  In the
 end I
 have no clue what I did to get it actually working.  I had re-installed
 the
 mysql from the .tar.gz, I installed all the RPM's several times.
 Everytime,
 I fully rebooted the system, and finally I have to run
 safe_mysqld --user=root
 
 I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
 rebooted the system, then re-ran safe_mysqld --user=root.
 
 Mark
 
 - Original Message -
 From: Andy Cheng [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Sunday, March 10, 2002 10:01 AM
 Subject: Mysql installation. Help!
 
 
 Hi all,
 I got this error message when trying to connect to mysql at the shell
 command:
 
 Error 2002:Can't connect to local MySql server through socket
 '/var/lib/mysql/mysql.sock
 
 
 There is no mysql.sock in the /var/lib/mysql directory. Did I miss
 some
 thing in the mysql installation?  Where could I find the mysql.sock?
 I
 install mysql that came with redhat 7.2. Thank for the help.
 
 
 
 
 
 
 
 
 
 -
 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

Re: Mysql installation. Help!

2002-03-10 Thread Sammy Lau

I don't think you need to know DBD::mysql (DBD::mysql is a DBD driver to
mysql). Go and have a look at the man page of DBI. You'll get what you
need.

Andy Cheng wrote:
 
 Thanks for the help.  I got it working. I could connect to mysql from shell
 command. Now I try to connect to mysql using perl.  I installed the DBI::DBD
 module for perl.  I think the DBI::DBD also working since I don't see error
 return running the following code:
 
 #!/usr/bin/perl
 
 use DBI;
 $dbh=DBI-connect('DBI:mysql:andy');
 my $query=select * from client;
 my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
 $sth-execute;
 my $rows;
 while(@row=$sth-fetchrow_array)
 {my $i;
 for $i (0..($sth-{num_of_fields}-1))
 {print [.$row[$i].];}
 print(\n);
 }
 $sth-finish;
 $dbh-disconnect
 
 I don't understand the code. I copy it from a book. I am trying to print out
 the records returned from a query.  I have a table named client in database
 andy. The table has 2 records.  When I run the above code, I have 2 blank
 lines return.  Could any one tell me what the problem is?  Where could I
 find better documentation on DBI::DBD::mysql stuff for beginner?  man
 DBD::mysql is difficult to understand.  Thanks again for the info.
 
 From: Chuck \PUP\ Payne [EMAIL PROTECTED]
 To: Doug Thompson [EMAIL PROTECTED],   Andy Cheng
 [EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
 [EMAIL PROTECTED] [EMAIL PROTECTED]
 Subject: Re: Mysql installation.  Help!
 Date: Sun, 10 Mar 2002 14:18:13 -0500
 
 Ok, if never run it then you have to start once, if I remember right undex
 Red Hat, you have to go to /etc/rc.d/init.d and do this...
 
 ./mysql start that will start it
 
 Then you will need to set it up so it will start later. SuSE you have to
 start it once
 
 You will then need to set a password for mysql.
 
 I hope that helps.
 
 
   
   | Chuck Payne  |
   | Magi Design and Support  |
   | www.magidesign.com   |
   | [EMAIL PROTECTED]   |
   
 
 BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
 Web Design you can afford.
 
 Fortune for today --
 
 Q:  How many Zen masters does it take to screw in a light bulb?
 A:  None.  The Universe spins the bulb, and the Zen master stays out
  of the way.
 
 
 
   If mysql.sock doesn't exist, that is because the server is not running.
  
   I fought the same battle as Mark and ultimately downloaded and installed
 the
   RPM for 3.23.49a from MySQL in place of
   the copy that came with RH.  The MySQL RPM installed and came up just
 like it
   says in the book.  Saves a lot of hair
   and dain bramage.
  
   If the server process _is_ running, it may be useful to go through the
 section
   on binary installation and check those
   items to see if your RPM set everything up correctly.  Don't bet on
 finding
   anything, but it doesn't take long to do
   these checks.
   http://www.mysql.com/doc/I/n/Installing_binary.html
  
   Regards,
   Doug
  
   Perfection is finally attained not when there is no longer anything to
 add,
   but when there is no longer anything to
   take away. -- Antoine de Saint Exup?ry
  
   On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
  
   What I did was beat my brains out on the same exact problem.  In the
 end I
   have no clue what I did to get it actually working.  I had re-installed
 the
   mysql from the .tar.gz, I installed all the RPM's several times.
 Everytime,
   I fully rebooted the system, and finally I have to run
   safe_mysqld --user=root
  
   I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
   rebooted the system, then re-ran safe_mysqld --user=root.
  
   Mark
  
   - Original Message -
   From: Andy Cheng [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Sunday, March 10, 2002 10:01 AM
   Subject: Mysql installation. Help!
  
  
   Hi all,
   I got this error message when trying to connect to mysql at the shell
   command:
  
   Error 2002:Can't connect to local MySql server through socket
   '/var/lib/mysql/mysql.sock
  
  
   There is no mysql.sock in the /var/lib/mysql directory. Did I miss
 some
   thing in the mysql installation?  Where could I find the mysql.sock?
 I
   install mysql that came with redhat 7.2. Thank for the help.
  
  
  
  
  
  
  
  
  
   -
   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

Re: mysql installation on linux(RH7.2)

2002-02-27 Thread Trond Eivind Glomsrød

nagendra  prasad [EMAIL PROTECTED] writes:

 hi
 i downloaded mysql rpms from mysql.com
  tried to install them on linux.
 when i use the command rpm -i mysqlpackname in shell
 it says
 
 error:can't get exclusive lock on /var/lib/rpm/packages
 error:can't open packages database in /var/lib/rpm
 
 what shall i do.

Install as root.

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

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

2002-02-15 Thread Miguel Angel Solorzano

At 13:35 15/02/2002 -0500, Juwon Aikulola wrote:
Hi!
Hi Gurus,
I downloaded and installed MySql successfully, on a Windows 2000 O/S. I 
want to locate the my-example.cnf file, copy it to my root directory and 
rename it my.cnf. However, the my-example.cnf file I locate is a 
shortcut, pointing to no physical target.

The shortcut was created because in your environment the extension
.cnf was applied for an MS application.
Open my computer.
In the Tool menu, open Folder Options.
Click the Tab Files Types.
Search for the .cnf extension and remove it (if you don't need this
set file option).
Create the my.cnf file again.

Regards,
Miguel

  As a result, after going through this process, I cannot open the file to 
 uncomment and edit the basedir line to point to MySql installation directory.
Somebody please help.

Thanks

Juwon

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.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

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


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

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




Re: mysql++ installation

2001-12-17 Thread Sinisa Milivojevic


Just ignore automake warnings.

Regarding /opt/sfw/bin/ginstall problems, configure probably
erred. Make a symlink so that the above ginstall points to the real
one. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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 problem on NT

2001-11-23 Thread DL Neil

Hi Joachim

I tried to install mySQL on Windows NT (Service Pack 6).
That means: Unzipping, installing, then starting mySQL as a service with
: mysqld-nt --install.
Until now everything worked fine and we saw the service in the NT's
Service list.
But we could not start the service. Neither with NT nor with NET START
mysql from the DOS box.
There was an error 1067.

=in the Services list what were the values? Was the status started and is startup 
automatic or manual.

=When mine installed, it came up auto and started automatically. Thus there was no 
need to use the DOS box/NET
command!

One more thing to explain: We installed mySQL in a directory
D:\inst\\
When we started: mysqld-nt --install there was no file my.cnf.
(Because my installation in the office is in C:\mysql I forgot to save
my.cnf in WINNT).
Maybe thats the problem. But I don´t know.

=use Windows Explorer or My Computer, navigate to the MySQL\bin sub-directory. Execute 
the WinMySQLAdmin program
and customise the relevant directory fields, then restart the MySQL server.

Second question: How to get rid of the mysql-service in the NT service
list.
You see I'm not very accustomed to WIN NT.

=the above answers this - it should start automatically. You should be able to use the 
admin GUI to stop and
restart it, if/when necessary, otherewise it will start automatically on every NT boot.

I hope somebody will help me.

=hope it has been helpful,
=dn



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

2001-11-12 Thread Boyd Lynn Gerber

database,sql,query,table

You have written the following:

You need to get gcc-2.95.2 over newer.  It is available on the
stage.caldera.com site.  or http://www.caldera.com/skunkware.

Good Luck,

--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975




-
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

2001-11-12 Thread ???? ?????????


- Original Message -
From: Boyd Lynn Gerber [EMAIL PROTECTED]
To: é×ÁÎ ðÏÎÏÍÁÒÅ× [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, November 11, 2001 5:57 PM
Subject: Re: MySQL installation problem


 You need to get gcc-2.95.2 over newer.  It is available on the
 stage.caldera.com site.  or http://www.caldera.com/skunkware.

I do this, but message is the same:
gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm
Undefined first referenced symbol in file
main   /usr/ccs/lib/crt1.o
conf_to_src: fatal error: Symbol referencing errors. No output written to
conf_to_src
***Error code 1 (bu21)
***Error code 1 (bu21)
***Error code 1 (bu21)
(I install MySQL  3.23.43 on SCO Open Server 3.2 v5.0.4
Other software: FSU Pthreads 3.5, gcc-2.95.2, GNU Make 3.78.1)
Can You help me?



-
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

2001-11-12 Thread Boyd Lynn Gerber

On Mon, 12 Nov 2001,  ? wrote:
  You need to get gcc-2.95.2 over newer.  It is available on the
  stage.caldera.com site.  or http://www.caldera.com/skunkware.
 
 I do this, but message is the same:
 gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm
 Undefined first referenced symbol in file
 main   /usr/ccs/lib/crt1.o
 conf_to_src: fatal error: Symbol referencing errors. No output written to
 conf_to_src
 ***Error code 1 (bu21)
 ***Error code 1 (bu21)
 ***Error code 1 (bu21)
 (I install MySQL  3.23.43 on SCO Open Server 3.2 v5.0.4
 Other software: FSU Pthreads 3.5, gcc-2.95.2, GNU Make 3.78.1)
 Can You help me?

Did you install the libraries and linkers from the CD.  That file is part
of the libraries and linkers.  Also have you installed all the patches?
I just did a complete make with out any problems on my OSR 5.0.4 system.
I am using GNU Make 3.79.1 and FSU Pthreads 3.8.  Foy can get the 3.8.
from.  I know that 5.0.4 and pervious versions are very buggy.
Unfortunately my ftp.zenez.com site is down.  The site below has many of
what I consider to be the most important files.

ftp://ftp.lerctr.org/pub/zenez

Good Luck,

--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975



-
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 on NT problem

2001-09-07 Thread Antonie Neethling

Hi,

Try to extract the files before running setup.exe. If this does not work you
zip archive may be corrupt.

Regards,
Antonie

-- S C I B I T --
Antonie Neethling ([EMAIL PROTECTED])
http://www.scibit.com/mysql - MySQL related products
-- S C I B I T --

 -Original Message-
 From: Sumit Ranjan [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 07, 2001 1:40 PM
 To: [EMAIL PROTECTED]
 Subject: mysql installation on NT problem


 hi all !
i am new to mysql and trying to install it onto my win NT 4.0
 workstation.
but the winzip is not able to install it !

is anybody else facing the same prob?
does anybody know the cure?

 sumit



 -
 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 on NT problem

2001-09-07 Thread Sumit Ranjan

hi !
 thanx for your reply. now i could install mysql on my NT.
 nut now when i give  the command mysql-nt --install it says unable
to install.

moreover as it is in the installaton doci tried to look for the
my-example.cnf file but i cud get only a link of this name in whole of
my hard disk  and that too is a speedDial file (clicking on it opens the
MS-netmeeting configuration dialogue).

please help.

sumit
- Original Message -
From: Antonie Neethling [EMAIL PROTECTED]
To: Sumit Ranjan [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 07, 2001 5:34 PM
Subject: RE: mysql installation on NT problem


 Hi,

 Try to extract the files before running setup.exe. If this does not work
you
 zip archive may be corrupt.

 Regards,
 Antonie

 -- S C I B I T --
 Antonie Neethling ([EMAIL PROTECTED])
 http://www.scibit.com/mysql - MySQL related products
 -- S C I B I T --

  -Original Message-
  From: Sumit Ranjan [mailto:[EMAIL PROTECTED]]
  Sent: Friday, September 07, 2001 1:40 PM
  To: [EMAIL PROTECTED]
  Subject: mysql installation on NT problem
 
 
  hi all !
 i am new to mysql and trying to install it onto my win NT 4.0
  workstation.
 but the winzip is not able to install it !
 
 is anybody else facing the same prob?
 does anybody know the cure?
 
  sumit
 
 
 
  -
  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

2001-08-23 Thread Sinisa Milivojevic

Antonio Scotti writes:
 I downloaded the libraries but I'm experiencing problems in installing
 them. I've decompressed them then I've run automake and autoconf. No
 problem. At this point I tried ./configure but during the process it stops
 with an error saying that cannot find mysql libraries in ' ' . What does it
 mean? What have i to do to install the APIs? Obviously I have installed the
 mysql server.
 
 Thanks in advice to everybody.
 
 Antonio Scotti
 

There are options for configure that let you specify mysql C API
includes directory and libs directory.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   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

2001-08-22 Thread Dr. Werner Stürenburg



Jaitly, Rajiv (Contractor) schrieb am Dienstag, 21. August 2001, 10:14:33:

 I installed the latest release of MYSQL on windows 2000 environment (non
 networked). I would like to add the mysql server start up as a service  at
 system startup. Could anybody tell me how to do this.

From my readme:

This distribution of MySQL includes the new winmysqladmin.exe
by Miguel A. Solórzano.  With this you can install MySQL as a service,
start the service and monitor MySQL.  This will also automaticly shut down
MySQL on Win9x when the machine needs to be rebooted.

Don't know if this applies to NT as well, but I should think so
and you can find out immediately.

-- 
Herzlich

Werner

MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Dr. Werner Stürenburg [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Consultant
/_/  /_/\_, /___/\___\_\___/   Bielefeld, Germany
   ___/   www.mysql.com   +49-5224-997-407  Fax -409



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

2001-06-27 Thread Jason Brunk

i originally tried to do it with the /stand/sysinstall on bsd, and it
installs it fine, but i am using the program MySQLFront to try and access
it, and it keeps coming up Host perm202-202.ij.net is not allowed to
connect to this mysql server  the host name perm202-202.ij.net is host of
my workstation since i am on a static ip, but i used

grant all privileges on *.* to jbrunk@%

and it goes into the user table of the database mysql, and shows that the
host that jbrunk is allowed to connect from is %  but it won't let me
connect from mysqlfront

Jason
- Original Message -
From: Peter Matulis [EMAIL PROTECTED]
To: 'Jason Brunk' [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 2:12 PM
Subject: RE: MySQL Installation Help Requested.


 From RPM, binary, or source?  I have my personal docs for source.

 Peter Matulis
 282-7073 ext 392
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


 -Original Message-
 From: Jason Brunk [mailto:[EMAIL PROTECTED]]
 Sent: June 27, 2001 12:43 PM
 To: [EMAIL PROTECTED]
 Subject: MySQL Installation Help Requested.


 is there anyone who icq and who has a few minutes that might be willing to
 help me out with the mysql install?  i have been having some trouble, so i
 figured i would check and see if there was anyone who could help a newbie
 out.

 Jason


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

2001-06-27 Thread Ansgar Becker

 
 grant all privileges on *.* to jbrunk@%
 
 and it goes into the user table of the database mysql, and shows that the
 host that jbrunk is allowed to connect from is %  but it won't let me
 connect from mysqlfront

did you FLUSH PRIVILEGES ?

Greetings,
Ansgar


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

2001-06-21 Thread Cal Evans

I think mysql.sock gets created once you start the server. Have you tried
starting it and then looking in /tmp?

Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Aditya Dhekney [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 2:19 PM
Subject: mysql installation from source


 Hi,
 I have been trying to install mysql on my server for way too long now!  my
 system specs are: intel i686, with linux 6.2 loaded.

 I think i once did get the installation to work almost correctly, or at
 least more correctly than it does now...

 the problem:  when i compile/make etc., i get no errors at all, so...you
may
 think...this is good! BUT, unfortunately every time i do this, there is no
 mysql.sock file in the /tmp/ directory...infact, it's nowhere on the
 system!!!  why would this be the case? where is it? and why doesn't the
 setup create it?  can someone PLEASE suggest what i can do...i'm out of
 ideas as to what could be causing this problem!

 Thanks in advance,
 Aditya Dhekney
 [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




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

2001-06-21 Thread Steve Brazill

Could you list (exactly) what commands you are using to 'unpack',
'configure', 'build', and 'install' the distribution (which package have you
downloaded ?) ??

- Original Message -
From: Aditya Dhekney [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:19 PM
Subject: mysql installation from source


 Hi,
 I have been trying to install mysql on my server for way too long now!  my
 system specs are: intel i686, with linux 6.2 loaded.

 I think i once did get the installation to work almost correctly, or at
 least more correctly than it does now...

 the problem:  when i compile/make etc., i get no errors at all, so...you
may
 think...this is good! BUT, unfortunately every time i do this, there is no
 mysql.sock file in the /tmp/ directory...infact, it's nowhere on the
 system!!!  why would this be the case? where is it? and why doesn't the
 setup create it?  can someone PLEASE suggest what i can do...i'm out of
 ideas as to what could be causing this problem!

 Thanks in advance,
 Aditya Dhekney
 [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



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

2001-06-21 Thread Aditya Dhekney



-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 3:31 PM
To: Aditya Dhekney; [EMAIL PROTECTED]
Subject: Re: mysql installation from source


I think mysql.sock gets created once you start the server. Have you tried
starting it and then looking in /tmp?

Cal

yes, i've tried that...i think..

when i run: bin/safe_mysqld 
i get: [root@oddjob mysql]# Starting mysqld daemon with databases from
/apps/mysql/var
010621 15:53:49  mysqld ended

thanks again, 
aditya
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Aditya Dhekney [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 2:19 PM
Subject: mysql installation from source


 Hi,
 I have been trying to install mysql on my server for way too long now!  my
 system specs are: intel i686, with linux 6.2 loaded.

 I think i once did get the installation to work almost correctly, or at
 least more correctly than it does now...

 the problem:  when i compile/make etc., i get no errors at all, so...you
may
 think...this is good! BUT, unfortunately every time i do this, there is no
 mysql.sock file in the /tmp/ directory...infact, it's nowhere on the
 system!!!  why would this be the case? where is it? and why doesn't the
 setup create it?  can someone PLEASE suggest what i can do...i'm out of
 ideas as to what could be causing this problem!

 Thanks in advance,
 Aditya Dhekney
 [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



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

2001-06-21 Thread Steve Brazill


You have some 'odd' options in your configuration 
line...Have you tried using a 'simple' configuration to see if it will 
buildproperly ? ./configure 
--prefix=/apps/mysqlAre you in the "/apps/mysql" directory when you run 
"mysql_install_db" ??(you should actually be typing "./bin/mysql_install_db" 
)If you're getting the message "Can't start server: Bind on TCP/IP 
port:Address already in use, Do you already have another mysqld server 
running onport: 3306" did you check to see if you DO have it running 
already ? (type"ps -ef | grep mysql" )I have attached my 'build' and 
'configure' webdocs for MySQL. Thedirectory 'paths' will be 
different than yours, but the rest should coverwhat you should be 
doing... (I've never had a problembuilding/installing/running MySQL on 
any RedHat 6.2 system). Look closelyat the permission settings I 
use.- Original Message -From: "Aditya Dhekney" 
[EMAIL PROTECTED]To: "'Steve Brazill'" [EMAIL PROTECTED]; 
,[EMAIL PROTECTED]Sent: Thursday, June 21, 2001 12:50 
PMSubject: RE: mysql installation from source 
-Original Message- From: Steve Brazill 
[mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:38 PM 
To: Aditya Dhekney Cc: [EMAIL PROTECTED] Subject: Re: mysql 
installation from source Could you list (exactly) what 
commands you are using to 'unpack', 'configure', 'build', and 'install' 
the distribution (which package haveyou downloaded ?) 
?? i'm using mysql-3.23.39.tar.gz these 
are the EXACT commands i used: tar -zxvf 
mysql-3.23.39.tar.gz cd mysql-3.23.39 
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -f no-exceptions 
-fno-rtti"./configure --prefix=/apps/mysql --enable-assembler 
-- with-mysqld-ldflags=-all-static make 
make install scripts/mysql_install_db chown -R 
root /apps/mysql/ chown -R mysql /apps/mysql/var 
chgrp -R mysql /apps/mysql/ /apps/mysql/bin/safe_mysqld 
--user=mysql  (this is where i get the first error (mysqld 
ended) in my host.err file, i get this: 010621 
15:11:40 mysqld started 010621 15:11:40 Can't start server: 
Bind on TCP/IP port: Address alreadyin use 010621 
15:11:40 Do you already have another mysqld server running 
onport: 3306 ? 010621 15:11:40 
Aborting 010621 15:11:40 /apps/mysql/libexec/mysqld: 
Shutdown Complete 010621 15:11:40 mysqld 
ended BUT, when i run ps, mysqld is NOT 
listed...:( I get the "check if tmp/mysql.sock exists" error 
when i try to use mysqladmin tool. should i be concerned 
about the message that says to check tmp/mysql.sock? 
Thanks, Aditya - Original Message - From: 
"Aditya Dhekney" [EMAIL PROTECTED] To: 
[EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 
PM Subject: mysql installation from source  
Hi,  I have been trying to install mysql on my server for way too 
long now!my  system specs are: intel i686, with linux 6.2 
loaded.   I think i once did get the installation to 
work almost correctly, or at  least more correctly than it does 
now...   the problem: when i compile/make etc., i 
get no errors at all, so...you may  think...this is good! 
BUT, unfortunately every time i do this, there isno  mysql.sock 
file in the /tmp/ directory...infact, it's nowhere on the  
system!!! why would this be the case? where is it? and why doesn't 
the  setup create it? can someone PLEASE suggest what i can 
do...i'm out of  ideas as to what could be causing this 
problem!   Thanks in advance,  Aditya 
Dhekney  [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: MySQL installation problem

2001-05-31 Thread Jeremy Zawodny

On Thu, May 31, 2001 at 06:27:38PM +0800, yewei wrote:
 Hi Dear Sir/Mdm,
 
 I've encountered a problem when I run 'scripts/mysql_install_db'
 command.  The error message is following:
 
 Starting mysql server
 ./bin/safe_mysqld: /my/gnu/bin/hostname: not found
 ./bin/safe_mysqld: /my/gnu/bin/hostname: not found
 ./bin/safe_mysqld: /my/gnu/bin/hostname: not found
 Starting mysqld demon with databases from
 /usr/local/mysql-3.21.33b-sun-solaris2
 .6-sparc/data
 mysqld demon ended
 
 I've followed the procedure of installation. What's wrong? Need to
 configure something?

Wow. That's a really old version of MySQL.

I'd suggest getting one of the newer releases before you spend much
time with it.

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

MySQL 3.23.29: up 6 days, processed 38,250,369 queries (73/sec. avg)

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

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