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