Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [phpmyadmin]

A web-based PHP utility used to manage MySQL databases on a server.

0
votes
0answers
16 views

In phpMyAdmin 4.x how to revert browsing as PARTIAL instead of FULL TEXT without clicking the FT GUI button?

After clicking the FT button in the browse interface in phpMyAdmin, now it shows an error 500 whenever I try to browse this table. Therefore, I cannot revert the listing to partial text instead of ...
0
votes
0answers
9 views

phpMyAdmin update not working [on hold]

I've been running phpMyAdmin on an Apache server on Windows for many years. The current version, 2.11.8.1, has been working fine but I decided to update it to 4.8.4 but can't get it to work. I thought ...
0
votes
0answers
11 views

Connect database on phpmyadmin directly to AWS

How can I connect phpmyadmin database directly to any of the AWS services? Is there a way around to connect to the database hosted on the server. Can I use any service like Kinesis, Lambda, AWS data ...
0
votes
0answers
30 views

EasyPHP Devserver 17.0 doesn't create password and privileges for new account

I want to use new EasyPHP release Devserver 17.0 for PHP sites. After installation of EasyPHP I opened phpMyAdmin page and tried to create a new account with my own password and full privileges. The ...
0
votes
0answers
21 views

Why after deleting mysql-bin.index does my server SQL connect again in MAMP otherwhise it does not?

When I install MAMP, everything works fine the first time. Apache server connects and SQL also, I can access phpMyAdmin page also. But after turning off the server and turning it on again, MySQL doesn’...
0
votes
1answer
33 views

PHPMyAdmin Fails After Updating to 4.8.4

After installing the 4.8.4 PHPMyAdmin plugin for WampServer 3.6, it either refuses to load or delivers the following screens: I use WampServer for testing/practice (and am currently working on a ...
0
votes
0answers
33 views

Laravel w/XAMPP on Ubuntu 18.04, how to swtich from built-in PHP server to the Apache server that is running

I'm just starting the basic tasks on the offical site here: basic tasks I followed these directions to try to integrate Laravel with XAMPP: how to install Laravel with XAMPP But it didn't work. I'...
0
votes
0answers
17 views

How to see next page in phpMyAdmin?

In phpMyAdmin, is there some way to see more than the first page of results in a big table? I see the option to display up to 500 rows. But I can't see a next page button anywhere.
1
vote
0answers
20 views

Why is phpMyAdmin showing wrong table names?

I noticed that in phpMyAdmin, if I look at information_schema.tables, all the TABLE_NAME fields show the wrong name. For example, what should be bins is showing as sql.php?table=bins&db=...
0
votes
0answers
31 views

easyPHP - unable to login phpmyadmin

I am totally newbie in this so apologize if this question seems trivial. I have successfully installed easyphp, open up the port on firewall and have my laptop becoming a website server. I can open my ...
0
votes
0answers
9 views

What mysqldump options does phpmyadmin's quick export use?

By options, I mean the stuff listed here: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#mysqldump-format-options
0
votes
1answer
22 views

Project is not launched when clicked from PhpMyadmin list of projects

PhpMyadmin list of projects shows the project I want to launch : After clicking the project finapro2 then the browser shows "we can not find this site." ; and the address bar is http://finapro2 I ...
1
vote
1answer
112 views

Secure PHPMyAdmin on Ubuntu Nginx - direct access to index.php still exists

On an Ubuntu - Nginx webserver I try to secure PHPMyAdmin. There are a lot of tutorials around, they propagate the use of auth_basic or allow own / deny all other IP addresses and/or use obfuscation ...
0
votes
0answers
291 views

Error when importing .xslx/.csv file to MySQL database

I have a simple .xlsx file which I filled in manually and which looks like this: When I open this file in TextEdit nothing shows up and (therefore) this file cannot be imported to the MySQLServer at ...
2
votes
1answer
239 views

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

I have Apache2.4 server in home running MySQL and PHPmyadmin on windows 7 home edition. Everything work great from inside the network but if I try to access the website from outside "internet" it ...
1
vote
1answer
222 views

How to delete bookmarked SQL requests and export templates in phpMyAdmin

Title says it all. The current doc on bookmarks doesn't say a word about it.
0
votes
0answers
51 views

How-to export SQL from phpMyAdmin, Import into third-party SQL viewer

phpMyAdmin lets me export a database as an .SQL file, and I'd like to then be able to run queries on it using a third party SQL viewer (because the website is being closed down). I've tried using a ...
0
votes
0answers
45 views

How to export Designer schema which i have created from localhost

Submitted URI too large! The length of the requested URL exceeds the capacity limit for this server. The request cannot be processed. If you think this is a server error, please contact the ...
0
votes
1answer
1k views

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

I have installed phpMyAdmin after installed MySQL 5.7 and PHP 7.1.12 in Fedora 27, all installed using rpm packages via dnf command. But when I started phpMyAdmin on the web browser using localhost/...
0
votes
0answers
2k views

phpMyAdmin can't connect to mysql when using Docker-Compose, it works using “docker run”

I am currently trying to configure a new server running Ubuntu 16.04 LTS. There is one application running outside docker: My nginx reverse proxy / webserver. This should not interfere because it ...
0
votes
1answer
2k views

Install phpmyadmin with MariaDB

I have a raspberry that I use as a development web server. The other day I had to reinstall the OS and when I tried to reinstall everything I have some problems. When I installed MySql I saw that I ...
-2
votes
1answer
50 views

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

I'm a layman when it comes to web servers, anyhow I have set a lamp server for personal use (it's only accessible locally) in an Ubuntu 17.04 machine and I can access my website normally when I type ...
1
vote
1answer
487 views

