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

learn more… | top users | synonyms

-1
votes
0answers
7 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
3answers
51k 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
4k 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 ...
2
votes
1answer
25 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
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
3answers
8k 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 ...
1
vote
1answer
17 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 ...
0
votes
0answers
19 views

4.3.12 version of phpmyadmin Can not open/view a table

Upgraded to the latest version of phpmyadmin (4.3.12) and now one table in a database won't open. I get a 500 error. The other tables I have tested all open. Using latest version of MAMP on a Mac. ...
1
vote
1answer
59 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 ...
21
votes
8answers
63k 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 ...
0
votes
1answer
403 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
60 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
22 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
152 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
126 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
103 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
85 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?
4
votes
3answers
6k 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 ...
0
votes
1answer
381 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
81 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 ...
2
votes
1answer
7k views

WAMP - phpMyAdmin trouble with password, #1045 - Access denied for user 'root'@'localhost'

I've been playing around with WAMP so far I have succeeded in making a password through cmd.exe for mysql: mysqladmin -u root -p password "newpassword" <-- I used this command on Windows 7. ...
0
votes
0answers
215 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
1answer
33 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
0answers
27 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
837 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
123 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
41 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
47 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
37 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
46 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 ...
1
vote
2answers
1k views

Wamp's localhost taking so much time on opening

I have following configuration for WAMP on local machine Windows 7. When I try to open localhost from WAMP Notification icon, it's taking so much time (around in minutes). Even phpmyadmin is taking ...
0
votes
1answer
85 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
150 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
45 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
1answer
65 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
35 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
0answers
356 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
1answer
135 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
2answers
368 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
0answers
114 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
560 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
94 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 ...
14
votes
3answers
21k 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
1answer
383 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
63 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
195 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 ...
2
votes
1answer
2k 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
263 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'), ...