0
votes
2answers
18 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
2answers
38 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
32 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
89 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 ...
-2
votes
1answer
46 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
30 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
15 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
34 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
89 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
50 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 ...
0
votes
0answers
107 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
0answers
35 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
130 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
30 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
106 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
26 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
2answers
193 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
2
votes
2answers
572 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
370 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
40 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
38 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
47 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
178 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 ...
-2
votes
1answer
133 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 ...
0
votes
0answers
20 views

Accidently close tab when running MySQL command

1) I use PHPMyadmin on Chrome to run an UPDATE command but I accidently closed the tab. Is the process still running or terminated? 2) What if I running using Putty and accidently close Putty ...
0
votes
1answer
46 views

creation of accounts for each users in mysql / phpmyadmin

I am planning to create mysql accounts for each of my web devs and build their own databases. I need these devs to have accounts to access their own phpmyadmin where they can manipulate their own sets ...
0
votes
1answer
594 views

Having formatting problems when exporting table from phpMyAdmin

I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format. ...
0
votes
1answer
2k 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 ...
-1
votes
1answer
59 views

phpMyAdmin: Make foreign relation more readable [closed]

I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but ...
0
votes
5answers
75 views

phpMyAdmin - table names

When you have a table called sheep and you would like to call it c what would be the correct way to do this in phpMyAdmin when writing the query
0
votes
1answer
272 views

s accessing mysql database on server from other PCs

I have installed XAMPP on a server PC. I want to access it from other PC through MySQLWorkbench or even access it through server IP and PHPMyAdmin page. I tried configuring the httpd-xampp.conf file ...
1
vote
2answers
2k views

Is there any way to generate DDL SQL statements from database?

Given already created SQL databases, is there any way to generate the DDL SQL statements to recreate the database?
8
votes
3answers
3k views

I can't open phpMyAdmin, get error 301 or 500

I've installed phpMyAdmin, but I can't open it on any browser: I get a 301 redirect(*) if I browse to http://localhost:8080/phpmyadmin. If I add a / to the end of the addres, I get a 500 error status ...
2
votes
0answers
383 views

Row is not deleted in PHPMyAdmin

I am having problem deleting a row in PHPMyAdmin. 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 ...
0
votes
2answers
779 views

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

i am working on windows 7 ..i am using xampp . i restarted my computer then after that when open the mysql yog..then it gives me an error error no 2003 can't connect to mysql server on localhost ...
1
vote
1answer
2k views

phpMyAdmin is showing 403 Forbidden

I have just changed my www folders permission to 777 using this command sudo chmod -R 777 www And now when I try to open phpMyAdmin in browser and it is not opening and showing 403 Forbidden Error ...
2
votes
2answers
5k views

can't login in phpmyadmin and mysql after fresh installation of lamp server and phpmyadmin on ubuntu 12.04 LTS

I am trying to search a solution for this problem, but didn't find a solution. I am getting an error while login in phpmyadmin #1045 Cannot log in to the MySQL server Connection for controluser as ...
0
votes
1answer
501 views

Cannot Login To phpMyAdmin

I'm running a simple LAMP server at home from which I host a personal blog. The server is running Arch Linux, with the latest-and-greatest versions of Apache, MySQL, and PHP. In order to easily ...
1
vote
4answers
1k views

Mac - Better GUI MySQL tool than phpMyAdmin [closed]

I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a ...
1
vote
1answer
642 views

phpMyAdmin 3.4.4 install over MySQL 5.1 database with cookie authentication fails

I can't log into my instance of phpMyAdmin via cookie authentication using Google Chrome. I keep getting bounced back to the login page with a warning about cookies. I'm running Ubuntu 10.04.2 LTS ...
1
vote
2answers
8k 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 ...
3
votes
1answer
2k views

Make the table listing show entire fields

I'd like to know if a way exists to make PHPMyAdmin show entire fields in the table browsing tab. Right now I have a TEXT field and I can never read the entries in their entirety. How can I do that?
1
vote
2answers
574 views

Convert a table into text file in phpmyadmin

I am using phpmyadmin on ubuntu to import a table, and I used this command select * from questionresults into outfile 'training.txt' to convert the table into text file, but I cant find where ...
0
votes
2answers
644 views

phpmyadmin or other mysql gui - edit whole table from one screen

Let's say I have table in database. I'd like to be able to view all data from this table and be able to edit every field from single screen. I tried to do this in phpmyadmin but I'm not sure how... I ...
-1
votes
1answer
2k views

Restoring postgreSQL backup to MySQL

How to restore postgreSQL backup file to MySQL server? I don't have postgreSQL server on my system. I have only MySQL server
14
votes
3answers
15k 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.
1
vote
0answers
541 views

Cannot create database as root in phpMyAdmin

I just got my VPS. I log in to phpMyAdmin as the root but I cannot create a database. I can't even see a link for this. I also want to change other user's permissions, but I cannot find out how to do ...
0
votes
1answer
580 views

Problem with creating table on phpMyAdmin database

I'm running a phpMyAdmin Database on my web package on a 1and1-hosted server. I've managed to set up a database in the control panel, have uploaded all to root/phpmyadmin and changed the ...
4
votes
3answers
49k views

How can I start phpMyAdmin?

I have just installed phpMyAdmin on my Ubuntu (using sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin). I think installation went OK. So, how can I start the phpMyAdmin now? I ...