Questions tagged [phpmyadmin]
A web-based PHP utility used to manage MySQL databases on a server.
211
questions
43
votes
4
answers
36k
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,005
39
votes
4
answers
94k
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,603
35
votes
12
answers
153k
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 apt-...
- 2,287
23
votes
2
answers
71k
views
Where is the PHP log file located on Mac OSX?
I am having issues with phpMyAdmin on my Mac. I cannot seem to connect to the local MySQL server. When I try to log in I get the following message
Cannot start session without errors, please check ...
- 2,287
16
votes
2
answers
29k
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.
- 1,651
15
votes
6
answers
25k
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 perfectly,...
- 253
15
votes
3
answers
100k
views
How can phpMyAdmin be restarted after /etc/phpmyadmin/config.inc.php is changed?
How can phpMyAdmin (running on Ubuntu 10.04) be restarted after the /etc/phpmyadmin/config.inc.php file was changed?
- 1,377
11
votes
7
answers
111k
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 go ...
- 460
8
votes
3
answers
9k
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 ...
- 6,964
7
votes
4
answers
18k
views
"login" to phpMyAdmin via different users
I want a non-techie (marketing/sales) to have access to the data I manage regularly via phpMyAdmin:
without any ability to alter/insert/delete
without me having to build a special database-viewer-app
...
- 211
6
votes
4
answers
238k
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 ...
user3159862
6
votes
2
answers
24k
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 ...
- 1,019
5
votes
2
answers
17k
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?
- 689
5
votes
3
answers
91k
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 ...
- 505
5
votes
5
answers
87k
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 ...
- 151
4
votes
2
answers
7k
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, ...
- 318
4
votes
2
answers
4k
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 ...
user317572
3
votes
4
answers
32k
views
How to fix the phpmyadmin error "json extension is missing"?
Today i have installed the xdebug packets. After installing them my phpmyadmin and different other softwares aren't working anymore. PhpMyAdmin gives this output: json extension is missing. First ...
- 163
3
votes
1
answer
6k
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 ...
user176344
3
votes
2
answers
27k
views
Completely removing apache + phpmyadmin + php from Ubuntu?
I am trying to completely remove apache + phpmyadmin + php from my Ubuntu operating system. For phpmyadmin i tried
sudo apt-get autoremove phpmyadmin
but the files were still in the /etc/ folder. ...
user1411893
3
votes
2
answers
4k
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 ...
- 230
3
votes
2
answers
11k
views
I can't login in my laravel application
So I was working with a Laravel application and something went wrong, so I wanted to charge an early backup version of it. The application is from the company I'm currently working for and I was ...
- 31
3
votes
1
answer
42k
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 ...
Eric Pierce
3
votes
1
answer
3k
views
Chrome phpmyadmin Saved Password not coming up anymore
I'm using Chrome with 2 installs of phpmyadmin (3.3.2deb1 and 2.11.8.1deb5+lenny8). Since about 3 weeks ago, chrome does not remember the saved password anymore and doesn't prompt to save it. Both ...
- 117
3
votes
1
answer
2k
views
Phpmyadmin will not allow empty password
I am running Ubuntu 11.04 and I installed phpmyadmin(version 4:3.3.10-1). But when I try to use phpmyadmin, I get the error message as
Login without a password is forbidden by configuration (see ...
- 149
2
votes
2
answers
20k
views
How can I create an ERD for my phpmyadmin database?
Is there a way I can create an Entity Relationship Diagram for my PHPMyAdmin database?
- 131
2
votes
1
answer
408
views
I cant access my website that I hosted in home "Apache24" from internet
I have Apache2.4 server in home running MySQL and PHPmyadmin on windows 7 home edition.
Everything work great from inside the network but if I try to access the website from outside "internet" it ...
- 831
2
votes
1
answer
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.
- 277
2
votes
2
answers
15k
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 ...
- 133
2
votes
1
answer
10k
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.
...
- 243
2
votes
1
answer
705
views
Disable 2FA for phpMyAdmin through terminal
I set up 2FA for logging into phpMyAdmin but the token was deleted from my phone. Now I can't log into my database because it's requiring a code that I no longer have access to.
I've accessed mysql ...
- 21
2
votes
1
answer
4k
views
Phpmyadmin error 500 - can't load anything
I was trying to do a right join of two tables, but it seems like it was too much information or the syntax was wrong and then the page froze so I closed out of it. But when I tried to reload ...
- 21
2
votes
1
answer
399
views
phpmyadmin login with mod_rewrite rule
I have set up docker infrastructure with LAMP and phpmyadmin installed.
Based on the domains Apache is redirecting request to specific directory what produce an error in phpmyadmin:
Failed to set ...
- 31
2
votes
1
answer
33k
views
You don't have permission to access /phpmyadmin on this server
I have installed wordpress on a CentOS 6.6 server, everything works fine, WP, mysql etc but I cannot access the http://MY_IP/phpmyadmin page to import DB as I get:
You don't have permission to access ...
- 139
2
votes
1
answer
2k
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.
...
- 81
2
votes
1
answer
4k
views
phpMyAdmin cookie key and temp dir errors in fresh installation
Running Alma Linux 9 with Apache.
Just performed yum install phpMyAdmin.
When I login mydomain.com/phpMyAdmin I get 2 warnings.
The $cfg['TempDir'] (/var/lib/phpMyAdmin/temp/) is not accessible.
So ...
2
votes
0
answers
168
views
Where is the phpMyAdmin of XAMPP mac version?
I installed the XAMPP in my Mac, but I can not find
I can not find phpMyAdmin entrance, who can tell me where is it?
EDIT-01
I tried use the url: http://localhost/phpMyAdmin/
but there is no path.
...
2
votes
1
answer
3k
views
PyMySQL refusing to install on Raspberry Pi
I have tried every answer I can find to install PyMySQL for example see below:
sudo pip install PyMySQL
Downloading/unpacking PyMySQL
Downloading PyMySQL-0.7.11-py2.py3-none-any.whl (78kB): 78kB ...
- 21
2
votes
0
answers
1k
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 ...
- 121
2
votes
0
answers
1k
views
PhpMyAdmin keeps refreshing automatically on Chrome in Ubuntu?
When I log in to it (running on localhost) it keeps refreshing like crazy. It works alright in firefox though.
Anyone had this problem before?
- 173
2
votes
0
answers
2k
views
Row is not deleted in PHPMyAdmin
I have a problem deleting a row in PHPMyAdmin. When 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 "...
- 131
1
vote
2
answers
2k
views
phpmyadmin wont work on fresh ubuntu 12.04 vb setup
I regularly set up virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed:
1)vb guest additions no longer allow ...
- 528
1
vote
4
answers
2k
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 ...
- 811
1
vote
5
answers
4k
views
Centos - PhpMyAdmin showing blank screen
I have just installed PhpMyAdmin, and when i try to access it it just shows a blank screen. I suspected this is because i followed a tutorial on how to secure php and disabled multiple settings, so i ...
- 117
1
vote
1
answer
7k
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 ...
- 143
1
vote
1
answer
4k
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 ...
- 111
1
vote
2
answers
19k
views
How to change user password in phpmyadmin?
Something strange happened and I am lost how to fix it.
I own a mail service of which I change the admin password every 6 months. 2 days ago I changed it like always, so i wanted to login again and it ...
- 23
1
vote
1
answer
138
views
Where can I find database backup files?
Is it possible to find a database backup within phpMyadmin or are backup files always stored locally on a pc?
- 11
1
vote
1
answer
3k
views
pmyAdmin how to overcome 2Mb import limit?
I try to import my database tables to local XAMMP dev computer. But i keep hitting 2MB phpMyAdmin limit (Max: 2,048KiB). I try to set all limits to php.ini without luck. So stypid question how i ...
- 13
1
vote
1
answer
4k
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 ...
- 143