Questions tagged [phpmyadmin]
A web application that allows users to manage a MySQL database.
79
questions
8
votes
5
answers
67k
views
How to login as another user in phpmyadmin
I installed phpmyadmin in Win7, and if I type http://localhost/phpmyadmin/index.php in the browser, it will log in phpmyadmin as root user by default.
I created a new user but still there's no login ...
5
votes
3
answers
2k
views
phpMyAdmin: Remove Table Drop and Empty Controls
I'm not sure this is the place to post this as there are very few questions tagged phpMyAdmin; I thought of stackoverflow, but it's not really programming. In any case, mods should feel free to move ...
4
votes
4
answers
27k
views
No databases showing in phpMyAdmin
My website is hosted in shared hosting service and is working fine with updated news stored in MySQL database. To manage the database of website, I install phpMyAdmin in a sub-folder with the same ...
4
votes
2
answers
22k
views
Add more than one host to user login privileges in phpMyAdmin
As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames.
How can I accomplish this?
4
votes
2
answers
1k
views
Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars
While exporting Magento database from xampp (using PhpMyAdmin).I am getting error .sql file. and also getting a warning message during export start.
Warning: a form on this page has more than 1000 ...
4
votes
1
answer
2k
views
How to create user in phpmyadmin to connect two servers?
IP my Website: 192.168.19.33 and IP Database server is: 192.168.19.41.
How to create user account in phpmyadmin for the connection between the two servers?
And how to edit this setting:
...
4
votes
1
answer
620
views
phpMyAdmin no longer notifying me of updates
I'm used to seeing phpMyAdmin notify me of updates fairly frequently so when a few weeks went by without any notifications I headed over to the official site to discover that my installation was out ...
4
votes
1
answer
14k
views
Phpmyadmin error 403 - No matching DirectoryIndex (index.html) found, and server-generated directory index forbidden by Options directive
I installed phpmyadmin over a year ago.
I use MAC OS 10.10.4.
I don't use Xampp.
My installation Folder is /Library/Webserver/Documents/phpmyadmin.
Now when I try to access phpmyadmin with that url,...
3
votes
2
answers
487
views
Does Google Show Phpmyadmin URL of site in search result
I've extracted phpmyadmin in public folder, and named it phpmyadmin-012940912830
Now I can access it using, mysiteurl.com/phpmyadmin-012940912830, I don't want anyone to know about this URL but what ...
3
votes
4
answers
10k
views
PhpMyAdmin keeps redirecting to login screen
I'm having troubles logging in to PhpMyAdmin. When I press "login" after typing in my credentials, it just keeps going back to the login screen. I could login perfectly a few days ago. I don't know ...
3
votes
3
answers
10k
views
Accessing PHPMyAdmin via URL (without cPanel)
I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root.
I cannot seem to be able to make another account for cPanel either, and research indicates this ...
3
votes
2
answers
485
views
Problems with phpmyadmin
I already worked a lot with wampserver but it's the first time i have a problem with it.
After I downloaded it wanted to create a database in phpmyadmin, and then it says:
"Forbidden. You don't ...
3
votes
1
answer
3k
views
debian phpmyadmin - Call to undefined function __()
I recently upgraded my debian installation from wheezy to jessie. Now I get only blank pages when accessing phpmyadmin.
The apache log says:
Fatal error: Call to undefined function __() in /usr/...
3
votes
2
answers
278
views
is there a program that performs CRUD functions with phpMyAdmin?
I need to enable a client to be able to be able to create, update and delete items from a mysql database, but it'll be too confusing for him to do it via phpmyadmin. Is there a program for users to ...
3
votes
0
answers
82
views
How to configure phpMyAdmin settings on Virtualmin VS creation
I am having an issue with Virtualmin, I can create virtual servers and create databases fine, although when I access phpMyAdmin, it only shows one database, no matter how many I add.
I found some ...
3
votes
0
answers
3k
views
Can't log in to phpMyAdmin after removing MySQL root password
I get this messege:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I tried changing the password in phpMyAdmin config.inc.php
from root to '' but all I got was
Cannot connect:...
2
votes
2
answers
1k
views
phpmyadmin and stored procedures
I'm not able to view subprocedures in Phpmyadmin. I have created a sub procedure via the execute query option. Is there an option to list the subprocedure and edit them.
2
votes
2
answers
2k
views
Sync MySQL databases?
I'm a first-time XAMPP user and was wondering what is the method of making sure my local test MySQL database is synced with the live remote database. Or, how do I 'push' the local database to the live ...
2
votes
3
answers
13k
views
How to find out what is causing "Entry Process" limit?
We're using an OpenCart 1.5.5.1 custom theme for our site.
Well it hasn't been smooth sailing for us and we are facing problem after problem. So far the gist of it is we're currently on a business ...
2
votes
1
answer
3k
views
Trouble creating new MySQL user/database with PHPMyAdmin
I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database.
I now want to add a new user and new database. So, I went to the ...
2
votes
2
answers
845
views
Phpmyadmin http password security
Is my password sent unencrypted when using Phpmyadmin through http?
If not, is there any downside using http compared to https?
2
votes
5
answers
13k
views
How do I access PHPMyAdmin after install in Ubuntu?
I installed Apache and then PHPMyAdmin on my Ubuntu server, but I have not been able to access PHPMyAdmin at http://localhost/phpmyadmin/. http://localhost is working however.
2
votes
2
answers
713
views
PhpMyAdmin - Changing charset
How may I change the database/Tables/Attributes charset using PhpMyAdmin (No SQL statement, only hand-and-mouse actions) ? I only see the option for the Collation (inter-classement).
2
votes
2
answers
15k
views
Virtual host not working in Windows 7 XAMPP
I am using Windows 7 and XAMPP. I want to create a virtual host so I added
127.0.0.1 myawesomeproject
to my hosts file (C:\Windows\System32\drivers\etc\hosts) like this:
# Copyright (c)...
2
votes
1
answer
238
views
PHP - How to Backup and Move Wordpress Blog Website to different directory on the same host
I setup a blog for development purposes on the *.com/a/ directory and now want to move it to the root directory *.com on the same host.
How do I Backup and Move the Wordpress Blog Website to the ...
2
votes
1
answer
448
views
How to access cPanel for a website hosted by FastHosts
I have picked up a website from a client, that a previous web developer had made. Its been moved to be hosted on fast hosts. However, I can't seem to access the CPanel.
I want access to the ...
2
votes
3
answers
7k
views
How do I replace a MySQL Database?
I created a database on the host server using PHPMyAdmin.
I exported the database for local development and have since added data and changed the schema slightly.
How can I replace the database on ...
2
votes
1
answer
172
views
Phpmyadmin - How to let users create and manage their own databases without allowing them to see other databases
In PhpMyAdmin I want to allow certain users the ability to create and manage databases without having to manually give them permission to every database they need. I've noticed when giving a user the ...
2
votes
1
answer
2k
views
php.ini changes not taking effect in Siteground
I am importing an sql file for a magento website, however, It gives me this error:
Unknown: Input variables exceeded 1000. To increase the limit change
max_input_vars in php.ini
Then I modified ...
2
votes
1
answer
555
views
How to download a dump of the mysql database from the server's /root/
I have tried to install Let's Encrypt free SSL and somehow I messed up my whole server.
I have 2 websites on it, a Wordpress blog and some really small website that I use for practicing php. Anyway, ...
2
votes
1
answer
2k
views
phpMyAdmin can't find tmp directory
I have a site hosted with BlueHost. I need to upload a rather large SQL file to the tmp directory so I can run an import.
However, phpMyAdmin is giving me the following error:
The directory you ...
2
votes
1
answer
116
views
How do I solve this error when importing MySQL databases into phpMyAdmin?
As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their ...
2
votes
2
answers
138
views
Spambots looking for phpmyadmin and more
I inherited a couple of sites that send the webmaster an email with each 404 error. I get a smattering of errors each day, but there are times when I'll get dozens, even hundreds, of errors from these ...
2
votes
1
answer
522
views
Error 500 on phpMyAdmin via https from "self-signed certificate"?
I have used Cpanel to generate and install a self-signed certificate for HTTPS and now that I have installed phpMyAdmin once I access phpMyAdmin via HTTPS it throws out an error 500 message.
Why is ...
2
votes
0
answers
134
views
Network error when exporting from localhost in phpMyAdmin
I am managing a database on AWS but I am doing that with the latest Docker image (of phpMyAdmin) running on the localhost. Most things work well but I get the message "Network error" when I ...
2
votes
0
answers
680
views
"mod_fcgid: process graceful kill" and 500 error each time a large SQL file is uploaded to phpMyAdmin [closed]
This is what I'm getting when I tried to upload 19MB SQL file to phpMyAdmin.
This is part of my php.ini most important config:
php_value session.gc_maxlifetime 10800
php_value max_input_time ...
2
votes
0
answers
357
views
phpMyAdmin - Cannot login, Either Forgot Password or issue with No Password [closed]
I have just used phpMyAdmin on my local machine for the first time in about 6 months. I am using localhost:8080. I thought I had no password, however when it asks me to log in I put:
username: root
...
2
votes
0
answers
233
views
phpMyAdmin bzip2 for exports
MySQL version = 5.5.39, PHP Version = 5.4.32, on Apache/2.2.3 (CentOS)
I was using and old phpMyAdmin ver 2.11.9.6 and bzip2 was successfully being used for my exports on a daily basis. However, I ...
1
vote
4
answers
934
views
Is it possible to have a better sql editor for phpMyAdmin? [closed]
I am studying database systems and using MySQL and phpMyAdmin.
The editor that comes with phpMyAdmin is plain editor that does not highlight any special syntax like for example: gEdit in ubuntu.
Can ...
1
vote
3
answers
5k
views
import.php parameter missing?
Whenever I try to delete or update any of my tables in phpMyAdmin I receive the following error:
1.import.php: Missing parameter: import_type.
2.tbl-alter.php missing parameters:field
I have looked ...
1
vote
2
answers
8k
views
How to export query result in a csv file from phpmyadmin
I am running a query in PHPMyAdmin. The query is fine. it's showing the correct result.
I want to export that result in a CSV file. It's not on the local server. It's on the webserver
This is my ...
1
vote
2
answers
727
views
What are spiders trying to achieve on my site by fetching lots of non-existant urls such as various versions of phpMyAdmin?
I've recently set up a build server that compiles Java source on Github webhooks. I created a public page for downloading latest .jars with a top level domain and I'm logging requests to it. What are ...
1
vote
1
answer
556
views
How to deploy a single HTML file to static hosting and have it show up for requests to my domain
Yes, the title is right. I would like to use a completely static HTML file as a website.
Well, I must confess I have absolutely zero knowledge in this area.
My provider is using phpMyAdmin and sFTP. I'...
1
vote
1
answer
687
views
How can I edit the php.ini folder on shared hosting (in /etc/php7/)?
Using this simple script (<?php phpinfo(); ?>) reveals me that my php.ini file is located in /etc/php7/php.ini folder.
However, my hosting company's master ftp user account does not have an ...
1
vote
1
answer
87
views
Moving Website From CMS
I have recently had a website created for me by an IT company. The problem is that i am being charged extortant amounts of money to change minor things. They have charged me to a create a small CMS ...
1
vote
1
answer
411
views
Non-existent tablespace when importing MySQL from phpMyAdmin
I usually export a Drupal database from one instance of phpMyAdmin to another on a different server without any issues but lately I have been getting the error when I import:
#3510 - Tablespace ...
1
vote
2
answers
1k
views
Can I use the Laravel Database Framework without using all of Laravel?
I work at a company with a custom PHP framework we have built over the years. For the most our custom framework suits our needs and includes almost everything Laravel offers, however, our database ...
1
vote
2
answers
259
views
Error configuring phpmyadmin
After installing the configuration began, however I kept getting this message saying:
An error occurred while installing the database:
│ ...
1
vote
1
answer
582
views
phpMyAdmin unexpected T_OBJECT_OPERATOR error
I tried to install phpMyAdmin on a customers webserver. Suddenly I get this error:
Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /homepages/29/d104628985/htdocs/*****-*****/phpMyAdmin/...
1
vote
1
answer
4k
views
MySQL and SQL inserting data into JavaScript variable! [closed]
I have a javascript file that has the variable named locations, with some data in quotes for example, 'name', '123 lane', and etc. I want the variable to get data from a database and not the plain ...