Various types of queries not working in phpMyAdmin

Just upgraded to MAMP4 from MAMP3, which meant going from mySQL 5.5 to 5.6. Everything works fine except PHPMyAdmin version 4.6.5.2. This purports to be compatible with mySQL 5.6, but it doesn't ...
0
votes
1answer
36 views

Import and export databases,phpmyadmin

How import and export databases in phpmyadmin? I can find my databases on my house's pc, but I want to work with my database on school's pcs. So what i want to do?
1
vote
0answers
1k views

cannot access localhost/phpmyadmin on windows 7 VM

When i try to connect to localhost/phpmyadmin I get an error in browser "this site cannot be reached" I am running XAMPP on a virtual box windows 7 what I have done so far: in config.inc.php file ...
1
vote
1answer
44 views

Where can I find database backup files?

Is it possible to find a database backup within phpMyadmin or are backup files always stored locally on a pc?
2
votes
1answer
1k views

PyMySQL refusing to install on Raspberry Pi

I have tried every answer I can find to install PyMySQL for example see below: sudo pip install PyMySQL Downloading/unpacking PyMySQL Downloading PyMySQL-0.7.11-py2.py3-none-any.whl (78kB): 78kB ...
1
vote
0answers
44 views

phpmyadmin database upload breaking off

I hope you can help pointing me in the right direction on this since I am a bit out of ideas. I was running phpmyadmin to manage my wordpress databases sucessfully for over a year now. Some days ago ...
0
votes
3answers
5k views

CentOS phpmyadmin folder forbidden

installed php5,apache2,LAMP, PHPMyAdmin but if I type my IP and PHPMyAdmin like this http://__my_IP__/phpmyadmin it is showing the error Forbidden You don't have permission to access /PHPMyAdmin/ ...
0
votes
0answers
168 views

Ubuntu 12.04 Unable to install phpmyadmin after installing mysqlnd

I've recently removed the php mysql extension and replaced it with mysqlnd. While removing mysql phpmyadmin was removed also, and now i'm unable to install it again. Output from apt-get update ...
0
votes
2answers
836 views

myPhpAdmin gives lots of deprecation notices

Just installed myphpadmin on a new pc. Now with every page I visit, I see lots of deprecation notices (related to mcrypt functions). I already tried setting error_reporting = E_ALL & ~...
0
votes
2answers
657 views

Access phpMyAdmin control panel from external ip

I have a WD My Cloud that I would like to also use as a mysql database, I have setup port forwarding on my router on port 3306. When I try to access the mysql database from my C# application using ...
0
votes
1answer
121 views

phpMyAdmin is logging in automatically

