Skip to main content
20 votes

Make the table listing show entire fields

Click on + Options Select Full texts and click Go Example image:
coffeduong's user avatar
4 votes

View existing indexes using phpMyAdmin

At the structure tab, bellow the columns there is a link indexes, just click there and another table will show all the indexes related.
javier_domenech's user avatar
4 votes

Make the table listing show entire fields

There is another permanent solution if you could able to access the phpmyadmin configuration file config.inc.php. The solution is to change LimitChars property from its default value 50 to any desired ...
SaidbakR's user avatar
  • 308
3 votes

Is there a shortcut key to run a query PHPMyAdmin?

Latest Versions of PHPMyAdmin support Ctrl + Enter and Ctrl+Shift+Enter.
Jijo Paulose's user avatar
3 votes
Accepted

I cant access my website that I hosted in home "Apache24" from internet

Enable apache's error log and see what is going wrong. Since you can access the website for some seconds from outside and apache shows your client's IP successfully connecting to server, try to move ...
MA-Maddin's user avatar
  • 573
2 votes

Where can I find database backup files?

phpMyAdmin does not create backups for you – unless you set up some backups yourself, there are no backups stored within phpMyAdmin nor on your local drive. If you wanted backups, you would have (had)...
slhck's user avatar
  • 230k
2 votes

How to delete bookmarked SQL requests and export templates in phpMyAdmin

OK, so it is actually quite simple once you are reminded that all this is likely kept in another shema of the DB, that you can also tinker with phpMyAdmin. So the answer is: open the phpmyadmin....
xenoid's user avatar
  • 10.2k
2 votes
Accepted

DATEDIFF() refuses to run on a MySQL Event

CREATE EVENT check_expire ON SCHEDULE EVERY 1 DAY STARTS '2019-08-21' DO UPDATE users SET soon_expires = (DATEDIFF(expirationtime, CURRENT_DATE) < 45); or UPDATE users SET soon_expires = 1 WHERE ...
Akina's user avatar
  • 3,235
2 votes

Centos - PhpMyAdmin showing blank screen

Check if you have all the php extensions installed, if it's showing 200 in the console when you access the page but the page is blank, chances are you are missing some extensions. Try installing these ...
Arun Kumar's user avatar
1 vote

PhpStorm database connection error

here you have an anwser https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql Summarizing: go to your msql console and type: SELECT @@global.time_zone; to check that time ...
Phate P's user avatar
  • 111
1 vote

How to add existing DBase to phpmyadmin

You can import your database ( database.sql). In phpmyadmin with import option or via command mysql -u username -p new_database < data-dump.sql https://www.digitalocean.com/community/tutorials/how-...
taybinakh's user avatar
1 vote

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Create the user "pma" in MySQL or change these lines in C:\xampp\phpMyAdmin\config.inc.php for user and password for MySQL. /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = '...
karel's user avatar
  • 13.5k
1 vote

phpMyAdmin CentOS 7 cannot log in to the MySQL server

I found this answer which solved my issue, FYI: change the auth plugin with: ALTER USER YOUR_MYSQL_USERNAME IDENTIFIED WITH mysql_native_password BY 'YOUR_USER_PASSWORD';
Gwif's user avatar
  • 21
1 vote

I can't login in my laravel application

I'm suspecting you are using laravel 6, currently Adldap2 isn't fully supported in laravel 6, try using lower version e.g version 5.7 supports the installation of Adlap2. If that's not the case then ...
Clement S.M.'s user avatar
1 vote

phpmyadmin showing code. php is working

Try configuring FastCGI: sudo a2enmod proxy_fcgi setenvif sudo a2enconf php7.0-fpm sudo service apache2 restart
Dejan's user avatar
  • 11
1 vote

phpmyadmin docker site can't be reached

I tried the docker command locally and it works for me. I can access phpmyadmin at localhost:8000. Going by website.com:8000, are you running this in a remote VM? If so, the firewall settings could ...
sdht0's user avatar
  • 111
1 vote
Accepted

PHPMyAdmin Fails After Updating to 4.8.4

As best as I can tell, the problem is that phpMyAdmin 4.8.4 supports PHP 7.2.x, and my installed PHP version is PHP 7.3. I installed PHP 7.2.13 and switched it to my default PHP installation and ...
Tobi Alafin's user avatar
1 vote

Starting phpMyAdmin gives mbstring extension is missing error even php-mbstring is installed in Fedora 27

From Remi's repository blog. Known issues 5.1. Configuration change After a configuration change, or after a new extension installation, it is now required to restart the php-fpm service. Run these ...
Line_VTY's user avatar
1 vote
Accepted

Install phpmyadmin with MariaDB

MariaDB is essentially forked MySQL so they work the same. With a clean installation there is a root user with no password, so you can just connect via commandline by not specifying -p (run in the ...
Elias's user avatar
  • 681
1 vote

How do I get PhpMyAdmin to see my website's database?

PPHMyAdmin can connect to both local and remote databases. Adjust the config file to hardcode a hostnames. Place the following content in /etc/phpmyadmin/conf.d/default-login.inc.php. This can be ...
George's user avatar
  • 462
1 vote
Accepted

Import and export databases,phpmyadmin

Go to your database, click to export, select the format (if you use it only for database save it as sql) then select the folder where you want to save. Then when you have to open it you have to select ...
Edoardo99's user avatar
1 vote

CentOS phpmyadmin folder forbidden

This works. Centos 7. <Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require all ...
Digitalwolfca's user avatar
1 vote

Access phpMyAdmin control panel from external ip

You're connecting to MySQL instead of Apache (which your browser, for obvious reasons, has no idea what to do with). Change http://11.11.11.11:3306/phpMyAdmin to http://11.11.11.11:80/phpMyAdmin (or ...
ceejayoz's user avatar
  • 2,272
1 vote

When/why would Chrome get 500 error on localhost but load OK from 127.0.0.1, while Firefox loads both?

A 500 Internal Server Error indicates that Chrome does try to load the page and even gets a server response (being the 500 error). So, the server fails. It probably has some logs? As cookies are ...
Arjan's user avatar
  • 31.3k
1 vote

export page of phpmyadmin goes blank after update php5 to php7.0

I solved the problem by modifying line 864 in phpmyadmin/export.php, change : break 2; By: break; Solution provided by bbalent in the following answer: Don't worry, this is a code mistake from ...
Ali's user avatar
  • 651
1 vote

Errors with a phpMyAdmin install on CentOS 7

To solve your problem you need to install priorities: yum install yum-priorities Next edit your /etc/yum.repos.d/remi.repo: nano /etc/yum.repos.d/remi.repo and add priority=5 to remi repository. ...
Eric T's user avatar
  • 11
1 vote

Forcing SSL on phpmyadmin

You must wrap true in quotes in this last line: cfg['ForceSSL'] = 'true'; otherwise it won't work.
adityatelange's user avatar
1 vote

How to set login to phpmyadmin for default user/password in wamp server?

Just go to Wamp Directory on your window and check phpmyadmin in apps folder inside wamp. D:\wamp\apps\phpmyadmin4.1.14 Open config.inc.php and go on line 28. Just put new password or remove it as per ...
Yogesh Trivedi's user avatar
1 vote

How to fix: "phpMyAdmin - Error Cannot start session without errors"?

I had the same issue and resolved it with the following command: sudo chmod 777 /var/lib/php/session/
Qaisar Ali's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible