access denied 1045
I'm completely new to mysql. I've been hunting all over the web and mysql help/documentation but could not find a working solution to my problem. I installed mysql on a RAQ4 from the standard package that came from Cobalt. I was able to set the root@host password, but unable to set the root@localhost password and I beleive this is the source of my proble. When trying to do anything password related mysql I get errors ERROR 1045: Access denied for user: 'root@localhost' The errors start at the basic basis: shell mysql -u root test Having looked at the help pages it seems (thanks to Joerg Prante for his comment on the relevant mysql documentation page otherwise I would not have known) that there would be an issue regarding acquiring additional privileges from the mysql administrator. However, it is my raq and I do have (should have) all the privileges. I must be doing something wrong, but don't know what. Anyone had the same poblem? Anyone knowing the solution? Thanks. Using mysql version Cobalt MySQL Release 3.23.37-1 The quote from Joerg: One case not mentioned here and you get an 1045 Access denied error is when you don't have the privilege to alter system tables using LOCK TABLES. The connect succeeds, but a LOCK TABLES query fails. Then you should ask the MySQL administrator to extend your privileges. The LOCK TABLES command is writing to the system tables. If the MySQL administrator decided to grant you all privileges only on your database, say foo.*, this won't be sufficient. You will need write access to 'mysql' database. If you don't have that, you will get a MySQL error #1045 access denied at the LOCK TABLES query. So, the case of LOCK TABLE privilege in MySQL breaks a privilege system where administrators decided to grant privileges ordered by database hierarchy. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - 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
RE: access denied 1045
Hi Cobalt uses 'cobalt-mysql' as the default mysql root password. I spent hours trying to sort this one out, reinstalled the whole thing, manually recreated Mysql database all sorts Stupid to use non standard setup really. If that doesn't work come back to me. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Zinneken [mailto:[EMAIL PROTECTED]] Sent: 16 November 2002 10:31 To: [EMAIL PROTECTED] Subject: access denied 1045 I'm completely new to mysql. I've been hunting all over the web and mysql help/documentation but could not find a working solution to my problem. I installed mysql on a RAQ4 from the standard package that came from Cobalt. I was able to set the root@host password, but unable to set the root@localhost password and I beleive this is the source of my proble. When trying to do anything password related mysql I get errors ERROR 1045: Access denied for user: 'root@localhost' The errors start at the basic basis: shell mysql -u root test Having looked at the help pages it seems (thanks to Joerg Prante for his comment on the relevant mysql documentation page otherwise I would not have known) that there would be an issue regarding acquiring additional privileges from the mysql administrator. However, it is my raq and I do have (should have) all the privileges. I must be doing something wrong, but don't know what. Anyone had the same poblem? Anyone knowing the solution? Thanks. Using mysql version Cobalt MySQL Release 3.23.37-1 The quote from Joerg: One case not mentioned here and you get an 1045 Access denied error is when you don't have the privilege to alter system tables using LOCK TABLES. The connect succeeds, but a LOCK TABLES query fails. Then you should ask the MySQL administrator to extend your privileges. The LOCK TABLES command is writing to the system tables. If the MySQL administrator decided to grant you all privileges only on your database, say foo.*, this won't be sufficient. You will need write access to 'mysql' database. If you don't have that, you will get a MySQL error #1045 access denied at the LOCK TABLES query. So, the case of LOCK TABLE privilege in MySQL breaks a privilege system where administrators decided to grant privileges ordered by database hierarchy. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - 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 - 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
[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]
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)]]
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
2nd Attempt: Fwd: Access Denied (1045)]
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] 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
Access Denied (1045)
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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php