Re: password problem

2015-07-31 Thread Reindl Harald
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

Re: password problem

2015-07-31 Thread 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 stuff, but you're short on patience, and it would hel

Re: password problem

2015-07-31 Thread Reindl Harald
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

Re: password problem

2015-07-31 Thread shawn l.green
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

Re: password problem

2015-07-31 Thread Reindl Harald
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

Re: password problem

2015-07-31 Thread Reindl Harald
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

Re: password problem

2015-07-31 Thread 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/my.cnf . It doesn't have any data directory path

Re: password problem

2015-07-31 Thread 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 user that the MySQL server runs as (for example, mys

Re: password problem

2015-07-31 Thread nikhil anand
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

Re: password problem

2015-07-31 Thread Reindl Harald
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

Re: password problem

2015-07-30 Thread Reindl Harald
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

RE: Re: Password problem

2003-01-16 Thread John Arnold
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

RE: Password problem

2003-01-16 Thread John Arnold
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

Re: Password problem

2003-01-15 Thread gerald_clark
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

Re: Password problem

2003-01-15 Thread Stefan Hinz, iConnect \(Berlin\)
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:

Re: Password problem

2003-01-15 Thread Doug Thompson
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