I downloaded phpMyAdmin, and when I go to it via localhost:8888/phpMyAdmin it logs me in automatically. (Even the first time I even went to it I was logged in automatically) I don't want it to. I went ...
0
votes
1answer
4k views

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

So when/why would Chrome fail on localhost but load OK from 127.0.0.1? PHP MySQL IIS Windows 10 was running just fine. phpMyAdmin suggested updating. So, renamed working directories to -old. ...
-1
votes
2answers
463 views

mySQL / phpMyAdmin on Windows XP

I need some help finding the right download for mySQL / phpMyAdmin for an old laptop running Windows XP. I'm setting up a server for use in a first year high school course on Web Development; with ...
0
votes
0answers
251 views

wamp server crashes after launch phpMyAdmin

I worked with wamp server for over a month and every thing was great. Recently I had some chinese viruses that made me take some actions including deleting them from the registry. When I tried to ...
0
votes
0answers
807 views

Navigating to “localhost/phpMyAdmin” gives me an indexed list of files & folders

Where of course I'm expecting to see the phpMyAdmin login page. I get a fatal error message when I try localhost/phpMyAdmin/index.php. I should note that I'm not using a package like XAMPP. I wanted ...
0
votes
0answers
46 views

Is there any risk of being hacked if I install an AMP stack?

I need an AMP stack on Ubuntu (Apache + Php, Mysql and Phpmyadmin) but i'm scared that I can get hacked, I would use it just for learning propose, I will NOT connect it to the Internet, I don't want ...
1
vote
2answers
2k views

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

I had php5-fpm, nginx, mysql, phpmyadmin that installed on my ubuntu 14.04. every thing was good. When I updated php to php7.0 phpmyadmin required to install mbstring. I installed it and works well. ...
1
vote
1answer
496 views

MySQL error, can no longer login as root

So I updated my MySQL and PHPMyAdmin yesterday and ever since then I cannot login to MySQL as root or any other username I have. I tried both phpmyadmin and the terminal and still cannot get in. How ...
0
votes
0answers
384 views

How to use and IF statement in PHPMyAdmin

I am using the expression below in PHPMYADMIN with the intent to use it later in a PHP/MySQL application. It gives an error relating to the DECLARE statement in line 1. I've looked at example ...
0
votes
2answers
1k views

Centos - PhpMyAdmin showing blank screen

I have just installed PhpMyAdmin, and when i try to access it it just shows a blank screen. I suspected this is because i followed a tutorial on how to secure php and disabled multiple settings, so i ...
0
votes
0answers
1k views

I installed phpmyadmin but can not access it on kali linux

For LAMP server, I install apache2, mysql, phpmyadmin. All installations went OK. But localhost/phpmyadmin does not show in browser. Browser shows blank page. I restarted apache server. But problem ...
0
votes
0answers
410 views

Is PHPMYADMIN inside iframe possible

So I used this lines of codes. echo '<iframe src="http://127.0.0.1/phpmyadmin/" frameborder="0" style="width:70%;height:70%"></iframe>'; It doesn't show phpmyadmin, it's just blank. ...
1
vote
1answer
147 views

phpMyAdmin config.header.inc.php broken

I have installed phpMyAdmin 4.0.10 on an Ubuntu 14.04.3 LTS Server machine. Everything works fine, but I want to add a banner to the top of the web pages with a legal notice. I should be able to ...
0
votes
2answers
429 views

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

Can somebody confirm/clarify whether using phpMyAdmin Quick database export option is sufficient for backing up WordPress database? Or there is something specific to WordPress database backup that ...
0
votes
1answer
2k views

pmyAdmin how to overcome 2Mb import limit?

I try to import my database tables to local XAMMP dev computer. But i keep hitting 2MB phpMyAdmin limit (Max: 2,048KiB). I try to set all limits to php.ini without luck. So stypid question how i ...
2
votes
1answer
20k views

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

I have installed wordpress on a CentOS 6.6 server, everything works fine, WP, mysql etc but I cannot access the http://MY_IP/phpmyadmin page to import DB as I get: You don't have permission to access ...
1
vote
2answers
4k views

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

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
1
vote
0answers
630 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...