Board index › Topical Discussion › Computers, Math, Science, and Technology

Help needed with MySQL - Error 1045

Page 1 of 1 [ 6 posts ] 

Previous topic | Next topic

steve30
Velociraptor
Velociraptor

User avatar

Joined: 16 Feb 2007
Age: 34
Gender: Male
Posts: 450
Location: Rotherham

18 Sep 2007, 2:11 pm

Does anyone know what this error usually means?

ERROR 1045 (28000) at line 82321: Access denied for user 'clockwis_phpBB'@'gaius.asmallorange.com' (using password: YES)

I get the error when I am trying to restore a database. Someone told me that it could be due to an incorrect password, but the username and password are correct, unless I'm supposed to be using some other password for it.

It does restore some of the database, before stopping at that error.

Any help is appreciated
Thanks!



0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 43
Gender: Male
Posts: 11,038
Location: London

18 Sep 2007, 4:15 pm

Try

GRANT ALL ON database_name.* TO 'clockwis_phpBB'@'gaius.asmallorange.com'



Tim_Tex
Veteran
Veteran

User avatar

Joined: 2 Jul 2004
Age: 45
Gender: Male
Posts: 46,398
Location: Houston, Texas

22 Sep 2007, 7:50 pm

Is this the same MySQL error that causes the nightly WP outage?

Tim


_________________
Who’s better at math than a robot? They’re made of math!


steve30
Velociraptor
Velociraptor

User avatar

Joined: 16 Feb 2007
Age: 34
Gender: Male
Posts: 450
Location: Rotherham

24 Sep 2007, 2:43 am

0_equals_true wrote:
Try

GRANT ALL ON database_name.* TO 'clockwis_phpBB'@'gaius.asmallorange.com'



Unfortunately that didn;t work. It turns out there were loads of errors with the database (in adition to the ones I had already fixed). I got past that error, but now have a load more to fix. I just need to make sure I can have a lot of patience.



cavac
Tufted Titmouse
Tufted Titmouse

User avatar

Joined: 20 Sep 2007
Gender: Male
Posts: 26

24 Sep 2007, 1:39 pm

steve30 wrote:
0_equals_true wrote:
Unfortunately that didn;t work. It turns out there were loads of errors with the database (in adition to the ones I had already fixed). I got past that error, but now have a load more to fix. I just need to make sure I can have a lot of patience.


You might also have to "FLUSH PRIVILEGES;" to ACTUALLY grant them.

P.S.: Not to insult anyone, but why is anyone bothering with MySQL when there's PostgreSQL? Yes, MySQL is easier for beginners. but doesn't really do the full ACID requirements, does it? And especially when you're doing massive multi-user - for example a web-page - your gonna have a lot of headaches without full ACID support... (Ok. as a perl fanatic, postgres in unbeatable for me, having pl/per as embedded language...)



0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 43
Gender: Male
Posts: 11,038
Location: London

24 Sep 2007, 3:41 pm

cavac wrote:
P.S.: Not to insult anyone, but why is anyone bothering with MySQL when there's PostgreSQL? Yes, MySQL is easier for beginners. but doesn't really do the full ACID requirements, does it? And especially when you're doing massive multi-user - for example a web-page - your gonna have a lot of headaches without full ACID support... (Ok. as a perl fanatic, postgres in unbeatable for me, having pl/per as embedded language...)

http://www.mysql.com/news-and-events/pr ... 02_11.html