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
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
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
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
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
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,
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
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
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)
Because
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
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
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
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't.
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
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
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
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:
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
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 newsletter;
GRANT ALL PRIVILEGES
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
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
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 the
://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Neil Aggarwal [EMAIL PROTECTED]
To: Mysql list [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 6:00 PM
Subject: Password problem
Hello:
As the root user, I created
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
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
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.
__
/ \\ @ ____@ Adolfo Bello
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
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
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 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
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
-
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
localhost is a
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
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 I was
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
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
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'
38 matches
Mail list logo