Change password statements should show up in the binary logs, too, in some
form or other.
On Thu, Dec 16, 2010 at 9:58 PM, Alejandro Bednarik alejand...@olx.comwrote:
SQL injection? Check Apache or whatever log files.
On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote:
I
I recieved a call from a client saying the web site did not work, turns out
the database password was reset, and not by me. In looking in the DB after
the PW was reset, I could find nothing out of place, although frankly I was
not sure what to look for.
Is this indicitive of an attack? Is
SQL injection? Check Apache or whatever log files.
On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote:
I recieved a call from a client saying the web site did not work, turns out
the database password was reset, and not by me. In looking in the DB after
the PW was reset, I
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
It is important to understand deeply mysql client access control.
Basically you need only one root account from the localhost for
administration purposes.
Keep in mind that when you login specifying 'localhost' (either by the
-h flag or implicit) MySQL will use the mysql client socket
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni claudio.na...@gmail.com wrote:
I don't know if you are now more ore less confused!
Claudio
I would say less because you basically explained that I need to have
localhost 127.0.0.1.
Now my problem is that no longer have this and would like to know
Exactly, you need as many rows as many combination user/host
we can also say that an account in MySQL is not the username BUT the
username AND host combination.
If you want to duplicate any account (also the root/localhost) do this:
mysql show grants for 'root'@'localhost';
then have fun!
I noticed today that I strangely was unable to login to MySQL as root.
I just assumed I forgot the password and decided to reset my root
password:
1 - /etc/init.d/mysqld stop
2 - mysqld_safe --skip-grant-tables
3 - mysql -u root
4 - mysql use mysql;
mysql mysql update user set
Hi Carlos
Try this
mysql update user set password=password('letmein') where user='root';
This way the password is saved encrypted, thats the way is compared when
you try to log in.
Carlos
On 5/14/2009 5:28 PM, Carlos Williams wrote:
I noticed today that I strangely was unable to login
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal carlos.pr...@gmail.com wrote:
Hi Carlos
Try this
mysql update user set password=password('letmein') where user='root';
This way the password is saved encrypted, thats the way is compared when you
try to log in.
Thanks for the reply! I
Check how many root rows do you have on the user table (select * from
user where user='root';), some times there are several rows with
different grants and probably you are going through and invalid rule.
Carlos
On 5/14/2009 5:39 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at 6:31 PM,
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal carlos.pr...@gmail.com wrote:
Check how many root rows do you have on the user table (select * from user
where user='root';), some times there are several rows with different grants
and probably you are going through and invalid rule.
I checked
try running the command like this
select * from user where user='root' \G
Capital G is a must.
thanks Doug
Carlos Williams wrote:
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal carlos.pr...@gmail.com wrote:
Check how many root rows do you have on the user table (select * from user
where
The machine mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first row
(delete from user where user='root' and host='mysql.unixslut.com';)
Carlos
On 5/14/2009 5:55 PM, Carlos Williams wrote:
On Thu, May 14, 2009
Carlos Proal wrote:
The machine mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first
row (delete from user where user='root' and host='mysql.unixslut.com';)
Carlos
On 5/14/2009 5:55 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at 7:06 PM, Carlos Proal carlos.pr...@gmail.com wrote:
The machine mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first row
(delete from user where user='root' and host='mysql.unixslut.com';)
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson douglas.nel...@sun.com wrote:
try running the command like this
select * from user where user='root' \G
Capital G is a must.
I did the following:
[r...@mysql ~]# /etc/init.d/mysqld stop
Stopping MySQL:
I just installed mysql under my new linux system.
I did a test command of
./mysqladmin -u root password new-password
thus setting the root users password to new-password
this appeared to work.
I now want to change the root users password now that I have the syntax
correct.
I do a
PROTECTED]]
Sent: 07 January 2002 12:59
To: [EMAIL PROTECTED]
Subject: Password reset.
I just installed mysql under my new linux system.
I did a test command of
./mysqladmin -u root password new-password
thus setting the root users password to new-password
this appeared to work.
I now want
19 matches
Mail list logo