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

learn more… | top users | synonyms

1
vote
1answer
63 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
31 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
0answers
91 views

xampp myphpadmin and mysql server 5.7 not working together

I have MySQL Server 5.7 running on my windows 10 machine and I installed xampp 5.6. To start MySQL for phpMyAdmin I have to stop the MySQL57 service which uses port 3306 if it is already running. If ...
0
votes
2answers
63 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
168 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
53 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. ...
0
votes
0answers
142 views

How to reset phpmyadmin to default settings

I tried to use xampp and phpmyadmin a little while ago and I accidentally broke something, which made it so that phpmyadmin did not work anymore. I tried to uninstall and reinstall xampp and to ...
0
votes
0answers
268 views

Installing Apache, MySQL, PHP and phpMyAdmin on El Capitan (Password Problems)

I am at my wit's end! I am fairly new to using a mac, and I've never set something like this up before, but I'm fairly sure I'm not an idiot. Every time I've tried to install this, I'd get all the way ...
0
votes
0answers
17 views

upload directory seems empty (says phpmyadmin) — phpmyadmin, upload/save/import directories

I keep getting this error message from phpmyadmin when trying to import a file from the web server upload directory (defined in config.inc.php by $cfg['UploadDir']): "No files available on server for ...
0
votes
0answers
16 views

How to access “Setup script” at phpMyAdmin?

I installed phpmyadmin v 4.0.10-1 . I can access it localhost/phpmyadmin. I do login. Then I wish to go Settings->Manage your settings->Setup script. After I click "Setup script" I get an ...
1
vote
1answer
44 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
0answers
55 views

OSX: How to open control panel or phpmyadmin in xampp?

xampp: 5.6.15 OS: EI Capitan I just started using OSX. On windows, everything is quite straightforward with control panel, but in OSX, I had to use spotlight to search for control panel, and ...
0
votes
0answers
84 views

CakePHP - Connection reset when trying to save long data or post with much special chars

i have a problem with my new cakephp application, the browser show me this error: "the connection was reset" with no technical informations ! note: a part of data (the post) saved but not all data ! ...
0
votes
2answers
166 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
0answers
86 views

How can I export MySQL large database from remote server using only phpMyAdmin access? [closed]

My client give me phpMyAdmin access to do database related task. I am stuck to export the database because database size is very large. Client give me credential like followings: {ip-address}/...
0
votes
1answer
247 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 ...
0
votes
0answers
8 views

Is there a way to get links on URLs in a column in phpmyadmin?

