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

[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]



I"ve 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