View previous topic :: View next topic |
Author |
Message |
AlaskaCPU -
Joined: 17 Apr 2005 Posts: 4 Location: Seward, Alaska
|
Posted: Sun Apr 17, 2005 12:46 am Post subject: PHP Error 1045 |
|
|
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 |
|
 |
Moxxnixx -
Joined: 21 Jun 2003 Posts: 1226 Location: Florida
|
Posted: Sun Apr 17, 2005 12:52 am Post subject: |
|
|
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 |
|
 |
AlaskaCPU -
Joined: 17 Apr 2005 Posts: 4 Location: Seward, Alaska
|
Posted: Sun Apr 17, 2005 12:59 am Post subject: Thanks |
|
|
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 |
|
 |
admin Site Admin
Joined: 03 Mar 2002 Posts: 1332
|
Posted: Sun Apr 17, 2005 1:59 am Post subject: Re: Thanks |
|
|
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 |
|
 |
AlaskaCPU -
Joined: 17 Apr 2005 Posts: 4 Location: Seward, Alaska
|
Posted: Sun Apr 17, 2005 2:05 am Post subject: Thanks |
|
|
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 |
|
 |
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sun Apr 17, 2005 1:35 pm Post subject: Re: Thanks |
|
|
AlaskaCPU,
You're welcome :-) _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
 |
k1ll3rdr4g0n -
Joined: 04 Jul 2004 Posts: 609
|
Posted: Sun Apr 17, 2005 5:03 pm Post subject: Re: Thanks |
|
|
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 |
|
 |
AlaskaCPU -
Joined: 17 Apr 2005 Posts: 4 Location: Seward, Alaska
|
Posted: Sun Apr 17, 2005 10:10 pm Post subject: Re: Thanks |
|
|
That might be a good also - but the Navicat sure make's it easy!
Mike _________________ USA Rocks The World! |
|
Back to top |
|
 |
k1ll3rdr4g0n -
Joined: 04 Jul 2004 Posts: 609
|
Posted: Sun Apr 17, 2005 10:50 pm Post subject: |
|
|
Meh, to each his/her own I guess. =D. _________________
 |
|
Back to top |
|
 |
|