Koozali.org: home of the SME Server

phpMyAdmin with MySQL5 problems

Offline mike_mattos

  • *
  • 313
  • +0/-0
phpMyAdmin with MySQL5 problems
« on: June 04, 2006, 02:49:54 AM »
I've almost got it working, it loads and says I probably don't have a config file, with  error #1045 - Access denied for user 'root'@'localhost' (using password: NO)

# mysql    &&   is working fine with no password & I did NOT change the root password ( Hi, Charlie , thanks for your many helpful posts! )

I've tried to change user names and passwords to a newly created account that is working fine in MySQL, but phpMyAdmin isn't recognizing the changes in config.inc.php ( copied for the library & edited)  since it still tries to connect as root

Strange observation, the supplied setup.php script seems to work, but after it executes, I can't find the config.inc.php file I think it should create, or a new timestamp on the one in the config directory!

'find' only locates the expected files

suggestions?

thx
...

Offline mike_mattos

  • *
  • 313
  • +0/-0
phpMyAdmin with MySQL5 problems
« Reply #1 on: June 07, 2006, 09:05:45 PM »
strange behaviours exists on SME6 as well!

I got phpMyAdmin working on both SME6 with MySQL 4 and SME 7 with MySQL 5

Main solution was to create ( on SME7 ) a directory /usr/share/php, it alreadywas on the SME SYSTEM

On both systems, copy the library directory from phpMySql into the /usr/share/php directory .  This resolves the open_basedir errors that are not visible if php isn't in debug mode

Manually edit the sample php.inc.php file into   the same directory as phpMyAdmin index.php , it seems to need all the characters in http://www.

do NOT access MyAdmin via  192.168.0.1/phpMyAdmin  , instead use www.mydomain.com/phpMyAdmin/

this worked on both a fresh download of the generic phpMyAdmin archive and the older SME contrib, neither of which worked at the beginning
...