In my personal database, I have one column which contains only URLs with scheme (e.g. http://...). For something else which cannot be automated, I need to quickly have a look at all these pages. I'm ...
0
votes
0answers
85 views

PhpMyAdmin unaccessible from Internet

I have read about and tried other configurations of the web-based PHPMyAdmin and they don't seem to work. My environment is a CentOS 6.6 with Mysql server installed and configured before PHPMyAdmin ...
2
votes
1answer
8k 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
1answer
1k 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
223 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 ...
0
votes
1answer
437 views

Apache reverse proxy over Vagrant box - phpmyadmin wrong redirect

I'm running a vagrant box (Debian Wheezy) with port forward NAT networking, redirecting the browser to it through apache2 reverse proxy. Reverse proxy vhost: <VirtualHost *:80> ServerName ...
2
votes
1answer
133 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
1
vote
1answer
180 views

PhpMyAdmin extra authentication - where is the password saved?

Some months ago I set up LAMP on my Ubuntu 14.04 DigitalOcean-server. I also installed PhpMyAdmin with an extra security layer. I have two domains attached to this server. For example1.com/phpmyadmin ...
2
votes
2answers
484 views

Is there a shortcut key to run a query PHPMyAdmin?

I run a lot of queries in phpmyadmin because it has a very nice display compared to mysql command line usage. I find it very inconvenient to always have to click the go button instead of pressing a ...
1
vote
1answer
1k views

Unable to access phpMyAdmin on a LAMP setup on an Azure server

I am trying to install phpMyAdmin on LAMP on Azure. Everything is working properly, I just checked my server .net/info.php. I succesfully installed phpMyAdmin using this command: sudo apt-get ...
0
votes
3answers
2k views

Errors with a phpMyAdmin install on CentOS 7

Well, I was trying to install phpMyAdmin on CentOS 7 (64bit) and this happens. Here is a Pastebin of the output from yum install phpmyadmin because can’t get code thing to work. [root@ftb ~]# yum ...
1
vote
0answers
46 views

Unable to access the PHP myadmin in windows due to the new security feature of xamp

Mine is a windows 7 64 bit machine with xamp v1.8.0,drupal 7.34 installed on the local server. I connect to the sever using the mstsc run command and load the url of the PHP myadmin and it loads ...
-1
votes
1answer
2k views

How to Syncing Offline MySQL db to online MySQL db

I am developing a inventory management web application using php and mysql. This application will runs on server hosting and localhost. while any one server disconnect the internet at the time data ...
1
vote
1answer
1k views

Table name not showing in relation view in phpmyadmin

I have a database named flk_embriodery. It contains two tables. user countries I created user table from phpmyadmin but generated countried table from mysql query. But interestingly countries table ...
-1
votes
1answer
1k views

How do you view the database in phpmyadmin while using Amazon AWS EC2 via SSH?

I am in the process of setting up a new website via Amazon AWS EC2. I typically use SSH in order to connect to the instance and then occasionally I use FileZilla in order to move files into the /var/...
-1
votes
1answer
478 views

Owncloud - where in the SQL database is the email stored?

I am searching and searching but still cannot find it. In what table does owncloud store the email addresses?
0
votes
1answer
889 views

phpMyAdmin used by java application

I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is ...
0
votes
1answer
335 views

How can I change initial login page for phpMyAdmin4?

How can I change initial login page for phpMyAdmin4? I want to add some text to 'Welcome to phpMyAdmin'. Have been looking for file to change but can't find it. Thanks.
0
votes
1answer
1k views

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have this error when trying to connect to my phpmyadmin. I tried all the solutions but nothing works. I changed password in config.inc and cleared cookies, restarted services of wamp but nothing. ...
0
votes
0answers
98 views

ISPConfig - two phpmyadmin versions

I've installed phpmyadmin first and then I configured ISPConfig, which appears to come with a different phpmyadmin version (an older one). How do I run only one of them? EDIT: whenever I go to my ...
1
vote
1answer
81 views

Is it possible to access any databases other than MySQL using phpmyadmin?

I heard that phpmyadmin is a GUI used to access MySQL DB. I wish to know whether any other databases are compatible to work with phpmyadmin.
0
votes
0answers
120 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
1answer
3k views

How to open phpmyadmin on Mac OSX Mountain Lion with XAMPP

How do i access phpmyadmin on my Mac? I heard that use can use localhost/phpmyadmin but it returns server not found. I installed PHP, MySQL and Apache with XAMPP.
0
votes
1answer
595 views

Forcing SSL on phpmyadmin

I couldn't decide which website this question we be on (since I see it almost everywhere) so feel free to migrate. I've set up a self-signed SSL cert on my server to secure my installation of ...
0
votes
1answer
18 views

Adding a column to an imported spreadsheet - PHPmyadmin

I've imported data to phpmyadmin and I need to add a column to create a primary key (called companyID) How do I go about doing this?
0
votes
1answer
642 views

How to remove few tables from a large SQL file?

I have a SQL file with size around 3 GB. So this takes some long time to restore every time when i took recent dump from production. In this one table 'access_log' itself took 2.2 GB which is just a ...
0
votes
2answers
922 views

Ubuntu - Secure PHPMyAdmin in Nginx

I followed the instruction on this site for installing PHPMyAdmin. However, this configuration is for an Apache, and I am using Nginx. I can't find any tutorial online on how to restrict the allowed ...
0
votes
1answer
400 views

How to update PHP and MySQL in SUSE LINUX Release 11.2

I have in a server SUSE LINUX Release 11.2, with PHP Version 5.2.17 and phpMyAdmin 3.3.9, How can I do for update the two elements, I tried with: sudo apt-get update php5 but dont works, says: ...
3
votes
2answers
3k views

phpMyAdmin cannot login - keeps asking for credentials

I have phpmyadmin on my Arch linux box, it is running, so is apache with php and mysql. When I go to http://localhost/phpmyadmin/, it shows the usual login prompt. However, no matter what I enter, ...
0
votes
1answer
125 views

Can't login to local phpmyadmin

Hy, I've just installed MySQL and PHPMyadmin on my OS X Maverics, following this link: http://www.coolestguidesontheplanet.com/downtown/get-apache-mysql-php-and-phpmyadmin-working-osx-109-mavericks ...
0
votes
1answer
2k views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
0
votes
1answer
901 views

mysqli extension is missing in phpMyAdmin on RedHat 5.9 Server

We have installed Apache, PHP, MySQL, and attempted to install phpMyAdmin. When going to phpMyAdmin in the browser, we are presented with "The mbstring extension is missing." We are unable to get ...
-2
votes
1answer
87 views

Secure way to manage mysql through web browser

I would like to offer clients access to their own mySQL database. Is there a secure way of doing this? Is there any way to secure phpmyadmin without using a htaccess password or restricting it to ...
10
votes
1answer
9k views

View existing indexes using phpMyAdmin

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.