Delete a database in phpMyAdmin
On phpMyAdmin 4.1.9: database_name > Operations > Remove database
phpmyadmin
Auto increment in phpmyadmin
There are possible steps to enable auto increment for a column. I guess the phpMyAdmin version is 3.5.5 but not sure. Click on Table > Structure tab > Under Action Click Primary (set as primary), click on Change on the pop-up window, scroll left and check A_I. Also make sure you have selected None for … Read more
How to log in to phpMyAdmin with WAMP, what is the username and password?
Try username = root and password is blank.
“Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
Open phpMyAdmin in a browser and log in as root. Create a database called phpmyadmin Create a user called pma and set the “host” to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant … Read more
Is there a way to view past mysql queries with phpmyadmin?
Ok, so I actually stumbled across the answer. phpMyAdmin does offer a brief history. If you click on the ‘sql’ icon just underneath the ‘phpMyAdmin’ logo, it’ll open a new window. In the new window, just click on the ‘history’ tab. That will give you the last twenty or so SQL operations.
How can I edit a view using phpMyAdmin 3.2.4?
To expand one what CheeseConQueso is saying, here are the entire steps to update a view using PHPMyAdmin: Run the following query: SHOW CREATE VIEW your_view_name Expand the options and choose Full Texts Press Go Copy entire contents of the Create View column. Make changes to the query in the editor of your choice Run … Read more
Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
A database is represented by a directory under the data directory (usually /var/lib/mysql), and the directory is intended for storage of table data. The DROP DATABASE statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove … Read more
#1071 – Specified key was too long; max key length is 1000 bytes
As @Devart says, the total length of your index is too long. The short answer is that you shouldn’t be indexing such long VARCHAR columns anyway, because the index will be very bulky and inefficient. The best practice is to use prefix indexes so you’re only indexing a left substring of the data. Most of … Read more
phpmyadmin logs out after 1440 secs
Go to PHPMyAdmin in your browser Settings > Features > Change the value of Login cookie validity > Save NOTE: You will have to do this per session.
How to access remote server with local phpMyAdmin client?
Just add below lines to your /etc/phpmyadmin/config.inc.php file in the bottom: $i++; $cfg[‘Servers’][$i][‘host’] = ‘HostName:port’; //provide hostname and port if other than default $cfg[‘Servers’][$i][‘user’] = ‘userName’; //user name for your remote server $cfg[‘Servers’][$i][‘password’] = ‘Password’; //password $cfg[‘Servers’][$i][‘auth_type’] = ‘config’; // keep it as config You will get Current Server: drop down with both 127.0.0.1 and … Read more