Mike, much thanks and I have it fixed!
The problem was that I screwed up setting the database permissions. I am
really happy that I learned about
mysql -h
It will be a great help!
Michel
- Original Message -
From: Michael Dykman mdyk...@gmail.com
To: michel compu
that the reason is that the C3P0 connection pooling cannot
work on a 'remote' machine.
Michel
- Original Message -
From: Rob Wultsch wult...@gmail.com
To: michel compu...@videotron.ca
Cc: mysql@lists.mysql.com
Sent: Tuesday, July 06, 2010 1:52 AM
Subject: Re: Connection Diagnostic
it?
Thanks!
- Original Message -
From: Michael Dykman mdyk...@gmail.com
To: michel compu...@videotron.ca
Sent: Saturday, July 03, 2010 11:37 PM
Subject: Re: Connection Diagnostic Tool
You are right.. Java never coonnects on that domain socket, it
*always* used TCP.
Check your credentials
I am setting up the Softslate web store package that uses Hibernate to
connect to MySQL. Softslate fails to connect to MysQL on the c3p0 connection
pooling. While I would love to solve this little problem it would be wiser
if I learn to diagnose the problem. Is there a tool that can run on the
I am installing mysql-workbench- oss-5.1.16. tar.gz on Linux and I hit this bug
during ./configure
cannot find install-sh or install.sh
I checked and the file install-sh is in the directory ... /mysql-workbench-
oss-5.1.16. I have also installed a lot of other software in the server without
I have MySQL set up and running, but I am under the impression that I am unable
to password protect it properly because I can't protect it as root user. From
what I've been reading I should be setting it up as
mysqladmin -u root password _thepassword_
But with phpMyAdmin I can still log in as
sjm...@pobox.com
To: mysql@lists.mysql.com
Sent: Sunday, May 10, 2009 5:20 AM
Subject: Re: Still going in cicrles
compu...@videotron.ca (michel) writes:
I set up MySQL and when I try to start it it fails telling me that I
need to run 'mysql_upgrade'.
Show us the full error output and provide
Message -
From: Simon J Mudd sjm...@pobox.com
To: mysql@lists.mysql.com
Sent: Sunday, May 10, 2009 8:03 AM
Subject: Re: Still going in cicrles
compu...@videotron.ca (michel) writes:
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
and I would get
/home/qsys/mysql
I set up MySQL and when I try to start it it fails telling me that I need to
run 'mysql_upgrade'. When I run 'mysql_upgrade' it runs 'mysqlcheck' which is
supposed to only be run when the server works ...
I set up mysql and can't start it because I need to hard code the IP address
parameter (bind-address) into my.cnf ... but I have three of them in different
sub directories of /mysql/mysql-test/suite
Should there not be one basic one?
Is there a place on the net that has detailed documentation on the possible
parameters? I am doing a quick google and can't find it.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I am trying to set up MySQL on a GNU/Linux box with this script:cd /home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure --prefix=/home/qsys/mysql-5.1.32 \
Sorry for the bad end of lines in the first message!
I am trying to set up MySQL on a GNU/Linux box with this script:cd
/home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure
of nulls its is better to place the important indexed fields toward
the beginning of the table.
michel
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 090313-0, 03/13/2009
Tested on: 3/14/2009 10:23:29 AM
avast! - copyright (c) 1988-2009 ALWIL Software.
http://www.avast.com
From the different documentation I was reading that after going to the root
directory I should execute /.configure; but there is no configure file in the
root source directory, just configure.in
--
Michel Buijsmantty.nl -- 2dehands.nl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
= thread_concurrency=4
set-variable= myisam_sort_buffer_size=64M
skip-innodb
--
Michel Buijsmantty.nl -- 2dehands.nl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Feb 16, 2005 at 12:41:04PM +0100, Michel Buijsman wrote:
My problem: INSERT queries hang on amd64.
Sorry about the multiple mails, mysql.com's mailinglist software
does annoying things with the wrong adresses...
--
Michel Buijsmantty.nl -- 2dehands.nl
= thread_concurrency=4
set-variable= myisam_sort_buffer_size=64M
skip-innodb
--
Michel Buijsmantty.nl -- 2dehands.nl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
website ?
(I only have a phpMyAdmin access)
Sorry if the answer is obvious, but I'm new to MySQL, phpMyAdmin.
My local config is PowerMac G4, Mac OS X 10.3.5, MySQL 4.0.21
Thanks in advance
Michel RENON
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I've read it now a few times around here and was curious what
innodb means. Is it a table-type for MySQL or a completely
different DBMS?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am trying to access a third party MySQL table containing a BigInt field,
using ADO with a MyOLEDB driver.
The problem is that all this field ever returns are 0's.
I tried using ODBC with the Convert BigInt to Int option but then the
numbers get truncated.
Is there a way around this?
The others files compile OK.
I have spend several days on this and I have not found the error, Is it
a known bug ? and have you a solution to this problem.
Many thanks for your answer
Michel DROZ
[EMAIL PROTECTED]
-
Before posting
; but an entire
column of 1's when I don't... even though @count returns NULL?
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
-
Before posting, please check:
http://www.mysql.com/manual.php
I think what you are looking for is the Insert...Select statement
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: Eric Spletzer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
Or you can add
safe_show_database
to your my.cnf, or call safe_mysqld with the added option
--safe_show_database
do you have to compile mysql with some special parameter? My version
(3.23.37, SuSE rpm) fails with a unrecognized command error when I try to
start it after having inserted
-pattern limit 1;
jean-michel
-
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
as normal user.
You need add a root password:
[shell]mysql -u root mysql
mysql update user set Password=password('x') wher User='root';
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
? Where I can find out what the codes
mean ?
Regards,
Rick
bonjour,
did you ran mysql_install_db script ?
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
-michel
-
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
can do this kind of
non-inserting problem.
query, database
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
command
Bonjour,
Are root privileges really established? I had that error message once a
day. If root password is not set, in extenso there is no root, you cannot
use GRANT statement. Have a look in mysql.user table to see check for
root password.
jean-michel
)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
jean-michel
-
Before posting, please check:
http://www.mysql.com
thought using the result identifier returned by mysql_query in mysql_fetch_array
was perfectly legal.
bonjour,
Try: ...where id = '$id';
on line 25
jean-michel
-
Before posting, please check:
http://www.mysql.com
The Linux kernel is 2.2.13 and has been installed from a Mandrake
distribution. This is also the source of Apache, PHP 3 and MySQL. The
distribution puts files in non-standard places so I am wondering if the
solution to my problem is to find the right base directory to use in the
Have you tried 'flush privileges' after having set root password?
jean-michel
On Thu, 31 May 2001, Damnish wrote:
I am using MySql on linux.
I can start mysqld by safe_mysqld --user=mysql --skip-grant-tables
But when i try to start it withour --skip-grant-tables, it said
Game.gameTurn = 3)
AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE
Game.gameTurn = 3);
bonjour,
You can't use subselect.
--
jean-michel
-
Before posting, please check:
http://www.mysql.com
that library anywhere? What am I doing wrong?
bonjour,
I compiled mysql with --prefix=/usr/local/mysql
and then php: CPPFLAGS=-I/usr/local/mysql/include/mysql ./configure
--with-mysql=/usr/local/mysql
--
jean-michel
-
Before
get no error, but the script just hangs. It never
connects to the database. I've looked through all my logs, and there are no
errors listed anywhere. Any ideas?
Stephanie DeVille
bonjour,
Can you give us an idea of your script?
--
jean-michel
password=password(the-password-I-want) where
user = 'root';
You use the password() function to set a new password.
--
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
);
?
and in variables.php3 file
?
$db_server = host;
$db_login = user;
$db_password = mypassword;
$db = database;
?
and protect include-directory with .htaccess
--
jean-michel
-
Before posting, please check:
http://www.mysql.com
rows in set (0.00 sec)
Bonjour,
It sometimes happens to me with mysql 3.22.32 (rpm) on mandrake 7.1.
Somes files become uid/gid root/root instead of mysql/mysql. So I need to
change file permissions.
May be someone get an answer?
I apologize for my poor english...
--
jean-michel
Product (
- productID numeric(10),
- name varchar(30),
- primary key(productID)
- );
ERROR 1046: No Database Selected
mysql
How do I fix that please???
siomara
mysqluse the-database-y-created-before;
--
jean-michel
-safe-client --with-berk
eley-db --with-innobase
Perl: This is perl, version 5.005_03 built for sun4-solaris
Michel AVERSENG
05 31 34 77 05
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
t a client
that works?
Thanks,
Erik
[EMAIL PROTECTED]
I needed to install MySQL rpm AND MySQL-client rpm in Mandrake 7.1
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
language used to
access the database.
bonjour,
neither foreign keys nor need for foreign keys using mysql. Use WHERE
clause.
--
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
because that would delete BOTH of
them. Doh! Any help?
Ryan Shrout
Production Manager
Athlonmb.com
http://www.athlonmb.com
[EMAIL PROTECTED]
bonjour,
is: delete from Pages where PageId='1' enough?
jean-michel
=/path/to/mysql ?
Thanks for any suggestion/comment in advance!
bonjour,
--with-mysql=path/to/mysql is a configure option when compiling php from
sources. Use only rpm -ivh mysql-rpm
--
jean-michel
-
Before posting, please
On Mon, 2 Apr 2001, Derek Sivers wrote:
Date: Mon, 02 Apr 2001 19:42:18 -0700
From: Derek Sivers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: NEW "MAKE" BUG? sigcontext.h
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
stock Cobalt RaQ3 (Linux 386) which I've
Hi List,
Whem I will go start the MySQL in Linux, receive a error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock`(111)
What I do?
Thanks
Edgard Arthur Michel
[EMAIL PROTECTED]
Brazil
TWEEN "2000-1-2" AND "2000-1-4";
+-+
| datum |
+-+
| 2000-01-02 00:00:00 |
| 2000-01-03 00:00:00 |
| 2000-01-04 00:00:00 |
| 2000-01-02 00:00:00 |
| 2000-01-03 00:00:00 |
| 2000-01-04 00:00:00 |
+-+
6 rows in set (0.00 sec)
Can somebody tell me the reason ?
Michel TIGNYEMB
FTeB
01 46 12 69 45
51 matches
Mail list logo