Welcome to the first release candidate of phpMyAdmin 5.0.0. This release
features a great number of new features and bug fixes.
This is expected to be the final release candidate before 5.0.0 is
finalized. Please visit
https://github.com/phpmyadmin/phpmyadmin/milestones to stay updated on
the expected release date and known bugs.
Since 5.0.0-alpha1, there have been several bugfixes, none of which are
particularly notable. For a complete comparison, you could visit
https://github.com/phpmyadmin/phpmyadmin/compare/RELEASE_5_0_0ALPHA1..RELEA….
The following are the release notes from 5.0.0-alpha1:
With this release, we are removing support of old PHP versions (5.5,
5.6, 7.0, and HHVM). These versions are outdated and are no longer
supported by the PHP team. Detailed requirement information is available
in the documentation included with the download or at
https://docs.phpmyadmin.net/en/latest/require.html. As shown at
https://www.phpmyadmin.net/downloads/#support our current branch of
4.9.x is planned to remain supported for some time in an LTS capacity.
Some of the changes and new features include:
* Enable columns names by default for CSV exports
* Add Metro theme
* Automatically add the index when creating an auto increment column
* Improvements to exporting views
* Prompt the user for confirmation before running an UPDATE query with
no WHERE clause
* Improvements to how errors are show to the user (including allowing
easier copying of the error text to the clipboard)
* Added keystrokes to clear the line (ctrl+l) and clear the entire
console window (ctrl+u)
* Use charset 'windows-1252' when export format is MS Excel
There are several more changes, please refer to the ChangeLog file
included with the release for full details.
Known shortcomings:
Due to changes in the MySQL authentication method, PHP versions prior to
7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests
show the problem actually began with MySQL 8.0.11). This relates to a
PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround,
that is to set your user account to use the current-style password hash
method, mysql_native_password. This unfortunate lack of coordination has
caused the incompatibility to affect all PHP applications, not just
phpMyAdmin. For more details, you can see our bug tracker item at
https://github.com/phpmyadmin/phpmyadmin/issues/14220.
Downloads are available now at https://phpmyadmin.net/downloads/
Our work would not be possible without the donations of our generous
sponsor, and this release in particular is brought to you thanks to the
hard work of our Google Summer of Code students and many other contributors.
For the team,
Isaac
Welcome to phpMyAdmin 4.9.2, a bugfix release that also contains a
security fix.
This security fix is part of an ongoing effort to improve the security
of the Designer feature and is designated PMASA-2019-5.
There is also an improvement for how we sanitize Git version information
shown on the home page, thanks to Ali Hubail.
This release includes fixes for many bugs, including:
- Fixes for the "Failed to set session cookie" error which relates to
the cookie name. In some cases, data stored in the cookie (such as the
previously-used user account) may not be loaded from a previous
phpMyAdmin cookie the first time you run version 4.9.2
- Fix for Advisor with MySQL 8.0.3 and newer
- Fix PHP deprecation errors
- Fix a situation where exporting users after a delete query could
remove users
- Fix incorrect "You do not have privileges to manipulate with the
users!" warning
- Fix copying a database's privileges and several other problems moving
columns with MariaDB
- Fix for phpMyAdmin not selecting all the values when using shift-click
to select during Export
There are many, many more bug fixes thanks to the efforts of our
developers and other contributors.
The phpMyAdmin team
Hi, can anyone answer my questions about PHP and PhpMyAdmin Licenses?
Can I create web application with PHP and sell it and prevent buyer from
reselling?
is it legal? what the licenses is about?
Hi
When editing a trigger (and probably also stored procedures), when
writing something like
SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum\\(',''),'\\)$','');
And saving it, it will show as
SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum\(',''),'\)$','');
when reopening it. When saving that and reopening it, it will show as
SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum(',''),')$','');
Those backslash character seem to be incorrectly handled.
Thanks for fixing. I honestly wonder why nobody found this over all
those years.
Regards
--
Frederic Steinfels
F. Steinfels Hard- & Software
Seestrasse 110b
8610 Uster
043 544 08 08
HI Everyone,
We are trying create a GuardianKey plugin to phpMyAdmin. However, we have
doubts related to the best way to do this and the best point in the code
for this integration.
GuardianKey is a solution to protect systems against authentication
attacks. It uses Artificial Intelligence and analyses the user's behavior,
threat intelligence and psychometrics (or behavioral biometrics). The
protected system (in the concrete case, phpMyAdmin) must send an event via
REST for the GuardianKey on each login attempt. More info at
https://guardiankey.io/services/guardiankey-auth-security-lite/ .
The best way to integrate would be on having a hook in the procedure that
process the user credentials submission in phpMyAdmin (the script that
receives the POST), something such as:
if(POST IN AUTH FORM) {
boolean loginFailed = checkLogin();
GuardianKeyEvent event = createEventForGuardianKey(username,loginFailed);
boolean GuardianKeyValidation = checkGuardianKeyViaREST(event);
if(GuardianKeyValidation){
// Allow access
} else {
// Deny access
}
}
Where is the best place to create this integration? Is there a way to
create a hook for this purpose? Should we create an extension?
Any help is welcome.
Thank you in advance.
Best regards,
Gesiel
Hello,
My name is Mohammed Rabeeh. I'm a second year pursuing Computer Science and
Engineering in College of Engineering, Trivandrum, India. My domain is web
development both front end and back end. I've been using phpMyAdmin for a
long time and I would love to contribute to it now. I'm a beginner, but I
would love to learn to contribute and submit a lot of bug fixes and new
features.
While going through the code, I saw a lot of documentation written for the
code. I'm guessing it can be auto-generated into a website or something
like that. I would like to know how to do that so I'll better understand
the functionality of each function. I've already taken up an issue and
would like to resolve it as soon as possible.
I'm hoping I'll be able to contribute a lot to phpMyAdmin. Thank You!
- Rabeeh
mohammdrabeeh(a)gmail.com
Buenas, tengo un problema con la configuración del archivo config.inc.php
de la aplicación la cual tengo instalada dentro de una NAS WDMyCloud, si
bien logre ubicar el archivo, puedo descargarlo para agregar o quitar
configuraciones, (en mi caso lo que necesito es agregar la linea de comando
que considera el tiempo de ejecución de las consultas)
pero al momento de volver a cargarlo para que me tome la configuración no
tengo habilitado esa opción y necesitaria saber como habilitarla o en todo
caso como cambiar esa configuración, ya que no veo la distribución de
carpetas dentro de la NAS para poder configurar dicho archivo.
Si pudieran darme una mano con respecto a esto les agradecería, desde ya
muchas gracias...!!
Saludos
Buenas, tengo un problema con la configuración del archivo config.inc.php
de la aplicación la cual tengo instalada dentro de una NAS WDMyCloud, si
bien logre ubicar el archivo, puedo descargarlo para agregar o quitar
configuraciones, (en mi caso lo que necesito es agregar la linea de comando
que considera el tiempo de ejecución de las consultas; Imagen de abajo)
[image: image.png]
pero al momento de volver a cargarlo para que me tome la configuración no
tengo habilitado esa opción y necesitaria saber como habilitarla o en todo
caso como cambiar esa configuración, ya que no veo la distribución de
carpetas dentro de la NAS para poder configurar dicho archivo. Adjunto
debajo
[image: image.png]
Si pudieran darme una mano con respecto a esto les agradecería, desde ya
muchas gracias...!!
Saludos
---------- Forwarded message ---------
From: Almighty Chi Vodi <almightychivodi(a)gmail.com>
Date: Mon, Sep 30, 2019 at 7:00 PM
Subject: Log In
To: <developers(a)phpmyadmin.net>
Hello.
I'm on a Mac and I made the mistake of changing the password for the user
root@localhost. Now I can't log in and keep getting this error message. How
do I regain access?
[image: Screen Shot 2019-09-30 at 6.58.06 PM.png]
--
“If my mind can conceive it, and my heart can believe it - then I can
achieve it.”
― Muhammad Ali
--
“If my mind can conceive it, and my heart can believe it - then I can
achieve it.”
― Muhammad Ali
I am new to mysql/myphoadmin but have created a table in a database and inserted data via PHP
This worked OK but one of the fields is truncated. It is one I set at decimal instead of decimal(3.2) ie type 4.25;
How can I use myphadmin to to alter just this item - it doesnt matter if this disturbs the data since I have emptied the table BUT I dont know how to get to the correct dialog to alter the datatype. Is there a troubleshhooting or maintenance manual somewhere which might contain this info. I realise this is pretty basic but I cant find the solution.
Help very much appreciated.
Heki