Le 12/03/2013 15:37, Tom Davies a écrit :
Hi Tom,
My quick, probably inaccurate guess is the connector. Is the system 32 or 64bit?
Clearly a Gnu&Linux. Is the MySql on the same computer or on a separate server?
It has nothing to do with the connector. We are talking about the
(in)correct setup of the combination :
- web server (apache or lighttpd ?) ;
- mysql server ;
- PDO or PDI or mysqli PHP and/or apache modules ;
- phpmyadmin (which is called "MyAdmin" in PCLinuxOS - a dumbass name
change for no apparently good reason IMHO, but hey)
Ian has established that he can access his mysql server from the command
line, so the daemon is running.
However, what he has not shown us, and the following is directed to you,
Ian :
- is the apache daemon (web server) running - my guess is yes, if the
phpmyadmin login page actually loads ?
- which modules are installed in the web server ?
- which PHP version and libraries (modules/plugins) are installed ?
The error message that Ian posted is well known, a cursory search on
Google brings up :
http://stackoverflow.com/questions/13357561/error-1045-cannot-log-in-to-mysql-server-phpmyadmin
and
http://forums.macrumors.com/showthread.php?t=1228893
just for starters.
Things to remember :
- phpmyadmin needs to have an id/pwd combo in order to be able to
communicate with the mysql server. Usually, this is asked for by the
post-installation scripts of the distrib you are using, but sometimes,
this can go wrong, leading the user to think that phpmyadmin has been
installed and configured successfully when in fact it has not. After
all, the whole point of phpmyadmin is to be able to administer your
mysql server via a web interface, so it generally requires extensive
privileges at the mysql user account level ;
- the file "config.inc.php", which is required in order to be able to
log into the mysql server from the php scripts. Sometimes, this file
does not get copied, or configured correctly, resulting in the inability
to log in - the most frequent reason is that this file contains wrong or
absent information for a default pwd/id combo (hence the links above
explaining this point);
- as Girvin mentioned, the my.cnf options have changed in more recent
versions of mysql with regard to network access, both locally and
remotely, meaning that even on a locally hosted mysql server instance,
it can be necessary to change the my.cnf file in order to get access via
TCP, even from a local IP address such as 127.0.0.1
Alex
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
