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"
To: "michel"
that the reason is that the C3P0 connection pooling cannot
work on a 'remote' machine.
Michel
- Original Message -
From: "Rob Wultsch"
To: "michel"
Cc:
Sent: Tuesday, July 06, 2010 1:52 AM
Subject: Re: Connection Diagnostic Tool
On Mon, Jul 5, 2010
d how to run it?
Thanks!
- Original Message -
From: "Michael Dykman"
To: "michel"
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 at
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 withou
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
Message -
From: "Simon J Mudd"
To:
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-5.1.32/libexec/mys
sages
- Original Message -
From: "Simon J Mudd"
To:
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'.
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
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 --pref
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 \
--with-unix-socket
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
= join_buffer_size=8M
set-variable = 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 -- 2de
= join_buffer_size=8M
set-variable = 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]
tmp_table_size=16M
set-variable= interactive_timeout=600
set-variable= wait_timeout=600
set-variable= max_connections=1024
set-variable= query_cache_type=2
set-variable= query_cache_size=100M
set-variable= join_buffer_size=8M
set-variable= thread_concurrency=4
set-variable
that export/import of datas ?
What to do if I want to upload bigger datas on the existing 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 R
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?
Than
o] Error 1
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]
-
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: &
set @count=NULL; 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:/
>
>
> 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 havin
Hi all,
I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are
hosting a small amount of virtual servers, allowing our customers to user
php and mysql. My problem is that every user sees every other users
databases. Is there a way to setup mysql so that every local user has hi
ewhere some-matching-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 <[EM
't use
GRANT command. That is the same for a bash command you're not allowed to use
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
-
The thing is I'm using an example DB, any help ? Where I can find out what the codes
>mean ?
>
> Regards,
>
> Rick
bonjour,
did you ran mysql_install_db script ?
jean-michel
-
Before posting, p
sert duplicate rows in a unique field 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 l
y.
if you mean html tag =
and if i do understand what you mean with my poor english...
jean-michel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
ning: Supplied argument is not a valid MySQL result resource in
> /home/sites/site197/web/practice/phpmysqlpract.php on line 26
> Genus:
Bonjour,
mysql_result's syntax seems to be OK.
check code for $result
jean-michel
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> >ERROR 1047: Unknown 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
--
> 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 PR
>
> echo("Review stored successfully.");
>
> } } }
> ?>
>
>
>
> It gives me the success message but the db remains untouched. What have I done this
>time? :)
>
> Thanks in advance.
>
Bonjour,
mysql_select_db(string db_name);
So try : m
l);
> 27: $row = mysql_fetch_array($r);
>
> I 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
---
> >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
Code NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
> 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
&
then connect to mysql:mysql -u root
then: mysql> update user set password=password(the-password-I-want) where
user = 'root';
You use the password() function to set a new password.
--
jean-michel
-
Before posti
try
> mysql_connect. I 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
sqldir'
> > >
> > >I did a search through the mysqsl (3.23.38) source code after I compiled
> > >it, and I don't find that library anywhere? What am I doing wrong?
bonjour,
I compiled mysql with --prefix=/us
ors" when needed in PHP to
>access the db. The password is in plain english in all the php files, and can be
>easily downloaded by anyone.
>
> Philippe
>
> ex:
>
> mysql_select_db("database");
> ?>
and in va
.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
-
Before posting, please check:
http://www.my
getting this error
>
> mysql> create table Product (
> -> productID numeric(10),
> -> name varchar(30),
> -> primary key(productID)
> -> );
> ERROR 1046: No Database Selected
> mysql>
>
> How do I fix that pl
ou to have 3 tables like:
1.email_adress_type
2.email_adress_account: user_id, email_adress, adress_type,password, login
3.sub_email_adress_account: email_adress, sub_password, sub_login
--
jean-michel
-
Before posting, ple
ash screen when I try to run it. Can you tell me where to get a client
> that works?
>
> Thanks,
> Erik
> [EMAIL PROTECTED]
>
I needed to install MySQL rpm AND MySQL-client rpm in Mandrake 7.1
jean-michel
-
-socket-path=/var/tmp/mysql.sock --with-low-memory -
-with-mit-threads=yes --without-perl --enable-thread-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
--
with-mysql or
>
> --with-mysql=/usr/bin or
>
> --with-mysql=/path/to/mysql ?
>
> Thanks for any suggestion/comment in advance!
>
>
bonjour,
--with-mysql=path/to/mysql is a configure option when com
69words words most
>
> I can't do the delete that I was thinking about:
>
> Delete FROM Pages Where Pageid=1 and articleid=69 because that would delete BOTH of
>them. Doh! Any help?
>
>
> Ryan Shrout
> Production Manager
> Athlon
way to use them is with the scripting 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://w
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) wh
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
I have done the source installation of MySQL 3.23.31 on Sun Solaris 2.6.
I execute tests found in .../mysql-test directory using 'force' option to continue
after aborted tests ( ./mysql-test-run --force).
How can I do with those aborted cases, known that I have to install master-slave
replica
t1 VALUES ( "2000-1-5" );
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM t1 WHERE datum BETWEEN "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
Capabilities: 8325 packet_length: 0 Host: 'localhost' User: 'root'
Using password: yes Access: 32768 db: '*none*'
~THD(): info: freeing host
end_thread: info: Adding thread to cache
process_alarm: info: sig: 14 active alarms: 0
~
Michel TIGNYEMB
FTeB
01 46 12 69 45
57 matches
Mail list logo
