mysql -utim
Then
mysql> SELECT USER(),CURRENT_USER();
Login as root and:
delete from mysql.user where user='';
And try again with tim with password.
Thanks
Claudio
On Oct 19, 2011 7:47 AM, "Johan De Meersman" wrote:
> Try not passing the password and typing it at the prompt. If that works,
>
Hi,
I asked this question over on stackoverflow - basically I have a query
and when using EXPLAIN I see that around 2400 rows are still being
scanned. I'd added various indexes but it cannot make it perform any
better.
I would appreciate if anyone has any further ideas?
http://stackoverflow.com/
Try not passing the password and typing it at the prompt. If that works,
there's a problem in the parameter parsing.
Random thought: could you have a .my.cnf file in your home directory?
- Original Message -
> From: "Johnny Withers"
> To: "Tim Johnson"
> Cc: mysql@lists.mysql.com
> Sen
- Original Message -
> From: "Ryan Mark"
>
> (WordPress does not like to share an app server) and added memcache.
Really? We run dozens of the thing on a couple of virtuals with no problems at
all. Then again, we don't exactly get millions of hits on most of them, so if
you do get a lo
Why does mysql say "using password: no"? Seems to me the password is not
being sent.
On Oct 18, 2011 8:37 PM, "Tim Johnson" wrote:
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this ...
linus:~ tim$ sudo mysql
Pas
* Tim Johnson [111018 17:47]:
Got this...
mysql> select host,user,password from user;
+-+--+---+
| host| user | password |
+-+--+---+
| localho
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this problem comes when you have the anonymous user in the grant
> tables (''),
> MySQL has a tricky way of processing the grant tables.
>
> Sometimes you can be surprise
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually this problem comes when you have the anonymous user in the grant
tables (''),
MySQL has a tricky way of processing the grant tables.
Sometimes you can be surprised by what you read issuing:
SELECT USER(),CURREN
Thanks guys!
I figured there would be no clearcut answer. I was curious if there were any
nuggets of wisdom or rules of thumb I was overlooking.
We initially launched sharing db servers, but had performance trouble. We've
since tracked down problems in our app server config (WordPress does not
* Reindl Harald [111018 15:14]:
>
>
> Am 19.10.2011 01:03, schrieb Tim Johnson:
> > Now when I try to log in with host as localhost, user as tim
> > with 'secret' password:
> > linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> > ERROR 1045 (28000): Access denied for user 'tim'@'
* Mark [111018 15:14]:
> Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
Not originally, but I repeated the grant then
issued
flush privileges;
quit
and have the same problem
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebs
Am 19.10.2011 01:03, schrieb Tim Johnson:
> Now when I try to log in with host as localhost, user as tim
> with 'secret' password:
> linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password:
> NO)
> Huh!
did
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
- Mark
-Original Message-
From: Tim Johnson [mailto:t...@akwebsoft.com]
Sent: woensdag 19 oktober 2011 1:02
To: MySQL ML
Subject: mysql server does not recognize user password
using 5.1.57 on Mac Lion.
I've done t
using 5.1.57 on Mac Lion.
I've done this a dozen times, but I've missed something.
Am setting up a new mysql installation ...
I have granted a user as follows (between lines of asterisks)
linus:~ tim$ sudo mysql
Password:
Welcome to the
You have answered your own question, good sir. Or so I have come to believe.
Is your primary concern $? Is your organization focused on the bottom line?
Option B allows you to move in the costsaving direction. I imagine some may
object to sharing resources between (potentially exploitable) WordPres
Architecture question I'm having trouble finding an answer to:
I run four WordPress websites. I have mysql setup in a write master/read
replica slave configuration on Amazon. There is one master that all the
WordPress instances write to. I'm trying to figure out how to setup the read
replicas.
As Johan describes, replication is the way. If that's not an option due to
connectivity between the hosts you could arrange for a logical dump to be
copied and restored. I would certainly opt for replication in your
situation.
A
On Tue, Oct 18, 2011 at 7:02 AM, Johan De Meersman wrote:
>
Hello everyone, I would like to ask for idea and help on how to achieve my
concern. Below is my SQL statement. Im joining 2 tables to get my results.
Here's the sample results of what im getting.
Name | Desc | Issue | ATime | Back | TotalTime | Ack | Res
123 | test | error | 2011-10-18 17:09:26
18 matches
Mail list logo
