| View previous topic :: View next topic |
| Author |
Message |
mgillespie
Apprentice
Joined: 16 Dec 2003
Posts: 170
|
 Posted: Tue Feb 03, 2004 11:19 pm Post subject: Nightmare with MySQL and PHPAdmin. |
 |
|
I did an emerge this evening, and upgraded myPHP and some other stuff, anyways, I had some cfg conflicts to sort out, and I carelessly did a etc-update.
I now cannot logon to mySQL database usign PHPMyAdmin.
I get the following:
| Code: | Server localhost
Error
MySQL said:
#1045 - Access denied for user: 'pma@localhost' (Using password: YES) |
Anyways, the etc-update I messed up, there were changes to the 2x phpmyadmin files, in particlar: /etc/phpmyadmin/mysql-setup.sql
The changed involved the IDENTIFIED BY '324531421312532214'; line, where the number changed.
How can I straighten all this mess out? Thanks.... |
|
| Back to top |
|
 |
radulucian
Apprentice
Joined: 05 Jan 2004
Posts: 151
Location: Bucharest Romania
|
| Posted: Tue Feb 03, 2004 11:31 pm Post subject: here |
|
|
in /etc/phpmyadmin/config.inc.php you have two lines defining
controluser = pam
and controlpass = 'somenumbers'
you MUST set the controlpass to the one that is now registered with mysql. it may still be the old one, because i think you need to execute the mysql-setup.sql in order to get the new one working.
if you cannot figure out which one is it, log into your mysql server and set the password for pma again or use 'root' and no pass for your controluser in config.inc.php of phpmyadmin
_________________
--------------------------
i am gen2 fan too
noone clicks links in the signature 
-------------------------- |
|
| Back to top |
|
|
mgillespie
Apprentice
Joined: 16 Dec 2003
Posts: 170
|
| Posted: Wed Feb 04, 2004 6:05 pm Post subject: |
|
|
Thanks, that fixed it....
I'm not sure I remember playing around with that config.inc.php last time I set it up, it may have been automatic... |
|
| Back to top |
|
|
geforce
l33t
Joined: 29 Dec 2003
Posts: 654
Location: Canada
|
| Posted: Mon Jul 26, 2004 12:56 am Post subject: |
|
|
I would like to thank you...
I really needed to get phpmyadmin work 
Thanks
_________________
http://tilde.club/~geforce/ |
|
| Back to top |
|
|
tomga
n00b
Joined: 13 Jul 2002
Posts: 68
|
| Posted: Wed Jul 28, 2004 2:16 pm Post subject: |
|
|
try
mysql -p < /usr/share/webapps/phpmyadmin/2.5.7_p1/sqlscripts/mysql/2.5.7_p1_create.sql
and then restart mysql
should help with version 2.5.7_p1 |
|
| Back to top |
|
|
|
Networking & Security
