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
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 has somehow installed passwords about which I know
Felix Geerinckx wrote:
On 24/11/2005, Lowell Allen wrote:
but I'm looking for a way to convert the short hash values into
comparable long hash values.
This is (fortunately) *not* possible.
Apparently the upgrade procedure can successfully convert
short-to-long hash values for MySQL user pa
On 24/11/2005, Lowell Allen wrote:
> but I'm looking for a way to convert the short hash values into
> comparable long hash values.
This is (fortunately) *not* possible.
> Apparently the upgrade procedure can successfully convert
> short-to-long hash values for MySQL user passwords
It doesn'
I have a PHP application that stores member-access passwords in a char
column. When the passwords were stored, they were written to the
database using the PASSWORD() function. Each hashed password is 16
characters long. When a member logs in, the plain text password
submitted is run through the
Frank Bax wrote:
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is
give root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_passw
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045: A
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045: Access denied for user: '[EMAIL PROTEC
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
irector, IT Web Strategies
2k3 Technologies
915.439.1660
-Original Message-
From: Neil Aggarwal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 11:00 AM
To: Mysql list
Subject: Password problem
Hello:
As the root user, I created a new database and user account:
CREATE DATABASE newsl
> you can do this:
>
> mysql> set password for newsletter@localhost=PASSWORD("testPass");
>
> or
>
> mysql> update user Set Password=Password("testPass")
> -> where user="newsletter";
Don't forget the "flush privileges" thing after the update command.
> __
>/ \\ @ ____
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.
you can do this:
mysql> set password for newsletter@localhost=PASSWORD("testPass");
or
mysql> update user Set Password=Password
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
etails: http://www.mysql.com/doc/en/GRANT.html
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -----
From: "Neil Agga
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
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 the command-line client:
/usr/local/mysql/bin/mysql -u newsletter -
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
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/mysql/bin/mysql -u root -pchrist1
It will not work .
Even if I do the following command I get an error
/opt/my
I see 2 possible problems:
1) syntax: I had to experiment with the mysql line a bit before
it worked. Try:
mysql -urknop -p
password
(Note no space before username, password last)
2) Your user has no permissions at all: I've never tried that, but
I wouldn't be surprised if it made login impo
> It's probably a good idea to remove the entry for ''@'localhost'.
For many reasons, yes. :)
-Rob
(SPAMblocker food: sql table query database)
--
-=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=-
Help the EFF protect basic freedoms online: http://www.eff.org
Robert A. Knop Jr. writes:
> > localhost is a special value (meaning connection over unix socket
> > rather than TCP/IP), and it's not matched by % in this case. You
> > need to grant access to user@localhost as well.
>
> (Is this in the manual? If so, I didn't find it.
Heh, it turns out that
> localhost is a special value (meaning connection over unix socket
> rather than TCP/IP), and it's not matched by % in this case. You
> need to grant access to user@localhost as well.
Aha! That did the trick. Thank you very much.
(Is this in the manual? If so, I didn't find it. It would pro
Robert A. Knop Jr. writes:
>ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
>
> mysql> select * from user where user='rknop'\G
> *** 1. row ***
>Host: %
>User: rknop
localhos
> I don't know if this is it, but
I don't think so; I've tried "flush privileges", even though the docs don't
state it's necessary for GRANT or SET PASSWORD. I've also tried stopping
and restarting the mysqld process.
-Rob
-
B
I don't know if this is it, but
--
6.11 When Privilege Changes Take Effect
When mysqld starts, all grant table contents are read into memory and become
effective at that point.
Modifications to the grant tables that you perform using GRANT, REVOKE, or SET
PASSWORD are noticed by t
OK, I think I've read the docs and am doing everything right, but I simply
cannot get the "mysql" program to accept a password for any user other than
root.
I'm on RedHat Linux 7.2, with MySQL version 3.23.46.
I can get the root password set up fine, and I log in with it. I can even
change it:
I fixed the problem I just posted with MySql new installs "not seeing"
my passwords.
I had simply forgotten to flush the permissions after I set the
password.
"mysqladmin -u root flush-privileges"
Cheers,
-Richard
-
Before
Hi,
I am trying to set up a passsword a system root for the root MySQL
server
for the 1st time (rpm download) & I get the following error message:
[root@localhost MySQL]# /usr/bin/mysqladmin -u mysql -p password
'x1234!'
Enter password:
/usr/bin/mysqladmin: connect to server at 'localhost' faile
38 matches
Mail list logo
