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

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



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




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