Title: How do I configure phpMyAdmin to start with a blank sql query from the SQL tab?
Tags: phpmyadmin
Question: Clicking on the SQL tab in phpMyAdmin takes me to a query box containing the text
SELECT * FROM <table&gt; WHERE 1
I have to overwrite this each time I run a query. How do I configure phpMyAdmin so that the query box is blank so that I can just paste in my SQL without having to remove the default text first?

Here is the accepted answer: Add the following to your phpMyAdmin configuration file
$cfg['DefaultQueryTable'] = '';
For help on setting up a phpMyAdmin configuration file, please see https://docs.phpmyadmin.net/en/latest/config.html


{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 1, 'CommentCount': 0, 'ContentLicense': 'CC BY-SA 4.0', 'CreationDate': '2019:00:08/17/19', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<phpmyadmin>', 'Title': 'How do I configure phpMyAdmin to start with a blank sql query from the SQL tab?', 'ViewCount': 18, 'id': 57535337, 'user_AboutMe': "<p>I have been coding since I was 11 years old, starting with BASIC using punch cards, then the ZX80, ZX81 and Sinclair Spectrum before mastering 6502 assembly language on the BBC Micro. Following a break to get an Economics degree, I became a professional coder, using COBOL and SQL. I eventually became a qualified Oracle 7 DBA and nailed data modelling. I moved from coding into project and programme management, but coded for fun as a hobby outside work for a couple of decades. I'm now back into coding professionally and am finally mastering PHP. I'm also getting the hang of Laravel, which has some delicious features, and I am a huge fan of PHPStorm.</p>\n", 'user_AccountId': 2931171.0, 'user_DisplayName': 'Tim Rogers', 'user_Reputation': 386.0, 'user_Views': 27.0, 'user_id': 2511355.0}}