PhpMyAdmin session is closed after 1440 seconds

Adding this to config file is supposed to avoid it

$cfg['Servers'][$i]['LoginCookieValidity'] = 2592000;

Now checking cookies I can see the one named pmaUser-1 expires on March 21, that’s correct.
However sessions keep expiring after 1440 seconds.
I know it’s not PHP, I have many other sites running in the same server and their sessions last forever.
Any idea what’s going on?

database – phpmyadmin Error on GoDaddy shared hosting – Script timeout passed, if you want to finish import, please resubmit the same file

I have a database named A. I want to export it, and import it to a new database B.

I exported the A, no issues. While trying to import to the new database B, I faced the following error:

Script timeout passed, if you want to finish import, please resubmit
the same file and import will resume

I am using shared hosting environment in GoDaddy. I contacted them. They told me that they were able to export and import successfully, and the problem can be related to my internet connection.

On other sites, they are suggesting to modify the below section in config.

$cfg[‘ExecTimeLimit’] = 300

I don’t think I can fix by changing since it is a shared hosting environment plus also I believe the file I am trying to import is not that much big to receive a timeout. So I am not really sure if this is the root cause really.

I also tried to use “copy database” under operations tab in phpmyadmin. This is also not working. Resubmitting the file also didn’t work. What do you suggest ?

query – Dislpay data from phpMyAdmin with WordPress

If it is third party DB you can first connect and then fetch results

mydb = new wpdb('username','password','database','localhost');
$rows = $mydb->get_results("select Name from my_table");

if it is local db , you can use global wpdb object as well.

global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

for reference.
https://developer.wordpress.org/reference/classes/wpdb/

you can run the above code in functions.php.

Depending upon your requirement you can hook it with some action or add it as a shortcode.

e.g.

add_shortcode( 'dbresults', 'wp_dbresutls' );
function wp_dbresutls( ) {
 // your db code
 }

How delete post_content records of specific category from phpmyadmin

I need a SQL command to delete post_content records for specific category’s posts

php – phpmyadmin com problemas

Ontem assinei um serviço VPS para por um jogo de tibia online, instalei tudo certinho, apache 2 , mysql, e phpmyadmin, habilitei todos eles, fiz a instalação do servidor tudo correta, porém quando vou logar no phpmyadmin com as credenciais corretas, o site carrega como se tivesse logado, depois volta para tela de login, uso o sistema operacional Ubuntu 14, alguém sabe como resolver isso ?…Alias, ele faz isso sem credenciais também.

android – ¿guardar en una BBDD phpmyadmin el ID de lo que selecciono en un spinner?

<por favor su ayuda, los datos que obtengo de una tabla los muestro en el spinner, de ahí quiero guardar el id del item seleccionado pero no lose, he visto que se debe de crear un metodo para obtener primero el id y luego enviar a guardar. Estoy creando un metodo que esta en la parte de abajo que s de guardar porque estoy enviando datos adicionales a la misma tabla que quiero guardar lo del spinner por favor su ayuda. Gracias>

private void llenarSpinner(){ //se encarga de llamar al cargarspinner
        String url="obtener.php";
        cliente.post(url, new AsyncHttpResponseHandler() {
            @Override
            public void onSuccess(int statusCode, Header() headers, byte() responseBody) {//evalua la pagina si e que cumple on la condicion
                if (statusCode == 200){
                    cargarSpinner (new String(responseBody));
                }

            }

            @Override
            public void onFailure(int statusCode, Header() headers, byte() responseBody, Throwable error) {

            }
        });
    }

    private void cargarSpinner(String respuesta){
        ArrayList <Barrio> lista = new ArrayList<Barrio>();

        try {
            JSONArray jsonArreglo = new JSONArray(respuesta);
            for(int i=0; i < jsonArreglo.length(); i++){
                Barrio b = new Barrio();
                b.setNombrebarrio(jsonArreglo.getJSONObject(i).getString("nombre_circuito"));
                lista.add(b);
            }
            ArrayAdapter <Barrio> a = new ArrayAdapter <Barrio> ( this, android.R.layout.simple_dropdown_item_1line, lista);
            spnbarrio.setAdapter(a);

        }catch (Exception e){
            e.printStackTrace();

        }
    }
}


y tengo el metodo agregar cliente y boton guardar-----

lo que hago en el metodo guardar es validar q los campos no esten vacios y si es qalguno esta envia un mensaje, y ahi llamo al agregar cliente

    private void agregarCliente(Cliente c){
        String url = "/agregarcliente.php?";
        String parametros = "cedula="+c.getCedula()+"&nombreclientes="+c.getNombres()+"&apellidoclientes="+c.getApellidos()+"&telefonoclientes="+c.getTelefono()+"&correoclientes="+c.getCorreo()+"&direccionclientes="+c.getDireccion()+"&distritoclientes="+c.getBarrio()+"&rucclientes"+c.getRuc();
        cliente.post(url + parametros, new AsyncHttpResponseHandler() {
            @Override
            public void onSuccess(int statusCode, Header() headers, byte() responseBody) {
                if(statusCode == 200){
                    Toast.makeText(ingresoclientes.this, "Cliente agregado correctamente", Toast.LENGTH_SHORT).show();
                    

                }
            }

            @Override
            public void onFailure(int statusCode, Header() headers, byte() responseBody, Throwable error) {

            }
        });
    }

