Hi Ian, I don't use MyAdmin but prefer to use the mysql command-line client. This may be a "fad" of mine, but I like to have "total control" of what I do by using bare-bone commands... Could it be that you have to specify something in the php.ini configuration file regarding mysqli? Regarding your connection problem: provided that you have added the .jar file for the JDBC-connector (which it seems you have done!) the situation seems to most likely have to do with missing privileges for your userid ianw, since I do assume you entered the password when trying to connect to the server via LO-Base. Sorry I can't be of more help. Good luck in any case. Regards from snowed-in Salzburg Heinrich
P.S.: below is a snippet of my php.ini ------------------------------------------------------------------------- [MySQLi] ; Maximum number of persistent links. -1 means no limit. ; http://php.net/mysqli.max-persistent mysqli.max_persistent = -1 ; Allow accessing, from PHP's perspective, local files with LOAD DATA statements ; http://php.net/mysqli.allow_local_infile ;mysqli.allow_local_infile = On ; Allow or prevent persistent links. ; http://php.net/mysqli.allow-persistent mysqli.allow_persistent = On ; Maximum number of links. -1 means no limit. ; http://php.net/mysqli.max-links mysqli.max_links = -1 ; If mysqlnd is used: Number of cache slots for the internal result set cache ; http://php.net/mysqli.cache_size mysqli.cache_size = 2000 ; http://php.net/mysqli.cache_size mysqli.cache_size = 2000 ; Default port number for mysqli_connect(). If unset, mysqli_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. ; http://php.net/mysqli.default-port mysqli.default_port = 3306 ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. ; http://php.net/mysqli.default-socket mysqli.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). ; http://php.net/mysqli.default-host mysqli.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). ; http://php.net/mysqli.default-user mysqli.default_user = ; Default password for mysqli_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. ; http://php.net/mysqli.default-pw mysqli.default_pw = ; Allow or prevent reconnect mysqli.reconnect = Off ------------------------------------------------------------------------------ On Wed, 20 Feb 2013 11:52:42 +0100, Ian Whitfield <[email protected]> wrote:
Hi All (In particular I hope *Heinz* picks this up as he was so helpful last time!!) I have just upgraded my PClinuxOS system with the latest 2013.02 version. To do this I used an ISO disk and ran the upgrade without overwriting or formatting 'home' to preserve my data etc. It installed perfectly and almost all my stuff is available and working. The two areas I have problems with are - 1) I have no sound (but will work on that later). 2) More importantly I can not access my MySQL Database!! MySQL is part of the new installation and I have set it to 'Start on Boot'. I re-installed MyAdmin via Synaptic I should have the Connector in the installation. I edited out the "skip networking" line in /etc/my.cnf Now if I try to run MyAdmin I get the error ... /"//The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>"/ So I installed mysqli via Synaptic, did a re-boot and tried again but still get the same error!! I decided to move on anyway and started Base, selected Connect to existing database, using JDBC, entered DB Name, localhost, port 3306 and tested the connection. It gives me "JDBC Driver loaded OK" I accepted the Driver Class and tested and I get the error ... /"Error code: 1045// //Access denied for user 'ianw'@'localhost' (using password: YES)"/ Where have I gone wrong or can you see any errors on my part?? This MySQL Database was working perfectly before I upgraded the OpSys!! Very many thanks as always!! IanW Pretoria RSA
-- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: [email protected] 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
