Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK -

Re: Problem with mysql

2010-01-11 Thread Ananda Kumar
use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; regards anandkl On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes sq...@dahl-stamnes.netwrote: On Monday 11 January 2010

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 09:55, Ananda Kumar wrote: use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; I just found the cause of the problem... /etc/nsswitch.conf. It

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem,

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
(Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote: (Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I

Re: Problem with mysql

2010-01-10 Thread sureshkumarilu
Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Suresh Kuna MySQL DBA --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo:

Re: Problem with mysql

2010-01-10 Thread Jørn Dahl-Stamnes
On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote: Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Woops... Seems like the * in my first mail

Re: Problem with mysql

2010-01-10 Thread Mihamina Rakotomandimby
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement

RE: Problem with MySQL user

2009-09-16 Thread Gavin Towey
Hi John, You can turn of name resolution by adding skip-name-resolve to the [mysqld] section of your my.cnf file. Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, September 16, 2009 4:24 PM To: mysql@lists.mysql.com Subject:

Re: Problem compiling mysql-5.1.33

2009-04-08 Thread walter harms
most likely a missing include it should have at least: #include sys/time.h #include sys/resource.h Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem schrieb: make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I.

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable default-file in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I believe that, different mysql configuration file for different mysql instance is a better idea. In your case, if any thing goes wrong with my.cnf Then, it is going to effect all mysql instance (either restart mysql server or any other way). It has a lots of disadvantages. You might

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, I use the script mysql_multi to stop and the start several, or all, instances. At the end, to work with more ease, I will create scripts to connect to each instance and in the script force the variable prompt at the connection seems easy Thanks for all !!!

Re: Problem with MySQL prompt

2008-12-22 Thread Claudio Nanni
Ciao Stefano, how do you connect to the different instances? if you use different operating system users or different mysql home directories just put in the home directory of each user a .my.cnf file (or my.cnf in the mysql home) with just the prompt setting in the [mysql] section. NOTE: in the

Re: Problem with MySQL prompt

2008-12-22 Thread Warren Young
Stefano Elmopi wrote: If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. This is because the client reads from my.cnf

Re: Problem with MySQL prompt

2008-12-22 Thread Krishna Chandra Prajapati
Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi

Re: Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
Thanks for the all answers !!! It's ok, even if I have three different my.cnf for my three instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log =

Re: Problem with MySQL prompt

2008-12-22 Thread Simon J Mudd
prajapat...@gmail.com (Krishna Chandra Prajapati) writes: You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance.

Re: problem accessing mysql from PHP

2006-03-10 Thread SGreen
Nestor [EMAIL PROTECTED] wrote on 03/10/2006 02:33:50 PM: I am getting this error and I do not know why? Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can access mysql from the command line and I can access it from

Re: Problem installing mysql on Debian linux

2006-02-25 Thread Sam Tran
On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was:

Re: Problem installing mysql on Debian linux

2006-02-25 Thread Tselemegkos Grigorios
:34 PM Subject: Re: Problem installing mysql on Debian linux On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix

Re: Problem installing MySQL 5.0

2006-01-03 Thread Chander Ganesan
You can force the installation (--nodeps) when installing the RPM package. Even if you build DBI (and not install it from RPM) it won't be in the RPM database, and you'll get the same error. You should be able to get a FC2 RPM for the DBI module - download that RPM and install it, then

Re: Problem installing MySQL 5.0

2006-01-03 Thread Francesco Vincenti
Hello Chander, thank you very much. I tried to do in your way ad the installation works! I downloaded the perl(DBI) .rpm and I installed it the first time using the command: rpm -Uvh perl-DBI-1.50-1.i386.rpm but I got back an error about one glibc library not founded, so I use this format: rpm

Re: Problem installing MySQL on Mac OSX 10.4.3

2005-12-05 Thread Brent Baisley
Those message are kind of odd, even on a messed up system. I would first run the repair privileges in the disk utility for good measure, then delete all traces of MySQL and just start over. MySQL should be in /usr/local/mysql. To remove it just type: sudo rm -R /usr/local/mysql Then try

Re: Problem with MySQL 5 on OS X Tiger

2005-12-01 Thread Gleb Paharenko
Hello. Some tips from the manual could be helpful. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html untz wrote: Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger...

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Lachlan Mulcahy
Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Michael Stassen
Lachlan Mulcahy wrote: Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no

Re: Problem with mysql-administrator-1.1.5, s.o.

2005-11-24 Thread Gleb Paharenko
Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running

Re: Problem starting MySQL With Moved Data Directory

2005-10-25 Thread Gleb Paharenko
Hello. and restarted MySQL with /etc/init.d/mysql start, I get the following: Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]'

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-10 Thread Joerg Bruehe
Hi Jon, all! Jon Earle wrote: Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-09 Thread Jon Earle
Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd install-tools export

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-07 Thread Joerg Bruehe
Hi! Jon Earle wrote: Hi all! I'm having trouble building the latest stable on AIX 5.1. My env is as follows: Relevant GNU tools: [[...]] gcc-3.3.2-4.aix5.1.ppc.rpm [[...]] I admit I did not use gcc on AIX for quite some time. Results in the following error: ... checking term.h usability... no

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-29 Thread Matt Wagner
It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-28 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file

Re: Problem installing Mysql 4.1 on Fedora 2

2004-11-16 Thread Spenser
I had the same problem. It just won't seem to upgrade. You need to uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first. Enter something like this: rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9 When it's done, then install version 4.x On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED]

