Tagged Questions

0
votes
1answer
14 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
0answers
15 views

PHPMyAdmin removes the primary key for MySQL table

First of all, I'm sorry for the ambiguity in this question. Because I don't know what the exact problem is, so I'm hoping somebody here faced the same issue and will be able to know what I'm doing ...
-1
votes
1answer
20 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
27 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
34 views

Problems 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
188 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
477 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 ...
1
vote
0answers
79 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
302 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
484 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 ...
0
votes
1answer
107 views

Is there an online, public MySQL database manager? [closed]

I'm looking for a site/web application that acts as a MySQL database manager (like phpMyAdmin), that is public for everyone to use by inserting their server's host and MySQL credentials. I know I have ...
2
votes
2answers
2k 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
0answers
141 views

Need Step by Step to Restore MySQL databases via phpmyadmin 3.4.10.1

Am doing some testing of a web app in multiple locations and have a MySQL backup script that runs regularly on the live data. I want to restore this to another server and have moved the respective ...
0
votes
1answer
165 views

Connecting to my new server [closed]

I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database. Now everything is done. But where can I find ...
0
votes
1answer
268 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
672 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
484 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
4k 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
673 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?
0
votes
2answers
327 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
492 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
2answers
1k 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
4
votes
2answers
8k 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
0answers
486 views

cannot create database as root in phpmyadmin

I just got my VPS, i login phpmyadmin as root but i cannot create database, i cant even see a link for this. I also want to change other user's permissions but i cannot find out how to. any help ? ...
0
votes
1answer
386 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 ...
2
votes
2answers
596 views

Do you know any MySQL (web based) online clients? [closed]

Do you know any online (web based) MySQL clients ? I mean an application that allows me to login to a remote MySQL server. (A third-party web hosted installation that allows me to specify the IP, ...
3
votes
3answers
26k 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 ...
0
votes
3answers
1k views

phpmyadmin import database table from google spreadsheet

I'm managing a small website, which allows people to register as members. Previously I used a google form to manage member registration, but now as the number of users becomes quite big I am ...
2
votes
1answer
2k views

Export MySQL database structure

I have a MySQL database. I would like to export the tables/structure to a script. I don't need the data, just a script to create all tables I have. I have access to PhpMyAdmin.