The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
5 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. ...
-5
votes
0answers
12 views

Plz help me i want tyo know the solution of my mysql query [on hold]

Write a mysql query where condition is that...A employee table in which the so many employee and some employee salary between 5 to 10, I want that on date 31/12/2013 which employee salary 5 to 10 ...
0
votes
1answer
13 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
21 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
33 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
26 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
37 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 ...
0
votes
2answers
45 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
38 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
165 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
52 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
47 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
46 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 ...
0
votes
1answer
18 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
20 views

how to delete taggregate_temp_ tables at once?

In my SQL I have multi tables like: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 taggregate_temp_1364810160 ...
0
votes
1answer
38 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
118 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
66 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
24 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
155 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
30 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
27 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
38 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
262 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
39 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
184 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
82 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
45 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
29 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
38 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
34 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 ...
0
votes
2answers
271 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
1answer
52 views

Can I remove the “New table” button from the Navigation Tree in PHPMyAdmin (4.0.9)?

Every database listed in the left-hand pane has a "New" button for creating a new table, i.e. the first item in this tree. It takes up room and I don't need it. There doesn't seem to be a config ...
2
votes
2answers
754 views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
0
votes
1answer
391 views

Using PHPMyAdmin or MySQL Workbench, how to search across 10 tables and return all records matching a specific criteria?

This seems like it should be so simple but I'm having a hell of a time solving it. I have 10 tables named in the following way: b1_settings b2_settings ... b10_settings I need to search across all ...
0
votes
1answer
44 views

Debian: Login to mysql doesn't work

So I rented this server with Debian 7, and wanted to install a webserver, and followed the following tutorial: http://www.howtoforge.com/ubuntu_debian_lamp_server And I'm now stuck at the PHPMyAdmin ...
0
votes
0answers
318 views

Main php.ini file to change file size for phpmyadmin in Centos 6.4 with ISP Config 3 is not working

Hi I'm trying to upload a backup database via phpmyadmin. But the max upload size is 2mb. I changed php.ini file and restarted the apache but it does not work. the ini file that I changed is in ...
0
votes
3answers
23k 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
0answers
42 views

phpMyAdmin only shows two databases

Having a weird problem where mysql is showing multiple databases when I go SHOW DATABASES; I get 5 results. When I go to phpMyAdmin I only get two: information_schema and test. If you could ...
0
votes
0answers
276 views

Enable WAMP/phpmyadmin designer/relationview

I am using wamp 2.4e 32bit on windows8 Article 1, Article 2. 2nd one seemed better one to me. I have successfully created phpmyadmin database as instructed. Also I think the path where I am puting ...
1
vote
2answers
248 views

How do I access phpmyadmin?

I get a 403 Forbidden when I try to access my phpmyadmin. I installed it from the repository and choosed apache2 in the installation progress. The symlink phpmyadmin.conf in conf.d to apache.conf in ...
0
votes
0answers
50 views

Unable to install phpmyadmin on LAMP

I am trying to install phpmyadmin on LAMP on DigitalOcean. Everything is working properly, just checked here :- http://testpanda.com/info.php but when I try to install phpmyadmin using this command ...
-1
votes
1answer
213 views

How to quickly insert large amounts of days into MySQL? [closed]

I'm looking for a way to insert a ton of data manually into a MySQL table in the most efficient way. The source data currently lives on a web page (outside my control and so no access to the ...
0
votes
0answers
165 views

Can't access phpmyadmin even though IP is white listed? CentOs 6

So sort of out of the blue, I can no longer access phpMyAdmin, it returns the 403 error in which people who are not white listed should get. I checked my conf files for the IP's to ensure it was not ...
0
votes
1answer
115 views

Can't login into phpMyAdmin with Safari

I have this weird problem that I can't login into phpMyAdmin with Safari. With every other system/browser I can login just fine, but not with my Safari browser. I tried to empty cache, history, etc., ...
2
votes
0answers
834 views

CentOS 5.10 Yum Packages won't update/upgrade

I've just used yum to install PhpMyAdmin and it installed version 2.11.11.3-2.el5 which is completely out of date since version 4 is out. I've tried running yum update phpmyadmin but I receive No ...
-2
votes
1answer
147 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
-1
votes
3answers
3k 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
2answers
820 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 ...
1
vote
0answers
3k 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 ...