>> One more thing, I have already created these users and don't want to mess
>> their
>> passwords up or break their associated php scripts access.
>>
>> So how do I grant users, who already have a password, localhost
>> access?
>
> just copy the row in the mysql table
>
> --
> Sebastian Mend
This isn't really a problem with MySQL; MySQL just trips on it.
Let me caution you that this discussion applies to Windows. I did observe
this in my applications on Linux, but the problem will show itself only when
reading a file, whether uploaded or not; there will be no problem if the
data is en
Thanks Chris,
Well the script in question is a MySQL script to load a MySQL database.
Currently I use only PHP only for database retrieval.
But after trial and error I managed to find a 'work around', as follows:
a) CREATE TABLE tmp with ENGINE = MyISAM CHARSET = LATIN1;
b) LOAD DATA INFILE state
I have some php code I use to import data that is a bit more flexible
and robust than the load data statement in MySQL If you use php I can
share the code with you.
C.R.Vegelin wrote:
Hi Jerry,
Sorry, I should have mentioned that I use Windows XP with MySQL 5.0.15nt.
The script giving errors
Hi Jerry,
Sorry, I should have mentioned that I use Windows XP with MySQL 5.0.15nt.
The script giving errors now is used once a year, and last year without any
warning.
Since last year all I changed was adding in my.ini:
# in [client] part
default-character-set=utf8
# in [mysqld] part
default-c
On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley <[EMAIL PROTECTED]>
wrote:
> CK,
>
> > How can we manage the history of changed rows in the database.
> >
>
> Point-in-time architecture. For a bit of discussion see
> http://www.artfulsoftware.com/infotree/tip.php?id=547
>
> PB
I have used this con
> The ANSI-SQL syntax is to just use GRANT to create users. You will
> still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
>
> But I find the MySql syntax for creating user with CREATE USER and then
> GRANT easier to follow:
>
> CREATE USER joe@'%' IDENTIFIED BY 'whatev
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in the database thus:
sql = "select pic1 from products where id='" + str(id) + "';"
cursor.execute(sql)
pic1 = cursor.fetchall()[0][0].tostring()
# pic1 = cursor.fetch
Hi,
Has anyone got mysql master-slave replication setup on v4.1. Were you able
to get tables with auto_increment update properly to slave ?
If yes, please let me know. I need some advise on how to set it up to work
well. I get stuck at duplicate errors quite often, and those are not real
duplicate
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
<[EMAIL PROTECTED]> wrote:
> im new on the performance tuning of this database (MySQL 5.0.45,
> rpm-based installation), and i have one performance problem on our
> new installation:
...
> We are experiencing problems about the performance
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
-
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but
In the last episode (Apr 18), tech user said:
> My mysql table has been created for long time, it increases day by
> day, and become huge. Right now a full scan to the table for the
> first time is very slow. So I was thinking to optimize it. This table
> is stored in many non-sequential disk fragm
userId long
picture MeduimBlob
datePosted DateTime
A userId can have many pictures posted. I want to write a
query that returns a distinct userId along with the most
recent picture posted. Can someone suggest an elegant and
fast query to accomplish this?
Latest pic for user N:
SELECT userID,
On Friday 18 April 2008 10:26:16 Ananda Kumar wrote:
> can u please try this a root user
>
> mysql -uroot
>
> regards
> anandkl
>
Same result, unfortunately.
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does
can u please try this a root user
mysql -uroot
regards
anandkl
On 4/18/08, kabel <[EMAIL PROTECTED]> wrote:
>
> I'm attempting to create a MySQL stored procedure, however, when I attempt
> to
> create even a simple "Hello, world" procedure, I get the following error:
>
> ERROR 1307 (HY000): Fai
just comment this parameter, all actions done by mysql will be in
hostnam.err file
On 4/18/08, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi @all,
>
> ich have configured in /etc/my.cf as follow:
>
> [...]
> log="/var/log/mysqld.log"
> [...]
>
>
> A user in MySql is not just a username, but a username and a host.
>
> The host of '%' denotes all hosts accept 'localhost'.
>
> Therefore you usually require two entries for each user:
>
> CREATE USER ben@'%' INDENTIFIED BY 'ben';
> CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
>
> Does
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> would be much more easier if you would send this output here (with faked
> names, passwords and hosts ...)
OK...here it is:
SELECT * from mysql.
On Fri, Apr 18, 2008 at 7:06 PM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Check the error.log on both server and client, should show where connected
> and disconnected.
>
> Or write a small program to execute SHOW SLAVE STATUS every minute and log
> the results. Which I belive is done for you in
I'm attempting to create a MySQL stored procedure, however, when I attempt to
create even a simple "Hello, world" procedure, I get the following error:
ERROR 1307 (HY000): Failed to CREATE PROCEDURE test_procedure_k
which is listed as:
Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED)
Message: F
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Description" warnings
>when loading a tab separa
Check the error.log on both server and client, should show where
connected and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.
Ben
Kaushal Shriyan wrote:
Hi
Is there
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this help?
Ben
P
>-Original Message-
>From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 18, 2008 8:42 AM
>To: mysql@lists.mysql.com
>Subject: data truncation warnings by special characters
>
>Hi List,
>
>I get strange "Data truncated for column Description" warnings
>when loading a tab separa
> Hi
> Is there a way to find out when the MySQL Slave has been restarted.
> Thanks and Regards
> Kaushal
You can determine the server actions by looking through the slave log
file.
David
Pam Astor schrieb:
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
[...]
The seventh line shows th
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any othe
I`ve resolved my problems without hardware manipulation.
Thanks to all.
-Mensaje original-
De: Francisco Rodrigo Cortinas Maseda
Enviado el: miércoles 16 de abril de 2008 18:57
Para: mysql@lists.mysql.com
Asunto: RV: Performance problem
Hi all,
im new on the performance tuning of thi
> connectiong from shell means connecting as localhost by default, connecting
> from PHP can be some different server and/or PHP uses the full IP
> address/hostname of the server
>
> check/compare the privileges for your users for 'localhost' and '%'
I ran “SELECT * from mysql.user;” the com
Hi List,
I get strange "Data truncated for column Description" warnings
when loading a tab separated file with special characters.
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyISAM CHARSET=
Hi
Is there a way to find out when the MySQL Slave has been restarted.
Thanks and Regards
Kaushal
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi @all,
ich have configured in /etc/my.cf as follow:
[...]
log="/var/log/mysqld.log"
[...]
Now, mysqld writes every query to the log file. How can I avoid the
queries in the log file? I want to see any action done by mysql, but not
the queries.
T
No problem.
I do this using three triggers on Insert, Update and Delete. Then
update a log file who's schema starts:
CREATE TABLE ?_log (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
transact ENUM ('I','U','D') NOT NULL,
key_from_table ??? NOT NULL,
KEY (key_from_table),
field_1 ?? ,
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any other idea?
Thank
35 matches
Mail list logo
