Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

P.S.: below is a snippet of my php.ini

; Maximum number of persistent links.  -1 means no limit.
mysqli.max_persistent = -1

; Allow accessing, from PHP's perspective, local files with LOAD DATA statements
;mysqli.allow_local_infile = On

; Allow or prevent persistent links.
mysqli.allow_persistent = On

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; If mysqlnd is used: Number of cache slots for the internal result set cache
mysqli.cache_size = 2000

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
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
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.
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

On Wed, 20 Feb 2013 11:52:42 +0100, Ian Whitfield <> wrote:

Hi All

(In particular I hope *Heinz* picks this up as he was so helpful last

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!!

Pretoria RSA

Erstellt mit Operas revolutionärem E-Mail-Modul:

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.