Hi,
I have been noticing following error when trying to connect mysql.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
or
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
What could be reason?
Is there any way I can connect to databa
In the last episode (Jun 03), Ana Leite said:
> I'm new to MySQL and I'm trying to write a program that among other
> things monitors database usage. I would like to write an SQL query to
> retrieve info like session id, user name, cpu usage. Is there any
> MySQL system tables that gives me this so
Hi all,
I'm new to MySQL and I'm trying to write a program that among other things
monitors database usage. I would like to write an SQL query to retrieve info
like session id, user name, cpu usage. Is there any MySQL system tables that
gives me this sort of information?
To be more precise,
I am stumped with this compile problem with 4.0.24 src. Not sure what
is causing it. Can anyone provide some insights? Last time I compiled
on the same environment was 4.0.20 source. And all was ok.
gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/ms/svc/mysql/4.0.24\""
-DDATADIR="\"/ms/data/mysql/4.0.
Joey wrote:
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new style passw
I took a couple of days vacation last week and naturally the /data partition of
my database server filled up because of something I was running and had
forgotten about. So my backup guy, thinking to help out, gzipped all my .bin
logs. Now I am noticing replication seems to have stopped on my
On Friday 03 June 2005 03:36 pm, Joey wrote:
> SET PASSWORD FOR 'user'@'localhost' =
> OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new style password.
Thanks
For further clarification, what we are observing is that pull down lists
(which are already built on the GUI) take a long time to "complete"
processing. The processing we are performing upon user selection is
taking the selected element, updating 1 database column in 1 table with
the value, and th
Jeff McKeon wrote:
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Yes. That's why it's better to run it on a slave.
--
Keith Ivey <[EMAIL PROTECTED]>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
--
MySQL General Mailing List
F
Yep.
- Original Message -
From: "Jeff McKeon" <[EMAIL PROTECTED]>
To: "Jeremiah Gowdy" <[EMAIL PROTECTED]>;
Sent: Friday, June 03, 2005 12:11 PM
Subject: RE: mysqlhotcopy
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
---
Hi,
you can use a hint to force specific index usage :
http://lib.hutech.edu.vn/ebookonline/ebook1/0596003064/hpmysql-CHP-5-SECT-4.html
But this is not a good idea since data change and index selectivity can become
bad.
Also, if the index scan + the table scan is bigger than a full table scan, ev
Celona, Paul - AES wrote:
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In the lab with only a hub between the client and
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
> -Original Message-
> From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 03, 2005 2:24 PM
> To: Jeff McKeon; mysql@lists.mysql.com
> Subject: Re: mysqlhotcopy
>
>
I am having problems with MySQL inconsistently choosing the wrong index, or no
index at all, for queries on tables with 20 million rows. Would it be a good
idea for me to set max_seeks_for_key to 1 (or something less than 4 billion),
in order to force MySQL to use an index? We are using InnoDB
I run 24/7 applications also. Use mysqlhotcopy to do exactly what you're
doing by hand now. Run mysqlhotcopy on a slave server. It does exactly
what you think. Lock and flush the tables, tarball them, and unlock them.
No shutdown required.
- Original Message -
From: "Jeff McKeon"
Hello,
Anyone here run mysqlhotcopy? I've read the docs on it but they are
basicly just a howto and don't go too in depth. I've got a DB that is
the back end to a 24/7 application. I ususally do backups from a
replicated db by shutting down the Replicated DB then doing a tar are
all the db file
"Celona, Paul - AES" <[EMAIL PROTECTED]> wrote on 06/03/2005 01:03:18
PM:
> I am running mysql 4.0.18 on Windows 2003 server which also hosts my
> apache tomcat server. My applet makes a connection to the mysql database
> on the server as well as a socket connection to a service on the same
> ser
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In the lab with only a hub between the client and server, the
application perf
Hello.
This could be not exactly 4.0.21 issue, but issue of a compiler, say, if
you've built MySQL manually.
>
> Sure, can do - but is this a known issue with 4.0.21? I wasn't able to
> find anything in the bug tracker...
>
> TIA,
>
> --
> Andrew Hill
> Software Developer
> m3 M
try
REPAIR TABLE 'tablename'
Gleb Paharenko wrote:
>Hello.
>
>
>
>REPAIR TABLE ... USE_FRM helps in difficult cases. See:
>
> http://dev.mysql.com/doc/mysql/en/repair-table.html
>
>
>
>
>
>
>
>
>
>
>
>Per Jessen <[EMAIL PROTECTED]> wrote:
>
>
>
>>All,
>>
>>
>
>
>
>>I've got a table wit
[EMAIL PROTECTED] writes:
> You have a sort because you did an order by.
> If you had an index with the desired order by, it may be used.
> Try as you usage of covering indexes.
Hi Mathias,
Along with your suggestion, a little more thinking about the problem
and some experimenting seems to have
well - that was what I tried first - but that does not work because that
returns the latest date for which the task_id has a record as Assignment.
(It is like it picks up the max date from all records that have
name_rec_type as Assignment)
But I wanted was if the date corresponding to the name_
SQL My wrote:
(B
(B> Hi! dear all,
(B> I encountered a problem with designing SQL statement. For example, I
(B> want to query population information from a "city" table, and the
(B> records returned must be ordered according to the population of the
(B> city. Like this:
(B> +
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: 03 June 2005 12:29
> To: mysql@lists.mysql.com
> Subject: Re: Out of memory, mysqld got signal 6;
>
>
> Switch to the latest release 4.1.12 (or 4.0.24).
>
> It is strongly recommended to use official binaries
Hello.
> Regarding --default-ch aracter-set command in chapter 10 is written that a
>way to change settings is to recompile...
> Is there another less painful way to do this ?
You may specify default character sets using options when you start
mysqld. See:
http://dev.mysql.com/doc/mys
Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Per Jessen <[EMAIL PROTECTED]> wrote:
> All,
> I've got a table with about 25mill rows that was victim of a crash recently.
> (power-failure).
> I've been trying t
Hello.
Switch to the latest release 4.1.12 (or 4.0.24).
It is strongly recommended to use official binaries.
"Andrew Hill" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Over the last couple of days, a MySQL 4.0.21 server of ours has crashed
> a couple of times, with the error message list
Hello.
Most probably you should set the correct character sets. Search
on the list similar problems are often met there. See:
http://dev.mysql.com/doc/mysql/en/charset-defaults.html
What output does the following statement produce:
show variables like '%char%';
Send the output of:
Mark Sargent <[EMAIL PROTECTED]> wrote on 06/03/2005 03:04:23 AM:
> Hi All,
> I'm not sure the best design approach for a product table for a number
> of different hardware devices. Some devices have IP, Port, CPU, Memory
> specs, whilst some don't. Current desing is below.
> Products:
> product
Per Jessen wrote:
> I've got a backup of the table, but I'm not sure what sort of state
> it is in.
Correction - no backup is available. This table has got to be recoverable.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hi all,
Over the last couple of days, a MySQL 4.0.21 server of ours has crashed
a couple of times, with the error message listed below. It has
previously been running without problems since being installed (about
150 days so far).
I've not had much luck in tracking down what "signal 6" means - th
Hi there,
Question: I have a database with names that may contain accented
characters like é or è. My charset & collation are the defaults latin1
& latin1_swedish_ci.
In my browser all characters come out all right (both in phpMyAdmin and
in my application), but when I open a command consol
All,
I've got a table with about 25mill rows that was victim of a crash recently.
(power-failure).
I've been trying to recover it, but I'm not making much progress.
>From the most recent attempts:
myisamchk --safe-recover --force
- recovering (with keycache) MyISAM-table ''
Data records: 21622
Hi! dear all,
(BI encountered a problem with designing SQL statement. For example, I
(Bwant to query population information from a "city" table, and the
(Brecords returned must be ordered according to the population of the
(Bcity. Like this:
(B+---+-
I did more investigation and found out that
1) with MySQL 4.1.10-nt both queries executed from Query Browser work fine
(no error) - I haven't chance to test it with my application through ODBC
connection
2) when I set initial statement in MyODBC "SET CHARACTER SET 'cp1250'"
instead of "SET NAM
Reni Fournier wrote:
Thanks for the solution. It looks like it would work, but I don't have
MySQL 4.1 (which I believe is required for this to work, since this is
SUBSELECT, isn't it?).
Assuming I have to use two selects, which would you say is faster,
creating a temporary table in MySQL, or
Hi,
Thanks for your reply.
What do you mean by "right character set" ?
The default character set for ver. 4.1 is latin1, right ? This set should
support all western european languages !
Regarding --default-character-set command in chapter 10 is written that a way to
change settings is to recompi
Hi All,
I'm not sure the best design approach for a product table for a number
of different hardware devices. Some devices have IP, Port, CPU, Memory
specs, whilst some don't. Current desing is below.
Products:
product_id
product_name
maker_id
controller_id
product_type_id
product_model_numbe
39 matches
Mail list logo
