[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]

2002-10-23 Thread Anthony W. Marino
 Any thoughts with regards to the problem outlined below would be 
appreciated!
Thank You,
Anthony

 Original Message 
Subject: 2nd Attempt: Fwd: Access Denied (1045)]
Date: Fri, 18 Oct 2002 06:59:21 -0400
From: Anthony W. Marino [EMAIL PROTECTED]
To: [EMAIL PROTECTED]



 I'm boxed in a corner and would appreciate some suggestions, please!

Thank You,
Anthony

 Original Message 
Subject: Access Denied (1045)
Date: Tue, 15 Oct 2002 08:47:05 -0400
From: Anthony W. Marino
To: [EMAIL PROTECTED]



 Ive searched about and still haven't been able to resolve my problem.

Scenario:

1) OS is RH 7.3.
2) Installing MySQL 4.04-Pro binary tarball.
3) Ordinary user, userX.grpX, is installing tarball themselves on a 
shared server accessed via telnet.
4) This installation will be userX's instance only, however, there are 
other MySQL server's running at this site.
5) All directories/files for this installation/implementation are owned 
by userX.grpX who has non-root access.
6) Modified my.cnf with unique values including port, socket, 
bind-address, relevant paths and values so as not to step on other 
installations/implentations.
7) my.cnf is passed through mysqld_safe using --defaults-file= option.
8) mysql_installdb is run.
9)  mysql.server is run.


Results:

1) mysqld  runs with the following log snippets:
Error Log: Warning: One can only use the --user switch if running as 
root.  
mysqld Log:  /unique-path-to-userX-installed-mysql/bin/mysqld, Version: 
4.0.4-beta-log, started with:
Tcp port: 3307  Unix socket: /unique-path-to-userX-area/temp/mysql.sock

2) When the user tries to run mysql, mysqladmin and etc the 
following error message is received:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO).

Please note that no passwords have been setup as of yet because we can't 
get pass the access issue.


Thank You In Advance!
Anthony




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail 
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







Re: [Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]

2002-10-23 Thread gerald_clark


Anthony W. Marino wrote:


 Any thoughts with regards to the problem outlined below would be 
appreciated!
Thank You,
Anthony

 Original Message 
Subject: 2nd Attempt: Fwd: Access Denied (1045)]
Date: Fri, 18 Oct 2002 06:59:21 -0400
From: Anthony W. Marino [EMAIL PROTECTED]
To: [EMAIL PROTECTED]



 I'm boxed in a corner and would appreciate some suggestions, please!

Thank You,
Anthony

 Original Message 
Subject: Access Denied (1045)
Date: Tue, 15 Oct 2002 08:47:05 -0400
From: Anthony W. Marino
To: [EMAIL PROTECTED]



 Ive searched about and still haven't been able to resolve my problem.

Scenario:

1) OS is RH 7.3.
2) Installing MySQL 4.04-Pro binary tarball.
3) Ordinary user, userX.grpX, is installing tarball themselves on a 
shared server accessed via telnet.
4) This installation will be userX's instance only, however, there are 
other MySQL server's running at this site.
5) All directories/files for this installation/implementation are 
owned by userX.grpX who has non-root access.
6) Modified my.cnf with unique values including port, socket, 
bind-address, relevant paths and values so as not to step on other 
installations/implentations.
7) my.cnf is passed through mysqld_safe using --defaults-file= 
option.
8) mysql_installdb is run.
9)  mysql.server is run.


Results:

1) mysqld  runs with the following log snippets:
Error Log: Warning: One can only use the --user switch if running as 
root.  mysqld Log:  
/unique-path-to-userX-installed-mysql/bin/mysqld, Version: 
4.0.4-beta-log, started with:
Tcp port: 3307  Unix socket: /unique-path-to-userX-area/temp/mysql.sock

2) When the user tries to run mysql, mysqladmin and etc the 
following error message is received:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: 
NO).

Please note that no passwords have been setup as of yet because we 
can't get pass the access issue.


Thank You In Advance!
Anthony

Did you specify the proper socket when connecting?
Perhaps you are trying to connect to a server that DOES have a password 
set for root.










-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php