On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
> login as root and remove 'empty' user ,issue:
>
> delete from mysql.user where user='';
> flush privileges;
>
> mysql authentication system is logging you on as 'empty' user.
>
> you will be ok after that ;)
>
Man, thanks a ton! That wa
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
> after login to mysql issue:
>
> select user();
> and
> select current_user();
> and post output
> you will see they dont match.
>
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
Enter password:
Welcome to the MySQL monitor. Command
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
> Another thing I just noticed
>
> In your first example you are using localhost, which probably means you are
> connecting via network
>
> The second option you don't define a host, which means you're prolly using
> socket connection
Oh, whoo
On Saturday 31 July 2010 4:30:00 chaim rieger wrote:
> Just a stab but what's the max connect set to ?
>
Thanks a ton for the quick response - I'm at wits end, been working on
this for hours!
max_connections is set to 0.
(but it is also set to 0 on another server, which largely follows the
same
Hello - I'm only moderately familiar with mysql; the following issue has me
stumped.
I just noticed that some scripts on one of my client's servers suddenly
started failing due to being no longer able to log into the mysql db.
I have not touched the mysql config on that machine in months.
The
On Fri, 2008-11-14 at 14:30 +, Mark Goodge wrote:
> I wouldn't try to arbitrarily normalise the database for SQL
> efficiency.
> In a real-life situation, it's more important that the database
> design
> reflects your actual workflow and business requirements. Having a
> field
> that's empty
On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
> You can use the convert_tz function for this
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
> _convert-tz
>
> On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > Can we make adjus
On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I have a table of a 1 million users. I want to add a flag called
> > delete if a user wants to delete his account. Note that this situation
> > does not happe
On Thu, 2008-09-18 at 09:58 +0100, Stut wrote:
> Autonumber will accomplish that, so long as you don't delete any.
> And
> if you do, renumbering the bookings would cause more problems than
> it
> solved.
>
Autonumber has the possibility of gaps. When a record is insert, the
counter is incre
On Thu, 2008-09-18 at 08:34 +1000, Res wrote:
> Hi Peter,
>
> On Wed, 17 Sep 2008, Peter Brawley wrote:
>
> >> I'm looking at using the "@" symbol
> >
> > Don't. Restrict yourself to alphanums and '_'.
>
> Thanks, but is there any technical reason where using "@" might break
> something? Howeve
On Wed, 2008-09-17 at 23:29 +0100, Stut wrote:
> On 17 Sep 2008, at 22:34, Jerry Schwartz wrote:
> > Our Japanese partners will notice and will ask. Similar things have
> > come up
> > before.
> >
> > I want to be pro-active.
>
> Notice what? Why would it be bad? What type of data are we dealing
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote:
> Hey all,
>
> What is the most effective way to block HTML code
> in insert statements?
>
> I have a client with a comments form that is being
> bombarded with people inserting references to
> their own sites, etc, and I need an effective w
On Thu, 2008-07-31 at 11:47 -0500, Chris W wrote:
> My thought is you should develop an application that will give your
> users the information they need with out direct access to the DB. My
> thought is, if a user doesn't have a solid understanding of at least 1st
> and 2nd normal form, and ba
On Thu, 2008-07-31 at 11:24 -0400, Perrin Harkins wrote:
> On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz
> <[EMAIL PROTECTED]> wrote:
> > Other than the fact that an ENUM can have many more values than a SET, is
> > there any particular reason to choose one over the other?
>
> The only use for E
On Thu, 2008-07-31 at 10:24 -0400, Jerry Schwartz wrote:
> [JS] Users will have read-only access through MS Access, and have to filter
> on various fields.
You're assuming that your users will never, ever be granted anything but
read-access to only the data they suppose to have, either by accident
On Thu, 2008-07-31 at 09:56 -0400, Jerry Schwartz wrote:
> [JS] I added a dozen or so columns for a special purpose, and although MySQL
> doesn't care I wanted them in a certain order that would be intuitive to a
> user / programmer.
Why is a user looking at your database?
This is a security bre
On Wed, 2008-07-30 at 14:42 -0400, Jerry Schwartz wrote:
> Is there any reasonable way of re-arranging the order of columns in a table
> without losing their data? The best I could come up with was to copy the
> table, empty it, and then do an INSERT . SELECT specifying the new order of
> the field
On Mon, 2008-07-28 at 07:32 -0400, Gary Josack wrote:
> Andrew Martin wrote:
> > Hello,
> >
> > Is it permissible to order a clause such that the search term is the
> > first item (in the clause)?
> >
> > standard:
> > field1 IN (123, 654, 789)
> >
> > in question:
> > 123 IN (field1, field2, field
Why? Because it's Friday and I'm feeling silly :)
mysql> SELECT * FROM sales;
+--+---++
| company | state | sales |
+--+---++
| ABC | AZ| 140.01 |
| XYZ | AZ| 17.76 |
| ABC | NY| 123.45 |
| XYZ
On Thu, 2008-07-24 at 14:49 +0200, walter harms wrote:
> hi list,
> i have tables that look like this( <10.000 entries) :
>
> id,
> timestamp,
> value
>
>
> to get the latest value for each id i have queries like:
>
> select * from tab A where timestamp = (select max(timestamp) from tab B where
On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote:
> Hi all,
>
> How do I get the file names from a certain directory in SQL?
SQL is designed to deal with RDBs, not the rest of the computer system.
I suggest you switch to a modern language such as Perl, Python, Ruby, or
even PHP. Each has a g
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
> How can we normalize the tables? could you explain bit more?
>
>
> Thanks,
> Siva
>
>
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 milli
On Wed, 2008-07-23 at 12:10 -0400, [EMAIL PROTECTED] wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+-
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
> Hi all,
>
> I have a problem as below:
>
> A text field -Lets call it 'field1'- contains datas seperated by
> commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
> my lines like these:
>
> id title filed1
> -
You could pu tmany records in a file and use
mysql -u user -p http://www.mysql.com/doc/en/LOAD_DATA.html
-Corey Tisdale
The Grill Store & More
--- "Alexander Burbello" <[EMAIL PROTECTED]> wrote:
>Hi,
>
>How can I insert many records (for instance: 1.00
Jon,
This is exactly what was needed. You are correct in that we're using the
mysql
To: "Gerald Clark" <[EMAIL PROTECTED]>; "Corey Wallis"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 8:16 AM
Subject: RE: Fw: Complex S
it.
For reasons too complex to go into at this stage using anything except SQL
is not possible.
Any and all suggestions welcome.
-Corey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
Thank You,
Corey Baldwin
---
I'm wondering what is the best way to update one table based on another. Can joins be
performed for an update?
update table1 set table1.field2 = table2.field2 where table1.field1 = table2.field1;
The alternative seams to be:
select table2.field2 from table2;
update table2 set table2.field2 = $
;
Thanks for the help!
PS Though my searching i still have not found anything on IF statements in SQL... i'm
sure there is some, i just can't find any examples. Anyone give me one or two?
>>> Sinisa Milivojevic <[EMAIL PROTECTED]> 12/01/01 11:02am >>>
>Corey K
Looking though the docs. MySQL does not support nested selects but i'm looking for a
way to speed up my PHP.
This is what i have:
CREATE TABLE departmentuser (
userid int(10) unsigned zerofill default NULL,
departmentid int(10) unsigned zerofill default NULL,
KEY userid_departmentid(useri
Can you rename a database? If so, how does it handle all the tables inside it?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I'm writing a web application for a client in PHP. One function that a user can
perform results in a very expensive update. To try and speed up this process (free up
the user) i wrote a Perl script that performs the bulk of the work. When the user
runs the PHP page, the PHP page updates one
33 matches
Mail list logo
