Am 31.07.2015 um 16:23 schrieb Martin Mueller:
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical st
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical stuff, but you're short on patience, and it would hel
Am 31.07.2015 um 15:40 schrieb shawn l.green:
1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).
Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the dat
On 7/31/2015 8:40 AM, Martin Mueller wrote:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix user
Am 31.07.2015 um 14:40 schrieb Martin Mueller:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix us
Am 31.07.2015 um 14:45 schrieb Martin Mueller:
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
I don't understand the sentence about the data directory path mention. The
my.cnf file is at /etc/m
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
I don't understand the sentence about the data directory path mention. The
my.cnf file is at /etc/my.cnf . It doesn't have any data directory path
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mys
Data directory path mention in cnf is of old mysql.
Make a fresh data directory, configure it in configuration file and execute
mysqlinstall_db,
On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller <
martinmuel...@northwestern.edu> wrote:
> I have installed mysql 5.1.73 on an old Mac Pro running OS L
first: don't reply off-list, a answer on a mailing-list is no invitation
for private support!
Am 31.07.2015 um 02:34 schrieb Martin Mueller:
I read that section but was stopped in my tracks by
"Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql)"
Becaus
Am 31.07.2015 um 01:41 schrieb Martin Mueller:
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot
run the mysql command because it challenges me for a password. But I did
not set any password, either for the root, for mysql, or for myself as a
user.
So the installation ha
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 wrote:
> SQL injection? Check Apache or whatever log files.
>
> On Thu, Dec 16, 2010 at 4:17 PM, Gary wrote:
>
> > I recieved a call from a client saying
SQL injection? Check Apache or whatever log files.
On Thu, Dec 16, 2010 at 4:17 PM, Gary 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 could find nothing out
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!
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni 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 what
I can do to re
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 interface
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
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson 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:[ OK ]
[r...@
On Thu, May 14, 2009 at 7:06 PM, 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,
Yes, my mach
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
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
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 wrote:
Check how many root rows do you have on the user table (select * from user
where user='root';), some ti
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal 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 and when I ran the co
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, C
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal 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 followed both met
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
Hi,
On 3/5/08 5:58 AM, "Thufir" <[EMAIL PROTECTED]> wrote:
> On Tue, 04 Mar 2008 08:44:47 -0500, Dan Rogart wrote:
>
>> You can have a file called .my.cnf in your home directory that stores
>> it.
>
>
> Ah, thanks. I don't have a .my.cnf file in my home directory, but I do
> have something i
On Tue, 04 Mar 2008 08:44:47 -0500, Dan Rogart wrote:
> You can have a file called .my.cnf in your home directory that stores
> it.
Ah, thanks. I don't have a .my.cnf file in my home directory, but I do
have something in /etc which seems to be what I'm after. I can get it
working for logging
You can have a file called .my.cnf in your home directory that stores it.
This page outlines it pretty well:
http://www.modwest.com/help/kb6-242.html
In your case, you would just want to use the password = 'foo' part of it.
-Dan
On 3/4/08 4:10 AM, "Thufir" <[EMAIL PROTECTED]> wrote:
> I unde
If you can't access functions directly, you could implement a trigger
on that row to intercept the password as it being written and do your
MD5 encoding there.
- michael
On 8/18/07, C K <[EMAIL PROTECTED]> wrote:
> Thanks to all,
> but the problem is that I am using external programs to insert
On 8/18/07, C K <[EMAIL PROTECTED]> wrote:
> Friends,
> I have one question - How to store passwords in MySQL database table in a
> secure way so that no one can see the password(understand the password
> string)?
It is considered bad security practice to store passwords using reversible
encrypt
Hi,
What are those external programs? If you are using a scripting language
like PHP to insert data, you can still use all the MySQL functions in
your query statements. I'm not sure how this is related to MS Access 2003.
With Warm Regards,
Sudheer. S
www.binaryvibes.co.in
www.lampcomputing.co
On Sat, August 18, 2007 20:17, Mike Aubury wrote:
> But you can use it for passwords (ask Unix)...
>
> You can't decode what the original password was, but you can encode the
> password they typed in and check the two hashes match - if they do - the
> chances are that the original passwords match
But you can use it for passwords (ask Unix)...
You can't decode what the original password was, but you can encode the
password they typed in and check the two hashes match - if they do - the
chances are that the original passwords match (the odds against are huge!)
On Saturday 18 August 200
On Sat, August 18, 2007 15:53, C K wrote:
> Thanks to all,
> but the problem is that I am using external programs to insert data and I
> can't use MySQL functions directly. Can I call/implement such type of
> functions using MS Access 2003?
MD5() is not an encryption function. The MySQL manual st
Thanks to all,
but the problem is that I am using external programs to insert data and I
can't use MySQL functions directly. Can I call/implement such type of
functions using MS Access 2003?
Thanks
CPK
>
>
> The md5 function encrypts the input string.
>
> -
> With Warm Regards,
> Sudheer.
C K wrote:
Friends,
I have one question - How to store passwords in MySQL database table in a
secure way so that no one can see the password(understand the password
string)?
Please help
Thanks
CPK
mysql> create table test01 (pass varchar(32));
Query OK, 0 rows affected (0.00 sec)
mysql> ins
Use MD5 function to encrypt the password column
C K wrote:
Friends,
I have one question - How to store passwords in MySQL database table in a
secure way so that no one can see the password(understand the password
string)?
Please help
Thanks
CPK
--
Yoge,
AdventNet, Inc.
925-965-6528
[EMAIL
At 12:11 AM 2/11/2007, you wrote:
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
Suhas,
You are correct. If the person has physical access to the MyS
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
On 2/10/07, mos <[EMAIL PROTECTED]> wrote:
At 10:49 PM 2/10/2007, Suhas Pharkute wrote:
>Hi,
>
>I am sure this
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
On 2/10/07, mos <[EMAIL PROTECTED]> wrote:
At 10:49 PM 2/10/2007, Suhas Pharkute wrote:
>Hi,
>
>I am sure this
At 10:49 PM 2/10/2007, Suhas Pharkute wrote:
Hi,
I am sure this is been asked many times before, but seems like I could not
find answer to it so here you go,
Is there any way to put password on Data base(files) itself rather than DB
server?
See the Grant command to set up users where you can
Try this: GRANT USAGE ON *.* TO 'openpne'@'locahost' IDENTIFIED BY
'openpne' ;
Or try this:
create user 'openpne'@'localhost' identified by
password 'openpne';
- Spell domain correctly - there was a typo
- put quote around userid and domain
-Original Message-
From:
[EMAIL PROTECTED] ("Padmanabhan G") wrote in
news:[EMAIL PROTECTED]:
> mysql> create user [EMAIL PROTECTED] identified by password 'openpne';
>
> Error 1372: Password hash should be a 41-digit hexadecimal number
mysql> create user [EMAIL PROTECTED] identified by 'openpne';
--
felix
--
MySQ
Dan,
A thousand times thanks for the fast reply, I just reset my password
with MySQL Administrator now, everything is back the way it was!
On a sidenote: I also saw this as the version "MySQL 5.0.17-max via
socket". The version 3 was through phpinfo(). My php install and
other MySQL do al
Kevin -
You can start up the MySQL server without password protection using the
--skip-grant-tables option. Note that will leave your server wide open,
so you may also want to use the --skip-networking option and access it
through the socket on the same machine.
Something like this I think:
At 02:57 PM 4/10/2006, Kosala Atapattu wrote:
Hi people,
I have a small problem. I forgot the password for user root in my
personal MySQL instance. I'm a Linux user and running Debian Sarge on my
computer. I have few other DBs which I created and which I have access
to (still I remember the pass
Hi
Restart mysqld with the --skip-grant-tables option
More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
--Praj
On Mon, 10 Apr 2006 12:57:32 +0600
"Kosala Atapattu" <[EMAIL PROTECTED]> wrote:
> Hi people,
>
> I have a small problem. I forgot the password for user r
On 4/5/06, NiCK Song <[EMAIL PROTECTED]> wrote:
> Hi, experts
>
> How can I make mysql database users password with expire date?
> Does mysql can do it?
>
> --
> NiCK
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[
"NiCK Song" <[EMAIL PROTECTED]> wrote on 04/04/2006 11:05:57 PM:
> Hi, experts
>
> How can I make mysql database users password with expire date?
> Does mysql can do it?
>
> --
> NiCK
>
Sorry!! MySQL does not auto-expire any user accounts. You will need to
script something to do that manuall
NiCK Song wrote:
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
Set a DATE field with the time of expire.
Then do something like
SELECT * FROM users WHERE datefield_of_insert > CURDATE();
HTH
Barry
--
Smileys rule (cX.x)C --o
Ok, I logged on to the GUI Administrator as:
root
localhost
/var/lib/mysql/mysql.sock
from my linux user account. Tad confusing, as to which "root" is being
referred to. If I, for instance, restart they system I'll need to
manually restart the database? Or, if for some other reason the data
Got it started:
[EMAIL PROTECTED] ~]# service mysqld start
Initializing MySQL database: Installing all prepared tables
Fill help tables
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '' at line
On 18/08/2005, Martin Schwarz wrote:
> When using
> 'update TABLE set FIELD=PASSWORD('foo');'
> the query
> 'select * from TABLE where FIELD=PASSWORD('foo');'
> delivers an empty set.
>
> Same with the SHA1 or MD5 functions.
What is the data type of your FIELD column?
--
felix
--
MySQL Gener
On Fri, May 20, 2005 at 09:28:40AM -, [EMAIL PROTECTED] wrote:
> Hint: Did you specify a password for the login ?
I suspect the original poster was saying that he doesn't
remember setting a password, so he doesn't know what password to
enter.
-Jason Martin
--
Unrecoverable Application ERROR -
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
>Hello all,
> I'm having a bit of trouble:.
> Welcome to phpMyAdmin 2.5.0-rc1
>
>
> Error
>
> MySQL said:
>
>
> Access denied for user: '[E
Hi Stone,
no offense, but that one you should really be able to answer yourself
> Hello all,
> I'm having a bit of trouble:.
> Welcome to phpMyAdmin 2.5.0-rc1
>
>
> Error
>
> MySQL said:
>
>
> Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
>
>
> how can I find my password?
Lo
On Mon, Dec 06, 2004 at 04:21:38PM -0600, [EMAIL PROTECTED] wrote:
> does anyone know what type of encryption is used in the PASSWORD(str)
> function? When would you use the MD5 vs the PASSWORD function?
>
> We have a campus standard to use the MD5 encryption so I need to confirm
> if the PASSWOR
No, it is not true.
After repeated failed connection attempts from a host that host will be blocked until
a flush hosts command is executed. The number allowed before this blocking is
specified by the variable max_connect_errors.
See http://dev.mysql.com/doc/mysql/en/Blocked_host.html
John
_
At 11:41 -0400 10/11/04, Jerry Swanson wrote:
I create table and used password
// CHAR(15)
select password('123456');
++
| password('123456') |
++
| 565491d704013245 |
++
//INT(10)
+-+
| password|
+--
Alek,
Create a file of any name, e.g. script.cnf.
Put the following in it,
[client]
user = dba
password = dba_pass
Run mysql with the --defaults-file arg
mysql --defaults-file=script.cnf
So long as the cnf file is only readable by the the cronjob owne
You can try using the old-passwords option in the my.cnf file or you can try
building your ODBC driver from the bitkeeper source. I would check the
documentation to verify that the ODBC build you have supports the 4.1.+
servers.
-Original Message-
From: Arthur Maloney
To: [EMAIL PROTECTED
Thanks all, it helped me a lot
Manisha
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16,
t;
Sent: Thursday, October 16, 2003 16:13
Subject: Re: PASSWORD() function problem
> all encryption functions are one way only
>
> Nitin
>
> - Original Message -
> From: "Manisha Sathe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> thanks all, it works (i just increase it to 20)
Please, don't use PASSWORD() function in your own application, use MD5() or SHA1()
instead.
> but one more thing, now if i want to get this password (e.g for option
> forget password), can we retrieve, i
-
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 15:16
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase it to 20)
> but one more thing, now if i want to get this password (e.g
all encryption functions are one way only
Nitin
- Original Message -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase
: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 11:05 PM
Subject: Re: PASSWORD() function problem
> At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> >Hi,
> >
> >I inserted one record thr PHPMyAdmin - mem_pass f
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass
= PASSWORD('xyz') - then it is not getting selected
I do not know w
On Wed, 15 Oct 2003 17:26:23 +0800
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
> using function 'PASSWORD'
>
> Then trying to select the same - select * from member where mem_pass =
> PASSWORD('xyz') - t
Gantier <[EMAIL PROTECTED]> wrote:
> Is it possible to load from the database a field entry with
> password(XXX) and see it not crypted, as if we 've made a
> unpassword(XXX) action ?
Nope. This encryption is non-reversible.
--
For technical support contracts, goto https://order.mysql.com/?ref=
On Friday 04 April 2003 04:02, you wrote:
> The logon now works after "DELETE FROM user WHERE user=""
>
> It's still crashing when a remote logon is attempted. The copy of the
> modified my.cnf file is attached.
What exactly OS do you use? What version of MySQL server do you use? Did oyu
install
On Wednesday 02 April 2003 17:19, Eldon Ziegler wrote:
> The contents of the user file are attached. The user name is testit and
> there is no password. This is server version 3.23.52, the version that came
> with the Red Hat 8 distribution.
>
> I entered mysql -utestit then USE mysql; and got
> ER
--Original Message-
From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 3:56 AM
To: Michael Shulman
Subject: RE: password not working from command line
Michael,
The result of a SELECT * INTO OUTFILE FROM user is attached.
Thanks
Eldon
At 02:53 pm 4/1/2003 -0800, you wr
Michael Shulman wrote,
> Privilege changes (at least on Windows) don't seem to take effect until
> either (a) the server is restarted, or (b) the server is instructed to
> re-read its permissions tables.
Fair enough. I did FLUSH PRIVILEGES whenever I changed the user table. It
seemed to me that t
The contents of the user file are attached. The user name is testit and
there is no password. This is server version 3.23.52, the version that came
with the Red Hat 8 distribution.
I entered mysql -utestit then USE mysql; and got
ERROR 1044: Access denied for user: '@local host' to database 'mys
manipulate users or permissions.
-ms
-Original Message-
From: Helge Moulding [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: password not working from command line
Andy Eastham wrote:
> Make sure you don't ente
Andy Eastham wrote:
> Make sure you don't enter a space between -u and the username
> and -p and the password ie mysql -uuser -ppassword
Actually, that works for me, i.e.
C:\Program Files\mysql40\bin>mysql -u root -p
Enter password: *
Welcome to the MySQL monitor. Commands end with ; or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eldon, et al --
...and then Michael Shulman said...
%
% Or, you can use the alternate, more legible syntax:
%
% mysql --user=username --password=pass
Or, better yet, you can use
mysql -uusername -p [database]
or
mysql -user=username -p [dat
Or, you can use the alternate, more legible syntax:
mysql --user=username --password=pass
-ms
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 10:36 AM
To: [EMAIL PROTECTED] Mysql. Com
Subject: RE: password not working from command line
Eldon,
Make sure you don't enter a space between -u and the username and -p and the
password
ie mysql -uuser -ppassword
Andy
> -Original Message-
> From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
> Sent: 01 April 2003 16:15
> To: [EMAIL PROTECTED]
> Subject: password not working from comm
Nasser wrote:
>it looks as though you have created the newsletter user with plain text
password. mysql will >>>
>compare the user password against the encrypted password and will fail.
Look at the password entry in the results below starting with 61fa
If the password had been stored as plain
When connecting from a command line, mysql uses 3 of the columns in the user
table to decide whether or not to grant access. These are host, user, and
password. Note that in your results below, there is no
localhost-newsletter-testPass combination. What the table shows is that
clients from any h
GRANT ALL PRIVILEGES ON newsletter.* TO 'newsletter'@'localhost' IDENTIFIED BY 'testPass';
Neil Aggarwal wrote:
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsletter;
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
FLUSH PR
Neil,
> GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY
'testPass';
> FLUSH PRIVILEGES;
> I then tried to access the databse via the command-line client:
> /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter
> And I get this error:
> ERROR 1045: Access denied for user:
On Wed, 15 Jan 2003 11:00:21 -0600, Neil Aggarwal wrote:
>Hello:
>
>As the root user, I created a new database and user account:
>CREATE DATABASE newsletter;
>GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass';
>FLUSH PRIVILEGES;
>
>I then tried to access the databse via t
Jeremy Zawodny wrote:
On Mon, Dec 23, 2002 at 03:53:14PM -0700, Mark Stringham wrote:
I know the MySQL password( ) function is irreversible. I have also
been told that storing passwords in plain text is a bad idea. Can a
get a few suggestions of good ways to store passwords in the db?
Using M
On Mon, Dec 23, 2002 at 03:53:14PM -0700, Mark Stringham wrote:
>
> I know the MySQL password( ) function is irreversible. I have also
> been told that storing passwords in plain text is a bad idea. Can a
> get a few suggestions of good ways to store passwords in the db?
Using MD5() is one of my f
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD() as
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> with the latest 4.1 tree (from today) the PASSWORD() function returns random
>alpha-numeric text /[a-f0-9]/
> 45 characters in length (which is too long for a password string)
Dear Bjoern,
> I have completed a new setup on WinXP, with Mysqld-nt as a service, and
> assigned a new password to root. However I am able to connect as root
> without password, alter and even drop tables and complete databases with
> the tool MySQLFront !!!
After setting up MySQL under Windows,
I tried the first suggestion and it signed in fine.
After emptying the cookies in Netscape and then quitting. I tried to
connect to http://localhost/phpMyAdmin-2.3.2/index.php and it never asked
for a password just gave me:
Error
MySQL said:
Access denied for user: 'root@localhost' (Using pass
Hi!
First, try connecting from the command-line mysql client.
mysql -u root -p -h ser.ver.ip.addr
Then enter your password (if you don't have a root password you can dismiss
-p)
Also, if that works, try resetting cookies from your browser, as phpMyAdmin
relies on cookie authentication.
Iikka
On
On Thu, 2002-10-31 at 21:27, Elaine Kwek wrote:
> i hope someone can help me in my problem. I have use the password function
> in mysql to encrypt a string. Then when i try to get the encrypted password
> using php and compare with the password that user enter. although the user
> provide the corre
You can't decrypt the password from MySQL, instead, you should encrypt the
input from PHP and then do the string comparison.
Good Luck,
Dennis
- Original Message -
From: "Elaine Kwek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:27 PM
Subject: password f
You answer a simple question that is in the table of contents 200 times
in a week, and see how short
your replies get.
Andrew Braithwaite wrote:
Ed,
I feel that your response to this problem is not in the spirit of the open
source world (more like the RTFM response that you would get from a sup
>From the Manual:
How to reset a forgotten root password.
http://www.mysql.com/doc/en/Resetting_permissions.html
Also, don't forget -p when connecting as root.
Quoting Marc Dirix <[EMAIL PROTECTED]>:
> Hi there
> Problem:
>
> I've got two debian linux pc's
> One is my server on which I would
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> Is there an way to get out of my way? Uninstalling mysql-server
> and installing again didn't do the trick
Look in the manual FIRST before porting, please - this is a
Ed,
I feel that your response to this problem is not in the spirit of the open
source world (more like the RTFM response that you would get from a support
desk). We should be encouraging new users with replies like:
"Yes - this is quite a common problem with new installs - you could try x, y
or
1 - 100 of 177 matches
Mail list logo