Fallo de conexion en bbdd desde android studio a phpmyadmin

Buenas estoy intentando hacer una conexion a base de datos que tengo en phpmyadmin con el servidor xampp, le puse el archivo de conexion en su lugar correspondiente y cuando ejecuto el codigo me dice todo el rato que fallo de conexion, por mas que añado los permisos en el manifest no me deja. La tabla contiene los campos Nombre, Apellidos, Email, Contraseña y telefono. El codigo me funciona bien tanto el archivo conexion.php como el codigo el unico problema es que siempre me da error de conexion.

public static class Prueba extends AsyncTask<String, Void, String>{

        private WeakReference<Context> context;

        public Prueba(Context context){
            this.context = new WeakReference<>(context);
        }

        @RequiresApi(api = Build.VERSION_CODES.KITKAT)
        @Override
        protected String doInBackground(String... params) {
            String registrar_url = "http://localhost/conexion.php";
            String resultado;

            try{
                URL url = new URL(registrar_url);
                HttpURLConnection httpURLConnection = (HttpURLConnection) url.openConnection();
                httpURLConnection.setRequestMethod("POST");
                httpURLConnection.setDoOutput(true);
                OutputStream outputStream = httpURLConnection.getOutputStream();
                BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(outputStream, StandardCharsets.UTF_8));

                String nombre = params(0);
                String apellidos = params(1);
                String email = params(2);
                String password = params(3);
                String telefono = params(4);

                String data = URLEncoder.encode("nombre", "UTF-8") + "=" + URLEncoder.encode(nombre, "UTF-8")
                        + "&" + URLEncoder.encode("apellidos", "UTF-8") + "=" + URLEncoder.encode(apellidos, "UTF-8")
                        + "&" + URLEncoder.encode("email", "UTF-8") + "=" + URLEncoder.encode(email, "UTF-8")
                        + "&" + URLEncoder.encode("password", "UTF-8") + "=" + URLEncoder.encode(password, "UTF-8")
                        + "&" + URLEncoder.encode("telefono", "UTF-8") + "=" + URLEncoder.encode(telefono, "UTF-8");

                bufferedWriter.write(data);
                bufferedWriter.flush();
                bufferedWriter.close();
                outputStream.close();

                InputStream inputStream = httpURLConnection.getInputStream();
                BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream, StandardCharsets.UTF_8));
                StringBuilder message = new StringBuilder();

                String line;

                while((line = bufferedReader.readLine())!=null){
                    message.append(line);
                }
                resultado = message.toString();

                bufferedReader.close();
                inputStream.close();
                httpURLConnection.disconnect();
            }catch (MalformedURLException e){
                Log.d("URL", "Se ha utilizado una URL con formato incorrecto.");
                resultado = "Se ha producido un Error";
            }catch (IOException e){
                Log.d("Conexion", "Error inesperado!, posibles problemas de conexion de red");
                resultado = "Se ha producido un Error, comprueba tu conexion a Internet";
            }
            return resultado;
        }

        protected void onPostExecute(String resultado){
            Toast.makeText(context.get(), resultado, Toast.LENGTH_SHORT).show();
        }

    }
```

Y esto es lo que tengo en el boton para ejecutar el codigo.
```
btn_registrar.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                new Prueba(MainActivity.this).execute(nombre, apellidos, email, password, telefono);
                
            }
        });
```



character set – Change phpMyAdmin charset

I need to change the server charset on PhpMyAdmin – not the database charset. I’ve not seen much on how to do it. I’m on Windows and I use WAMP. Currently, it is set to cp1252 West European (latin1) and I want it to be on UTF-8 Unicode. I’ve seen and tried this but it changed nothing for me.
Thanks for your help

PHPMyAdmin – Change server charset

I need to change the server charset on PhpMyAdmin – not the database charset. I’ve not seen much on how to do it. I’m on Windows and I use WAMP. Currently, it is set to cp1252 West European (latin1) and I want it to be on UTF-8 Unicode. I’ve seen and tried this but it changed nothing for me.
Thanks for your help

magento2 – Can’t access Phpmyadmin page

I have installed Magento 2.4.1, Nginx, Mysql8, PHP 7.4 and PHPmyAdmin on Debian 10 on ec2. I have done all the steps from this guide:
https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu
My domain is example.mgt.com and when i hit http://example.mgt.com/phpmyadmin i get: Whoops, our bad… I might have done something wrong in /etc/nginx/sites-available/phpmyadmin so nginx can’t “see” phpmyadmin.

Can anyone suggest something? Thank you in advance.