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

learn more… | top users | synonyms

2
votes
2answers
19k views

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

When I try to login to PHPmyadmin I get the following error: phpMyAdmin - Error Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your ...
2
votes
4answers
80k views

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

I understand that I need to log in to wamp server in order to create a database. My problem is that the phpmyadmin page opens without asking me to log in. So, I presume that I am not logged in. If ...
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.
1
vote
1answer
64 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 ...
1
vote
1answer
19k views

how do I install phpmyadmin on windows server 2012 from scratch

how do I install phpmyadmin on windows server 2012 from scratch?? I dont even know where to begin this. I tried but it didn't work out. What else do I need to install in order to make this work? I do ...
2
votes
2answers
489 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 ...
0
votes
1answer
348 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
2answers
1k views

how to insert many similar records in mysql at a time using phpmyadmin?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ('name4','...
0
votes
0answers
176 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
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
99 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 ...
7
votes
3answers
11k views

How can I install PHPmyadmin on Mac Lion using Homebrew

How can I install PHPmyadmin using homebrew, if that possible. I'm using Mac 10.7. I installed Homebrew, and it's working perfectly. I use it to download php 5.4 and mysql. Both are working perfectly,...
0
votes
2answers
66 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 ...
2
votes
3answers
22k views

How to fix the phpmyadmin error “json extension is missing”?

Today i have installed the xdebug packets. After installing them my phpmyadmin and different other softwares aren't working anymore. PhpMyAdmin gives this output: json extension is missing. First ...
2
votes
4answers
23k views

WAMP MySQL Service will not start

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn't starting.... here: and everytime I press "Start/Resume Service", NOTHING happens. I go to my.ini and put in a password.Then ...
0
votes
0answers
55 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. ...
23
votes
4answers
35k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
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 ...
3
votes
2answers
3k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
0
votes
0answers
150 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
274 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 ...
3
votes
1answer
2k views

Chrome phpmyadmin Saved Password not coming up anymore

I'm using Chrome with 2 installs of phpmyadmin (3.3.2deb1 and 2.11.8.1deb5+lenny8). Since about 3 weeks ago, chrome does not remember the saved password anymore and doesn't prompt to save it. Both ...
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 ...
0
votes
2answers
4k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ---------------------------------------...
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
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 ...
2
votes
0answers
953 views

Row is not deleted in PHPMyAdmin

I have a problem deleting a row in PHPMyAdmin. When I click the 'Delete' button to delete the row, at the top it says Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec) SELECT * FROM "...
28
votes
8answers
94k views

How to install PHPMyAdmin on Linux EC2 instance?

I just finished setting up a default Linux EC2 instance and would like to install PHPMyAdmin. I already have Apache and MySQL installed but cannot seem to install PHPMyAdmin. I tried using sudo apt-...
0
votes
1answer
6k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
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
87 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
255 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
87 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 ...
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 ...
2
votes
1answer
135 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. ...
0
votes
1answer
440 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 ...
1
vote
1answer
181 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 ...
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 ...
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
481 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
891 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 ...
1
vote
1answer
246 views

Unable to modify variables phpmyadmin via variables tab (Xampp)

I am quite new to phpmyadmin configuration. I had project where utf8 encoding is needed. What i'm trying to do is to change the variables text/char all into utf8. I changed, yes at that moment the ...