Most voted "phpmyadmin" questions
phpMyAdmin is a web application developed in PHP for Mysql administration over the Internet. From this system it is possible to create and remove databases, create, remove and change tables, insert, remove and edit fields, execute SQL codes and manipulate key fields.
Learn more…330 questions
Sort by count of
-
26
votes1
answer10816
viewsWhat is the difference between Mysql and phpMyAdmin?
What’s the difference between Mysql and phpMyAdmin?
-
9
votes3
answers689
viewsphpMyAdmin is insurance against bruteforce?
Well, my question is this:: phpMyAdmin has some bruteforce security in the password? That is, at the end of x attempts, the IP gets locked or something like that? Thank you.
phpmyadminasked 7 years, 9 months ago Gonçalo 2,525 -
8
votes3
answers182
viewsConvert date type 2016-10-04 15:51:16 to, 04-10-2016 15:51:16 to SQL or PHP how to do?
I’m doing a job to show the date and time of insertion in the script in the database, I have to show the date in the dd-mm-yyyyyy format and then the time, can I do it by the script’s SELECT or by…
-
7
votes3
answers7634
viewsError importing CSV into phpMyAdmin
I need to import a file .csv for phpMyAdmin, but the special characters do not appear, nor the text that follows them. What may be the problem?…
-
6
votes2
answers322
viewsWhy can’t I use $this within a Static class?
As an example below, I was wondering why I can’t use $this within a Static class? <?php class A{ public static function hello(){ echo 'hello'; } } class B extends A{ public function ok(){ echo…
-
5
votes1
answer24335
viewsField date fills with current date automatically
How do I configure mysql in phpmyadmin so that when I insert a record the field data_lancamento automatically fill in the current date without me having to pass the date by php, someone knows? I saw…
-
4
votes1
answer143
viewsDisplay all tables in the Phpmyadmin navigation column
The Phpmyadmin (English) in these latest versions has the number of tables in the left side navigation limited, being applied a pagination to them. Not only have I noticed being something slower as…
-
4
votes2
answers2708
viewsError "1146 table 'phpmyadmin.pma__tracking doesn’t exist"
This error prevents me from creating new tables and accessing the already created ones: Error: 1146 table 'phpmyadmin.pma__tracking doesn’t exist How do I fix this?…
-
4
votes2
answers7297
viewsHow to duplicate a MYSQL database?
Is there any way to duplicate a database on MYSQL by the execution of any query? I can copy a table with this code: CREATE TABLE table_2 AS SELECT * FROM table_1 But how to copy replicate a…
-
4
votes1
answer7391
viewsAccess by Phpmyadmin ip
Inside the folder c: wamp alias phpmyadmin.conf there is the line below to free phpmyadmin access for all machines in the network: <IfDefine APACHE24> Require all granted I wonder if there is…
-
4
votes0
answers751
views#2002 - No such file or directory no phpmyadmin
I am using MAC OS Sierra (safari 10.0.3), MAMP 4.0.6, phpMyAdmin and netbeans. Everything was going very well, had already run the application some times until suddenly the computer stopped. I…
-
4
votes3
answers259
viewsFilter a select, without duplicate SQL queries being returned
The problem is to return a SELECT with only those schedules that are no longer accepted by the user. I’m trying to use the schedule table that has already been accepted, which has both the user ID…
-
4
votes1
answer111
viewsCopy column data from one table to another
I have 2 tables "Orcamento" -> colunas ['id', 'cliente_id'] Essa tabela existe valores em 'cliente_id' "Ordem_servicos" -> colunas ['id', 'cliente_id', 'orcamento_id'] essa tabela não existe…
-
3
votes1
answer11490
viewsAccess Denied phpMyadmin error 2002
I’m needing to use phpmyadmin in the xampp, but this returning me this error #2002 - File or directory not found The server is not responding (or the socket of the local server is not configured…
-
3
votes2
answers847
viewsNginx does not import phpmyadmin database: "413 Request Entity Too Large"
i have a database of 1.31MB I’m trying to import into my phpmyadmin, which on the side indicates that it supports importing Full Size Database: 2.048KB. But, I’m not getting... every time I try to…
-
3
votes0
answers113
viewslocalhost/phpmyadmin / error 1146
I have a problem accessing phpmyadmin. Follow the error ->…
-
3
votes2
answers606
viewsSave image array to different columns
Good night. I would like to count on your help in solving a problem that has been grinding my molecule for a few days and I have not yet been able to find a solution. I have the following code to…
-
3
votes2
answers139
viewsReturn record with highest number of appearances
Well, I would like to know how to return the record with the field with the highest number of appearances in a phpMyAdmin database table. See the following image: I would like to get "Joao". I tried…
-
3
votes2
answers289
viewsReplace table content with table content?
My case is this:: I have two tables TAB1 and TAB2; the two tables have the same structure: (id, name, surname). I would like to replace the content of TAB1 to the TAB2. Everything that exists in…
-
3
votes1
answer270
viewsSQL does not return all results
I have 2 tables in Mysql, a call municipalities and another call municipios_ibge both have a column called municipality that guards the municipality of each city in Brazil. I have to do the…
-
3
votes1
answer103
viewsDelete select value by comparing to another table
Good morning, I am developing a scheduling site, however, I am having a huge difficulty trying to display only the schedules that are available. Explaining: There is the table Agendamento´, onde…
-
3
votes1
answer1391
viewsI unintentionally deleted all Mysql users phpMyAdmin
I was following some tutorials on the internet to change my mysql user password in phpMyAdmin and in the end I deleted this user. I lost access to phpMyAdmin and do not know how to solve this…
-
3
votes1
answer96
viewsBring results from two tables (INNER JOIN error)
I have the table secretariats with the following structure: And the worker table with the following structure: I related the worker table to the secretariats table through the following list: That…
-
3
votes1
answer257
viewsIs Myisam the default Storage engine on this Mysql server?
I saw that message today: Myisam is the Storage engine by default on this Mysql server How so "default"? What is this defect? I use Innodb, and yet this message appears. Is there a problem with…
-
3
votes4
answers702
viewsColumn 'idusuario' in Where clause is ambiguous
I’m trying to make a select with inner join. Rotating the select in the phpmyadmin the ERROR that returns is this: Column 'idusuario' in Where clause is ambiguous <?php $idusuario =…
-
3
votes1
answer126
viewsHow do I change the order of entering the Mysql database?
I want you to insert something into my Mysql (Phpmyadmin) and place it on top of the last post. Example: Yesterday I inserted Nome: Pedro | Idade: 20 Anos and he was at the top by being the first to…
-
3
votes1
answer106
viewsMysql - Phpmyadmin error running Trigger
Hello, when I try to run the following Rigger, I get this error: #1064 - You have a syntax error in your SQL next to line 11 Follow the Trigger: CREATE TRIGGER atualizacao after update ON cliente…
-
2
votes1
answer71
viewsSafe Updates in Phpmyadmin
In Mysql Workbench has a very useful function called: "Safe Updates", which prevents Updates in a column without WHERE, for example. In Phpmyadmin, is there this function? I could not find.…
-
2
votes0
answers318
viewslocalhost/phpmyadmin error 500
I did the installation of phpmyadmin, it worked correctly, I set up the banks and tested my websites locally. But when I went to turn on the pc again everything works properly, but when I access…
-
2
votes3
answers1614
viewsHow to increase session time in phpMyAdmin on Ubuntu?
When I’m developing a system, I usually leave my phpmyadmin open. Then, when a while goes by, this message below appears: How can I set up my phpmyadmin so that I can increase that session time (or…
-
2
votes3
answers3959
viewsINSERT INTO NOT EXISTS
I need to create an INSERT where it is checked if the value already exists. I looked at some posts, but I am not able to execute. INSERT INTO `pagina_extra` (`ID_PExtra`, `ordem_paginas`, `id_menu`,…
-
2
votes0
answers44
viewsPhpmyadmin Bugado
When I try to access any database by phpmyadmin it returns the following error: SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = 'phpmyadmin' AND table_name = 'pma__bookmark'…
phpmyadminasked 9 years ago João Carlos 21 -
2
votes2
answers507
viewsmysql errors being displayed in French
All errors I receive regarding the phpmyadmin database are in Frances. However, the panel is in en, only query errors -a select for example- are displayed in French. I use the WAMP. EX: Aucune base…
-
2
votes2
answers100
viewsDefault record if no other - mysql
Is it possible to program the database to have a default record if there is no other record in the table? making the table impossible to be empty. then if there are other records it ignores the…
-
2
votes2
answers89
viewsMysql, help to understand data export
In the old days when I was exporting a database I was like this: CREATE TABLE `config` ( `ID_Config` int(1) NOT NULL AUTO_INCREMENT, `nome_site` varchar(255) DEFAULT NULL, `thema` char(50) NOT NULL,…
-
2
votes1
answer296
viewsContent migration between different post types in Wordpress
Good morning, I am currently working with a project for a news portal that is the grouping of 4 different companies, but one of these companies will cease to exist and all its posts will be…
mysql sql wordpress phpmyadmin wordpress-pluginasked 8 years, 10 months ago Lucas Bernieri Ramos 143 -
2
votes0
answers647
viewsMysql Workbench connection in Phpmyadmin?
Good morning. I’m trying to make a Mysql Workbench remote connection to my AWS cloud, where Phpmyadmin is installed, but I’m not getting it. The error presented is: I’ve Googled this mistake but…
-
2
votes2
answers1855
viewsWhich is the best version Xampp / PHP , to update and what’s the difference?
I want to update my XAMPP Version: 1.8.3, plus PHP Version 5.5.15, but I have some questions: What is the best version to upgrade, if it is (5.5.38, 5.6.24 & 7.0.9)? Whether this will affect my…
-
2
votes2
answers7773
viewsThe mbstring Extension is Missing. Please check your PHP Configuration
Even trying to install what’s missing sudo apt-get install phpmyadmin php-mbstring php-gettext, he says it’s already installed And I’ve also activated the extension extension=php_mbstring.dll, what…
-
2
votes1
answer3699
viewsHow the Insert would look in a table that only has a foreign key
I have a user registration and this registration can be done in two ways, by facebook or by email. My question would be how to give the Insert in these tables, because I have a control table that…
-
2
votes1
answer239
viewsCreate and query Wp
Is it possible to create a table in the Wp database to enter values and change them, or would it block me? I wanted to create a simple table only to validate, insert a number and if necessary to…
-
2
votes1
answer1874
viewsScheduling System by Date
I have a scheduling system, where I have to return the dates and times available (not registered at the bank obviously) for a new schedule with those available dates and times. I don’t have a sense…
-
2
votes1
answer759
viewsHow to add a value to the current in each row of a mysql table?
I have the following table in a mysql database: I would like a command to run in phpmyadmin, which sums the current value of the rating_sum column with 5, and rating_count with 1, thus leaving: I…
-
2
votes0
answers65
viewsWhat’s wrong with my code? Insert a data and then insert no more!
html: <!doctype html> <html lang="pt-br"> <head> <meta charset="utf-8"> <title>Untitled Page</title> <meta name="generator" content="WYSIWYG Web Builder…
-
2
votes0
answers564
viewserror #1932 in phpMyAdmin
I installed XAMPP for Windows 5.6.15, Apache + Mariadb + PHP + Perl. Everything works fine until "out of the blue" some tables are randomly "in use". I just can’t access them anymore, keep…
-
2
votes1
answer1778
viewsKey Foreign Relationship Problem in Phpmyadmin - Wamp
I have 'problem' in my Wamp, more precisely in the latest version (Wampserver 3.0.6 64 bit x64). When I create 2 tables, example: CREATE TABLE categoria( id_categoria INT NOT NULL AUTO_INCREMENT,…
-
2
votes2
answers1469
viewsHow to automatically add two columns from two different tables and perform Insert in another table in Mysql?
I am starting work with database and would like to perform an intelligent action in the bank. I have two tables that store information from different sensors, each with its respective columns. I…
-
2
votes1
answer218
viewsAvoid Duplicity in PHP+Mysqli Registration
good night! How do I prevent registration with the same information? Currently my "processa.php" is like this, and I wanted to include the function mentioned above... <?php session_start();…
-
2
votes1
answer255
viewsMysql - Update on every Row
Guys, I’ve been trying to put together a line of code for a while, but I never get the desired result, ever arrived in 3 codes but none of the 3 executes the code for each result found. It is…
-
2
votes1
answer51
viewsDelete duplicate rows in a table
I used the following SELECT to find the repeated values: SELECT nome, Count(nome) FROM projeto GROUP BY nome HAVING Count(nome)>1 Now I need to delete everything that is repeated and leave only…