RE: Problem running MySQL in high school lab

2004-08-31 Thread SGreen
I second Todd's suggestion. There is no need to run Cygwin in order to have the MySQL servers or clients or any of its tools operating under Win32 (95, 98, 2000, ME, 2003, XP, etc). I only ever use Cygwin when I need to run a remote Linux desktop and as a teaching tool. Everything else I do

RE: Problem running MySQL in high school lab

2004-08-30 Thread Donny Simonton
Todd, I don't use Windows XP as a production machine, but I do run MySQL on my personal machine running Windows XP, I run the Windows version of MySQL. Is there any reason that you are using Cygwin to run MySQL when you can run the MySQL windows binaries without any problems? The only thing I

RE: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Donny Simonton
This is not a mysql problem, it is a phpmyadmin problem. You must be using 2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I have complained to them about it, but not exactly sure what they are going to do. Donny -Original Message- From: Martin Rytz

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jan Kirchhoff
That sounds like a typical mod_perl-problem. The script is making new connections and doesn't close the old ones. You should add debug-code to your script and add * * * * * root mysql -e 'show processlist' /tmp/mysql_processlist_debug_`date +%s`.txt to your /etc/crontab in order to log the

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread William R. Mussatto
Thanks for the two responses. William Mussatto said: Are you running mod_perl? Yes I am, with Perl 5.8.3. Victor Pendleton said: What does mysql show processlist look like? Here is what it looks like currently, but the system is not in its unresponsive phase right now. I can't force

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jocelyn Fournier
Fournier www.presence-pc.com - Original Message - From: Jan Kirchhoff [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 7:43 PM Subject: Re: Problem with Mysql 4.0.18 + Debian That sounds like a typical mod_perl-problem. The script is making new

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jan Kirchhoff
Jocelyn Fournier wrote: Hi, A quick fix would be to set the wait_timeout variable in the my.cnf to a much smaller value than 28800 (default value). Try to add wait_timeout=60 in the my.cnf for example, the connections should be automatically closed after 60 secondes if there are not used anymore.

RE: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread Victor Pendleton
What does mysql show processlist look like? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good

RE: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread William R. Mussatto
Victor Pendleton said: What does mysql show processlist look like? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian

Re: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread Batara Kesuma
Ryan, Here's the problem. I had the site up several days, with everything running perfectly. Ordinarily there would be about 11 mysql processes running. However, after a few days of running smoothly, the number of mysql processes increases to over 170, and the site crashes. Formerly I'd

Re: Problem with Mysql 4.0.18 + Apache

2004-07-21 Thread William R. Mussatto
Hello: I posted this before but I have made some changes since then (not that they helped much). I have a Debian (woody) server running a good sized database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 + perl and using mysql as the backend. In my.cnf, I set

Re: Problem Installing MySQL Max

2004-05-24 Thread Jack Woehr
Lou Olsten wrote: I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Brent Baisley
If you don't have a process mysqld running, then mysql isn't running. You may try starting up mysql directly (just type mysqld), rather than through the startup script or through mysqld_safe, since they suppress the error messages. You should then see some error message that may help determine

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Gabriel Ricard
Did you configure MySQL and run the /usr/local/mysql/scripts/mysql_install_db to initialize your data directory? - Gabriel On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg

Re: Problem running MySQL on MacOS X.3

2004-05-11 Thread Rich Allen
ps should show you something like the following: Jupiter:~/desktop hcir$ ps uax | grep mysql root 291 0.0 0.118644 1072 ?? S 3May04 0:00.06 sh ./bin/safe_mysqld --user=mysql mysql 338 0.0 2.551720 19872 ?? S 3May04 10:17.86

Re: Problem running MySQL on MacOS X.3

2004-05-10 Thread Sasha Pachev
Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to

Re: Problem running MySQL

2004-04-14 Thread Egor Egorov
Franz Klein [EMAIL PROTECTED] wrote: I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a network. I have administrator privileges. I have also installed MySQL Administrator. When I try to look at the users I get the following error message: Could not fetch Usernames

Re: Problem with mySQL and Mac OS X

2003-12-19 Thread Michael Stassen
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first guess would be that the upgrade reset the permissions on /tmp, so now the mysql user doesn't have permission to create mysql.sock. Try cd /tmp sudo chmod 1777 . then see if mysqld will start. (While you're in /tmp,

Re: problem with 'mysql' command on Mac OS X 1.3 (Panther)

2003-10-31 Thread Brent Baisley
What version of mysql are you using? I'm running 4.0.14 and I upgraded without a problem. On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote: Ever since upgrading I haven't been able to use the 'mysql' command--it just hangs. Otherwise, the database seems to be working

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-29 Thread Anderson, James H [IT]
Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 2:03 PM --To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- --BTW, nothing's changed in my.cnf... -- --.my.cnf

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Dathan Vance Pattishall
Can you post you’re my.cnf options / your query in question / how long have you seen it hang / what status it is in / and your show status vars. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message-

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Anderson, James H [IT]
- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 4:42 PM To: Anderson, James H [IT]; [EMAIL PROTECTED] Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) Can you post you're my.cnf options / your query in question / how long have you seen

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Dathan Vance Pattishall
:[EMAIL PROTECTED] --Sent: Tuesday, October 28, 2003 2:03 PM --To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] --Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) -- --BTW, nothing's changed in my.cnf... -- --.my.cnf - --[client] --host=localhost --user=jim --password

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install MySQL 4.0.14 windows version and try to import

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread Sergei Golubchik
Hi! On Sep 10, Victoria Reznichenko wrote: [EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread joei
Victoria, Thanks. -- __ Sign-up for your own personalized E-mail at Mail.com http://www.mail.com/?sr=signup CareerBuilder.com has over 400,000 jobs. Be smarter about your job search http://corp.mail.com/careers -- MySQL General Mailing

Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3

2003-08-21 Thread Egor Egorov
Devang Panchalia [EMAIL PROTECTED] wrote: Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is

Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3

2003-08-21 Thread Kieran Kelleher
It may be that you did not give the mysql user ownership of the Data folder? Check your permissions first by typing: [KieranMac:~] kieran% ls -al /usr/local/mysql/ this shold show data folder as something like this: drwxr-x--- 13 mysql wheel 442 Aug 19 19:52 data Type this on the

Re: Problem installing MySQL v4.0.14b

2003-08-17 Thread miguel solorzano
At 17:35 17/8/2003 +0100, Debbie wrote: Hi, Hi, I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The above frequently happens because the installer

Re: problem installing mysql

2003-07-29 Thread tevans
Make sure your firewall isn't blocking port 3306 (the default tcp port) on localhost (127.0.0.1). Firewalls DO matter. I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: Cannot connect to localhost port... my

Re: problem with mysql-crashes

2003-07-23 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Is that a self-compiled binary or one of

Re: problem with mysql-crashes

2003-07-23 Thread Thomas Seifert
Hi Lenz, thanks a lot for your reply! Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or

Re: Problem When Mysql runs on a Machine with multiple NIC.

2003-07-10 Thread P Srinivasulu
Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So

Re: Problem When Mysql runs on a Machine with multiple NIC.

2003-07-10 Thread Dominicus Donny
: Re: Problem When Mysql runs on a Machine with multiple NIC. Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP

Re: Problem When Mysql runs on a Machine with multiple NIC.

2003-07-09 Thread Paul DuBois
At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server.

Re: Problem with mysql replication

2003-06-06 Thread Victoria Reznichenko
Dan Houtz [EMAIL PROTECTED] wrote: I'm currently trying to setup replication following the directions from the mysql manual, however, once I configure the slave server with the server-id parameter, it fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. I'm

RE: Problem starting mysql server

2003-05-30 Thread Nick Arnett
-Original Message- From: Rehaz Golamnobee [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 3:41 AM ... I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting

Re: Problem starting mysql server

2003-05-30 Thread Chris Tucker
You should probably also take a look at your error log (dbmaster.err)...it'll tell you in much more detail why mysqld ended rather than continued running as expected. Often this will be something as simple as your directory permissions not being set right on your data dir... Chris Nick

Re: Problem compiling mysql-connector-java 3.1.0-alpha

2003-05-30 Thread Pierre
Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources

Re: Problem starting mysql server

2003-05-29 Thread Sinisa Milivojevic
Rehaz Golamnobee writes: Hi I have just upgraded my MySQL from version 3.23 to 4.0.13. However I cannot start the server. When I type mysqld_safe I get the following : [1] 1730 Linux:/# starting mysqld-max daemon with databases from /var/lib/mysql 030529 11:10:51 mysqld ended [1]+

Re: Problem compiling mysql-connector-java 3.1.0-alpha

2003-05-29 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources clean:

Re: Problem reinstalling MySQL on Mac OS X

2003-03-19 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. I assume, you used the MySQL package from mysql.com? On Thu, 6 Mar 2003, Perry Arnold wrote: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start

Re: Problem with MySQL, MyODBC, Access 2002 and Japanese.

2003-02-25 Thread Tore Bostrup
Don't know, but: Are you using the Japanese Access 2002? What locale is your OS configured for? HTH, Tore. - Original Message - From: Juan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:12 AM Subject: Problem with MySQL, MyODBC, Access 2002 and Japanese.

Re: problem building mysql as an embedded server

2003-02-18 Thread Travis McLeskey
Hi All, I am trying to run mysqld as an embedded server within my application. I have read the manual which says to run configure with --with-embedded-server option, but I have not succeded in building libmysqld.a. It builds all the remaining libs, but I don't find libmysqld.a anywhere

Re: Problem Editing mysql Text field

2003-02-13 Thread Insanely Great
Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL

Re: Problem Editing mysql Text field

2003-02-13 Thread Daniel Negron/KBE
] | | cc: | | Subject: Re: Problem Editing mysql Text field

Re: Problem compiling mysql-3.23.53

2002-12-09 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 9 Dec 2002, Pierre wrote: I tried mysql-4.0.5a-beta, and same error... Try to compile without --with-libwrap - seems like there is a buglet in this part of the code - or do you desperately need TCP wrapper support? Bye, LenZ - --

Re: Problem compiling mysql-3.23.53

2002-12-08 Thread Pierre
I tried mysql-4.0.5a-beta, and same error... Pierre. On 2002.12.08 02:36 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql'

Re: Problem compiling mysql 3.23.53

2002-12-07 Thread Pierre
I finally found the solution : I had bad old include files in /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/ that come from a old gcc installation. I removed them and now it's ok. Pierre. On 2002.11.13 06:50 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote: Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) and I just downloaded MySQL-GUI and can't seem to get it working. It keeps telling me that it cannot connect through the socket (111). Can someone tell me

RE: Problem with MySQL-GUI

2002-11-10 Thread daniel
running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote:

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? If I am not mistaken the socket works only for a connection between server

RE: Problem with MySQL-GUI

2002-11-10 Thread daniel
i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? = Original Message From R. Hannes Niedner [EMAIL PROTECTED] = On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote: running on localhost using the socket connection

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 9:42 PM, daniel [EMAIL PROTECTED] wrote: i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same computer you

Re: problem with mysql on windows

2002-10-29 Thread Gelu Gogancea
Hi, It's possible, to have some software/scripts which run in out of environment space. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -

Re: Problem with mysql jdbc Connector

2002-10-13 Thread Mark Matthews
janesh wrote: HI I am accessing mysql through Websphere 5.0 through jsp file . it says SQLException: Cannot connect to MySQL server on host:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01

Re: Problem with mysql.

2002-10-10 Thread gerald_clark
you need the ncurses libraries. Philippe Benchemoul wrote: Hi, I try to install mysql 3.23.52 on a debian 2.2.8 with the sources. ./configure --prefix=/usr/local/progs/mysql For the configure level, I have the message : checking for termcap functions library... configure: error:

Re: Problem compiling mysql-3.23.52

2002-09-08 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 08 September 2002 02:25, Javier Suarez wrote: Im having a problem compiling the version of the subject, the problem is with the gethotsbyname function and the message is the next: libmysql.c: In function `mysql_real_connect':

Re: Problem Installing mysql-3.23.52

2002-09-01 Thread David Lloyd
( mysql, query ) Can anyone help. I'm installing (at the mo) 4.0.3 Beta, but the error message is the same which ever version.. libmysql.c: In function `mysql_real_connect': libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1675: too

Re: Problem Installing mysql-3.23.52

2002-08-29 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 28 August 2002 22:53, Carlos Oyarzún wrote: I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m using the following procedure: ./configure --prefix=/usr/local/mysql make make install The first two commands

Re: Problem with mysql making my server extremly slow

2002-08-20 Thread Victoria Reznichenko
Magnet, Monday, August 19, 2002, 11:11:38 PM, you wrote: M I manage a web server having a lot of http connections, using M Apache/PHP/MySQL. When there are too many simultaneous connections (so, many M MySQL requests), MySQL stops working efficiently and makes my load average M increase a LOT

Re: problem with mysql threads on freebsd

2002-06-11 Thread Dicky Wahyu Purnomo
On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer [EMAIL PROTECTED] wrote: im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? from what method / tools, you get this information ? try mysqladmin -p status -- Linux is not

  1   2   >