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

learn more… | top users | synonyms

0
votes
1answer
114 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 ...
0
votes
0answers
41 views

phpmyadmin export from two tables where data in one column matches?

I'm running MySql server 5.6.2 with phpmyadmin 4.3.7 on a Windows 2012 server. I have one database - "tsl". Within "tsl" I have a table named "apps" and another table named "flat_apps". The "apps" ...
1
vote
0answers
13 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
46 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 ...
0
votes
1answer
49 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
72 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 ...
-1
votes
1answer
44 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
211 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
0answers
109 views

phpMyAdmin + TYPO3 = Error code 200, how to solve?

I'm running a TYPO3 4.5.37 with the phpMyAdmin 4.18.4 plugin installed (both latest versions). TYPO3 itself works perfectly fine and the website, too. But if I click on the phpMyAdmin extension in the ...
0
votes
0answers
20 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
768 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
113 views

borked XAMPP upgrade — any way to rebuild my database if i saved var/mysql folder?

After I upgraded to Mac OS X Yosemite, the mySQL server on my XAMPP install stopped turning on. XAMPP released an upgrade that fixed this. So, I copied and pasted my "htdocs" and "var/mysql" folders ...
0
votes
0answers
34 views

How can I start Xampp Control Mysql Service automatically with Program?

I am working on C# using mysql phpmyadmin server and I am creating application for windows forms. I want this application to start xampp controller itself in background so I don't have to start it ...
0
votes
0answers
40 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
32 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
39 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
46 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
103 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
0answers
40 views

PhpMyAdmin and cake on AWS Ec2

Question - I have Cake PHP installed and phpmyadmin in the same root directory (/var/www/html). Now when I try to navigate to my elastic ip/phpmyadmin I get Cake PHP telling me : Error: ...
0
votes
1answer
16 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
0answers
33 views

How to open PHP myadmin in XAMPP for linux?

I am running Linux Mint 17 (based on Ubuntu), and i have successfully installed Xampp. I would like to now work with MYSQL, so i was wondering how to open the PHP myadmin page in my browser. ...
0
votes
1answer
50 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
0answers
338 views

Installing PHPMyAdmin on AWS EC2

I followed Amazon's instructions http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html to install a LAMP stack on a Micro EC2 instance running Linux. Installation was successful. I am ...
0
votes
2answers
313 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
111 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: ...
0
votes
0answers
105 views

Cannot open http://<myipaddress>/phpadmin

I am able to access localhost or localhost/phpmyadmin using http but not when I replace localhost with my own ip address. What mistake I might be doing? Steps already taken: 1) Changed "Require ...
2
votes
2answers
444 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
91 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
1k 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
289 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
61 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 ...
0
votes
0answers
169 views

Phpmyadmin hide_db hides all databases

I want to hide the information_schema database from users as it has caused confusion. I have the following in config.inc.php: $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Optional: User for ...
1
vote
1answer
1k 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.
0
votes
1answer
32 views

how to delete taggregate_temp_ tables at once?

In MySQL, I have multiple tables named like this: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 ...
0
votes
1answer
211 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'), ...
0
votes
2answers
305 views

phpMyAdmin wrong configuration on Debian

I'm running Debian Sid (headless) with phpMyAdmin 4.2.2deb1. When I log in on phpMyAdmin I see the following message: The phpMyAdmin configuration storage is not completely configured, some extended ...
1
vote
1answer
291 views

Making phpmyadmin accessible over internet

I have XAMPP installed on my Windows XP server. I have port 3306 (mysql) and 80 (apache) on the machine forwarded to 5016 and 5011 on the router respectively. I am able to access the phpmyadmin ...
1
vote
1answer
70 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 ...
1
vote
0answers
391 views

Mysql socket error 2002 on Linux Mint - Access denied

My apache and xampp servers are running on port 2145 and 16443 respectively. sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.2-5... XAMPP: Stopping Apache...ok. XAMPP: Stopping ...
0
votes
1answer
69 views

Setup page for phpMyAdmin not appearing but the domain is

Relative newbie here... EC2 instance installed, apache is running and can see the Test Page for the Apache server I am following the instructions found on ...
1
vote
1answer
33 views

Why would phpMyAdmin be working with 127.0.0.1 blocked?

Newbie with all this. My background provides familiarity with PHP as well as databases... Setting up EC2 and have gotten as far as installing phpMyAdmin with lots of bumps and restarts (and denting ...
0
votes
0answers
109 views

invalid default value in SQL export

I exported a database with phpmyadmin, and am now attempting to import the database with PMA on a different machine, but I'm getting this weird error. What can I try as a solution? Error SQL query: ...
1
vote
1answer
2k 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
66 views

Connecting to remote database via phpMyAdmin - Validation error

I've been trying to connect to a remote MySQL database via local phpMyAdmin, as per explanation by this tutorial. However, I'm not authenticating properly with the database due to the IP address ...
0
votes
2answers
2k views

Configuring PHPMyAdmin to connect to remote database

After Googling the possibility of using PHPMyAdmin to connect to remote databases, I found this article, which confirms that this is supported after a simple config edit. In the article, the author ...
0
votes
1answer
508 views

phpMyAdmin No activity within 1440 seconds; please log in again. Issue

I have installed latest phpMyAdmin on Apache+php+mysql on CentOs. But after sometime of inactivity i am getting No activity within 1440 seconds; please log in again. And redirected to the ...
1
vote
1answer
109 views

phpmyadmin CSV files import and export

When I try to import CSV files in phpmyadmin, I get message in green that says "0 rows" but it is nevertheless a success message. I know my data is correct, as it importing fine on another computer. ...
0
votes
1answer
34 views

Problems with MySQL [Minecraft]

I get an error with MySQL. My servers crash every day having something to do about Java. But this one was different. Error: http://pastebin.com/n2xLY50L Edit: I also have two values put in my ...
0
votes
0answers
78 views

edit one cell in phpMyAdmin and Mamp

I want to ask a question about phpMyAdmin and Mamp. I am not sure if this is the right place. If not please tell me where I should go. Here is the question: If you are in a table > and tab: browse ...
0
votes
1answer
35 views

phpMyAdmin causes computer to restart?

This might sounds crazy, but on windows 8 I tried 3 browsers (Firefox, Chrome, And IE) and each time I went to: http://127.0.0.1/phpmyadmin a message would show up: "your pc ran into a problem and ...