24 votes

How to export mysql schema from phpmyadmin?

Select your database or table. Select the Export tab. Below Export method, select Custom. Below Tables, check the appropriate Structure boxes. Here's a screenshot:
Leo's user avatar
  • 339
20 votes

Make the table listing show entire fields

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

WAMP MySQL Service will not start

I tried going to: C:\wamp\bin\mysql\mysql5.6.17\data and deleted the following: auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1 But I left the ibdata1 alone as it references all ...
brettster's user avatar
  • 161
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
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
3 votes

WAMP MySQL Service will not start

Please check the port that MySQL is using on your system. Then, change the port number of the WAMP server's MySQL service to that number by entering it in my.ini. If you're running Windows, make sure ...
Nikhil Goswami's user avatar
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

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

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

PHP "sessions" store variables so they can persist across multiple HTTP requests. PHP sends your browser a single cookie that serves as a key. The key is used to retrieve the values from server-side ...
Prashant Pokhriyal's user avatar
2 votes

phpMyAdmin Quick database export: is it OK to use it for WordPress database backup?

A PhpMyAdmin quick export is a perfectly safe way to backup a Wordpress database. PhpMyAdmin's quick export is configured by default to export the database structure and all the records as SQL. You ...
RCrowt's user avatar
  • 156
2 votes

pmyAdmin how to overcome 2Mb import limit?

There are probably three properties that need to be changed. php.ini upload_max_filesize = 16M post_max_size = 16M my.cnf max_allowed_packet = 16M After adjusting these commands I suggest a ...
Matt Clark's user avatar
  • 2,019
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
  • 224k
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
  • 9,812
2 votes

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,195
2 votes

How to change user password in phpmyadmin?

This is a summary of the article How to Reset Your Admin Password in phpMyAdmin: Open phpMyAdmin and click the admins table on the left Find your user in the username column and click "Edit"...
harrymc's user avatar
  • 458k
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

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

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 to (or ...
ceejayoz's user avatar
  • 2,282
1 vote

When/why would Chrome get 500 error on localhost but load OK from, 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
  • 31k
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
  • 621
1 vote

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

Centos - PhpMyAdmin showing blank screen

Depending what else is running on that public (I assume based on your link) web server, I recommend looking at the error logs (located in /var/log/httpd/php_error_log.log according to the phpinfo) ...
Mike's user avatar
  • 569
1 vote

You don't have permission to access /phpmyadmin on this server

I have found the solution: I edited the file /etc/httpd/conf.d/phpMyAdmin.conf like the following : <Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 <IfModule mod_authz_core.c&...
rf2632's user avatar
  • 139
1 vote

Invalid field count in CSV input on line XX in phpmyadmin?

To find these cases, look for any characters that may be interpreted as a delimiter, or a complex or unclosed quote. Remember that if there is a newline as part of a field value earlier in the file, ...
Parker's user avatar
  • 905
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 fix the phpmyadmin error "json extension is missing"?

Open the following file: /etc/php5/apach2/php.ini Write the following line in the end of the file. extension=json.so restart the apache2 $ sudo service apache2 restart Enjoy
sirajalam049's user avatar

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