Not sure how the .sql backup file would have done that, but it seems to
be working now. I'll just step away slowly and carry on. Thanks for
the help!
On 10/25/2012 2:45 AM, Nitin Mehta wrote:
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is persisting is perhaps you have data directory outside the install
directory.
How you correct the problem:
Stop the service, start the service with option '--skip-grant-tables', login
with root u
Hi Victoria,
2003年 7月 2日 水曜日 22:05、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > Hi Victoria,
> >
> > I enclose a sample.
> >
> > http://www.mysql.com/doc/en/Resetting_permissions.html
> >
> > ...
> > 2. Restart mysqld with the --skip-grant-tables option.
> > ...
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> Hi Victoria,
>
> I enclose a sample.
>
> http://www.mysql.com/doc/en/Resetting_permissions.html
>
> ...
> 2. Restart mysqld with the --skip-grant-tables option.
> ...
>
> How would you understand this ?
>
> restarting mysqld or starting safe_mysqld
Hi Victoria,
I enclose a sample.
http://www.mysql.com/doc/en/Resetting_permissions.html
...
2. Restart mysqld with the --skip-grant-tables option.
...
How would you understand this ?
restarting mysqld or starting safe_mysqld ??
Don't get me wrong the manual is not bad, but it leaves a lot o
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
>
> I agree this section could be made a bit clearer.
>
> Is this hint big enough for MySQL AB ;-) ??
>
What exactly is not clear enough for you?
--skip-grant-tables is option of mysqld, not safe_mysqld.
safe_mysqld is the script that runs mysqld.
>
Hi Harsh, Hi MySQL AB ;-)
I agree this section could be made a bit clearer.
Is this hint big enough for MySQL AB ;-) ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:08、harsh さんは書きました:
> Well its not your fault,its actually confusing
> the documentation says run the mysqld comman
Well its not your fault,its actually confusing
the documentation says run the mysqld command
with the skip-grant-tables option but there is
no such command available (atleast in my
box) i found the command hidden in /usr/libexec/mysqld
but that 2 gives error.
safe_mysqld is indeed the command for
Hi harsh,
perhaps I made a litttle mistake (havent done it recently ). try the
--skip-grant-tables option for safe_mysqld like this
safe_mysqld --skip-grant-tables
That should be doing it.
Best regards
Nils Valentin
Tokyo/japan
2003年 7月 2日 水曜日 17:02、harsh さんは書きました:
> I m sorry ,try the ea
I m sorry ,try the earlier solution posted by someone else
i.e to restart mysql server with grant tables
disabled.and then reset the password.
that;s the only method given in the documentation
2 at mysql.com,though i cdn't get it working.
again sorry for misdirections
harsh
On Wed, 2 Jul 2003,
mysqladmin password secret
should work if not then mail i'll work
out a bit and reply.
--
harsh
http://www.cse.iitb.ac.in/~harsh
--
On Wed, 2
Hi there,
Restart the mysql server with option "--skip-grant-tables".
You can then login without password. And then you reset your password with
the update command like this:
UPDATE user SET password='' WHERE user='root';
Restart the server again.
Set a new password with mysqladmin like this
You can set password again using root
and mysqladmin command.try mysqladmin --help.
correct me if i m wrong
regards
--
harsh
http://www.cse.iitb.ac.in/~harsh
--
On Sunday 22 December 2002 06:29, William Bradley wrote:
> At the present time I am using Mandrake 9.0 and installed the MySql
> programmes that con the three disks:
>
> MySQL-3.23.52-1mdk.i586.rpm*
> MySQL-bench-3.23.52-1mdk.i586.rpm*
> MySQL-client-3.23.52-1mdk.i586.rpm*
> MySQL-Max-3.23.52-1mdk
ord security for a website?
>
>
>Randy
>- Original Message -
>From: "Daniel Kiss" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, August 29, 2002 12:19 AM
>Subject: Re: mysql password ( )
>
>
> > Hi,
> >
> &g
so md5 would be the securest way to handle password security for a website?
Randy
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 12:19 AM
Subject: Re: mysql password ( )
> Hi,
>
> Th
Hi,
The password() function is a "one way encoder". In other words it just
generates some kind of checksum of the input parameter.
So you cannot decrypt them, but it is much safer than encrypting and
decrypting strings, because even the attacker cannot decrypt them. :-)
You can use it this way
I dont know if it helps, but I dont decrypt, instead, I compare the crypted
value on the DB against the output of the function PASSWORD() filled with
the pwd I get from the user... It works for me (and I'm using APACHE and
MySQL all in plain "ANSI C"). Leonardo Javier Belén. AFIP-AR
- Original
Hi,
If I understood your message right, the answer is no. The only place
passwords are stored is the mysql database, so they're physically located
in the mysql.MYD file. They're encrypted there, too.
Iikka
**
* Iikka Meriläinen *
* E
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
>
> Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
> th
I think mysql uses the system crypt() function. This is, no-doubt, available
through some well hidden Java class. Just do "man crypt" to learn about
crypt().
Chris
On Tue, 29 Jan 2002 10:59:55 -0500
John Kemp <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I can't find a description of the algorithm
John Kemp writes:
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
>
> Can anyone tell me what algorithm PASSWORD uses? The rea
In the last episode (Jan 29), John Kemp said:
> Hi all,
>
> I can't find a description of the algorithm used in the mySQL PASSWROD
> function. I understand it's a hashing algorithm of some kind, but I
> don't know which algorithm (and I suspect it's *not* MD5.)
The algorithm is in the sql/pass
Are you sure the password for root is christ1 ?
Did you try it without the -p ?
Kory Wheatley wrote:
>I have MYSQL installed on a hpux 11.0 unix system
>I installed the binary and everything started up correctly
>using /opt/mysql/bin/safe_mysqld &
>
>but when I try to connect as an user
>/opt/m
Some other details that might be of interest in this case:
- it's not a good idea to type the password at the shell prompt
(it's then in the command history)
rather type
mysqladmin -u USERNAME -p
Mysql then asks you for a password with it's own prompt
the same is for mysql client.
- mysql
> Im attempting to install mysql. The service started and
> everything seems to
> be going ok except for that I can't set the root password for the mysql
> server.
>
> To reset password i type:
>
> /usr/bin/mysqladmin -u root -p mypassword
>
> Then I get the following error:
>
> /usr/bin/mysq
Hy,
Am 18 Dec 2001 10:50:40 -0800 schrieb Jeremiah Jester:
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
in the default installation at the first start there is no password set
for the mysql root user.
Not
try:
mysqladmin -u root password new_password_here
- Original Message -
From: "Jeremiah Jester" <[EMAIL PROTECTED]>
To: "'MySQL'" <[EMAIL PROTECTED]>
Sent: Tuesday, December 18, 2001 10:50 AM
Subject: mysql password
> Im attempting to install mysql. The service started and everything
victor writes:
> can mysql use the linux password /etc/passwd for the authentication
No, and it'd be a _really_ bad thing to do anyway.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned
On Thu, Sep 20, 2001 at 10:21:07AM +0800, victor wrote:
>
> can mysql use the linux password /etc/passwd for the authentication
No. Because it cannot guarantee that users are who they say they are.
If you think of authorization and authentication as two separate
problems, the reasons are a littl
30 matches
Mail list logo
