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" <[EMAIL PROTECTED]>
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