PHP Error 1045

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
AlaskaCPU
-


Joined: 17 Apr 2005
Posts: 4
Location: Seward, Alaska

PostPosted: Sun Apr 17, 2005 12:46 am    Post subject: PHP Error 1045 Reply with quote

Hi,

When attempting to use: http://localhost/phpMyAdmin
The login prompt shows - but I get the following error:

MySQL said:

#1045 - Access denied for user: 'sewardak_user@localhost' (Using password: YES) (sewardak_user) is not the real name - just for clarity.

I copied the php...config file (from a working computer) - another computer - changed the www.mydomain.net to www.otherdomain.net, plus username and password. I was hoping this would work.

MySQL - is running - (Green) - and it shows the correct username and password.

ABYSS 2.x - also has the same username and password - to only allow this user to access phpmyadmin for configuration.

The 1st system works great - the 2nd one gives me this error.

Any help would be appreciated.

Thanks
_________________
USA Rocks The World!
Back to top View user's profile Send private message Visit poster's website
Moxxnixx
-


Joined: 21 Jun 2003
Posts: 1226
Location: Florida

PostPosted: Sun Apr 17, 2005 12:52 am    Post subject: Reply with quote

AlaskaCPU, welcome to the forums.

Did you check your config.inc.php in phpmyadmin to see if the user/pass is the same as the one in my.ini?
Back to top View user's profile Send private message Visit poster's website
AlaskaCPU
-


Joined: 17 Apr 2005
Posts: 4
Location: Seward, Alaska

PostPosted: Sun Apr 17, 2005 12:59 am    Post subject: Thanks Reply with quote

Hi,

//my.ini//

[WinMySQLadmin]
Server=C:/Program Files/Abyss Web Server/database/mysql/bin/mysqld-nt.exe
user=sewardak_user
password=1234567

//config.inc.php//

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'sewardak_user'; // MySQL user
$cfg['Servers'][$i]['password'] = '1234567'; // MySQL password (only needed
// with 'config' auth_type)


Thanks
Mike
_________________
USA Rocks The World!
Back to top View user's profile Send private message Visit poster's website
admin
Site Admin


Joined: 03 Mar 2002
Posts: 1332

PostPosted: Sun Apr 17, 2005 1:59 am    Post subject: Re: Thanks Reply with quote

AlaskaCPU,

It seems that you haven't configured MySQL server to grant sewardak_user@localhost access to the database.

Please read http://dev.mysql.com/doc/mysql/en/adding-users.html for more information on the MySQL access system and for examples on how to declare MySQL user accounts and their privileges.
Back to top View user's profile Send private message
AlaskaCPU
-


Joined: 17 Apr 2005
Posts: 4
Location: Seward, Alaska

PostPosted: Sun Apr 17, 2005 2:05 am    Post subject: Thanks Reply with quote

Hi,

Thanks for the TIP - you are correct.

FYI - I was testing Navicat - and found that to be true! And since it allows me to add/change/delete users - I went ahead and purchased it. It's too easy and a great tool.


Warm Regards

Mike
_________________
USA Rocks The World!
Back to top View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sun Apr 17, 2005 1:35 pm    Post subject: Re: Thanks Reply with quote

AlaskaCPU,

You're welcome :-)
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
k1ll3rdr4g0n
-


Joined: 04 Jul 2004
Posts: 609

PostPosted: Sun Apr 17, 2005 5:03 pm    Post subject: Re: Thanks Reply with quote

AlaskaCPU wrote:
Hi,

Thanks for the TIP - you are correct.

FYI - I was testing Navicat - and found that to be true! And since it allows me to add/change/delete users - I went ahead and purchased it. It's too easy and a great tool.


Warm Regards

Mike


-cough- http://www.mysql.com/products/administrator/ -cough-
_________________
Back to top View user's profile Send private message AIM Address
AlaskaCPU
-


Joined: 17 Apr 2005
Posts: 4
Location: Seward, Alaska

PostPosted: Sun Apr 17, 2005 10:10 pm    Post subject: Re: Thanks Reply with quote

Quote:

-cough- http://www.mysql.com/products/administrator/ -cough-


That might be a good also - but the Navicat sure make's it easy!

Mike
_________________
USA Rocks The World!
Back to top View user's profile Send private message Visit poster's website
k1ll3rdr4g0n
-


Joined: 04 Jul 2004
Posts: 609

PostPosted: Sun Apr 17, 2005 10:50 pm    Post subject: Reply with quote

Meh, to each his/her own I guess. =D.
_________________
Back to top View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group