Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [phpmyadmin]

A web application that allows users to manage a MySQL database.

Filter by
Sorted by
Tagged with
3 votes
0 answers
34 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 ...
user avatar
1 vote
0 answers
64 views

#1044 - Access denied for user 'cpses001'@'localhost' to database 'test_db'

I have purchase i hosting with cpanel in godaddy and I am migrating a WordPress site, but the problem when I am trying to import database it gave me this error #1044 - Access denied for user 'cpses001'...
user avatar
  • 11
1 vote
0 answers
41 views

PhpMyAdmin session is closed after 1440 seconds

Adding this to config file is supposed to avoid it $cfg['Servers'][$i]['LoginCookieValidity'] = 2592000; Now checking cookies I can see the one named pmaUser-1 expires on March 21, that's correct. ...
user avatar
  • 111
0 votes
0 answers
13 views

Joomla admin log in denied

I moved my site from wordpress to Joomla. I created account and was working fine. I tried to log into admin few days later but now my credentials arent being accepted. tried retrieving username and ...
user avatar
  • 1
1 vote
1 answer
75 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 ...
user avatar
1 vote
0 answers
277 views

mysqli_connect() & GoDaddy (New Versions of PHP) [closed]

I am using GoDaddy to host my website and it says in php that I have a Fatal error: Uncaught Error: Call to undefined function There is a problem when I use "mysqli_connect()" function in ...
user avatar
  • 121
2 votes
1 answer
40 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 ...
user avatar
0 votes
1 answer
369 views

Unable to export query result from PHPMyAdmin

I want to export query result in to CSV file from PHPMyAdmin How to do that? See the below picture. Normally I can see the option to check all, edit and delete rows. But when I run this query ...
user avatar
  • 103
0 votes
2 answers
4k 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 ...
user avatar
  • 103
2 votes
0 answers
495 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 ...
user avatar
1 vote
1 answer
562 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 ...
user avatar
1 vote
2 answers
360 views

Configuring phpmyadmin on nginx server for laravel project

I have been trying to install phpmyadmin on the nginx server for laravel project, i have installed the phpmyadmin and setup the symlink to point /var/www/laravel/phpmyadmin. When i am trying to ...
user avatar
0 votes
1 answer
111 views

Limit a phpmyadmin user login to certain records [closed]

I have one database with a few phpmyadmin users created how do I limit each user to see just data meant for that specific user. So user 1 will only see records with area code 082, user 2 will only ...
user avatar
  • 3
0 votes
1 answer
568 views

Accessing phpmyadmin on ec2 leads to "This site can’t provide a secure connection"

i run a single aws ec2 instance (apache2) behind an elb which gives me a free ssl cert from amazon. I have redirected all port 80 traffic to 443 in config and everything runs smoothly. But, when i ...
user avatar
  • 211
0 votes
1 answer
969 views

phpmyadmin Error on GoDaddy shared hosting - Script timeout passed, if you want to finish import, please resubmit the same file

I have a database named A. I want to export it, and import it to a new database B. I exported the A, no issues. While trying to import to the new database B, I faced the following error: Script ...
user avatar
  • 410
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 ...
user avatar
2 votes
0 answers
340 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 ...
user avatar
  • 143
2 votes
1 answer
332 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 ...
user avatar
1 vote
0 answers
70 views

PHP database information in a table that can be displayed on a website [closed]

Hey guys i just want to put the information from the database into a table which i can display on a website but i have no idea how to do it. <?php include 'database_conn.php'; // make db ...
user avatar
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: ...
user avatar
  • 181
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 ...
user avatar
  • 131
1 vote
2 answers
235 views

Error configuring phpmyadmin

After installing the configuration began, however I kept getting this message saying: An error occurred while installing the database: │ ...
user avatar
2 votes
1 answer
503 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, ...
user avatar
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 ...
user avatar
  • 357
2 votes
0 answers
195 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 ...
user avatar
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 ...
user avatar
0 votes
3 answers
795 views

Allow Link access to only one database

I have a hosting account where we have multiple domains hosted and many of them have their own database. Coming to question, Can I share access to particular database on phpmyadmin to a person who ...
user avatar
3 votes
1 answer
2k 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/...
user avatar
2 votes
3 answers
5k 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 ...
user avatar
  • 185
1 vote
1 answer
568 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/...
user avatar
  • 11
0 votes
1 answer
310 views

Preventing phpMyAdmin hacks

I recently saw an unexpected error in my error log, and upon investigating, found it repeated many times. What are the deviants trying to accomplish, and is there any risk of them accomplishing it. [...
user avatar
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,...
user avatar
4 votes
1 answer
570 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 ...
user avatar
  • 141
3 votes
2 answers
426 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 ...
user avatar
1 vote
1 answer
3k 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 ...
user avatar
1 vote
2 answers
3k views

APACHE2: avoid https:// REDIRECT to open phpmyadmin

I have a site https://example.comto ensure that all users go to the https:// I set up a redirect with APACHE (on the default.conf) as followed: <VirtualHost *:80> ServerName example.com ...
user avatar
  • 135
1 vote
1 answer
50 views

Not able to configure opencart in lap

I downloaded opencart 2.0.1.1 and have wampserver. I pasted upload file in wamp server and while trying to run it, I don't know what details sholud be filled in third step. That is, what is database ...
user avatar
  • 121
1 vote
1 answer
4k views

How do I recover WordPress page content from MySQL database?

I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, etc......
user avatar
  • 593
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 ...
user avatar
  • 616
1 vote
1 answer
2k views

Zpanel phpmyadmin lost password

I am moving my websites with cPanel management to a new VPS (more cheap and powerful) with zPanel management (the 10.1.1 version, apparently without huge security holes) But unluckily, I lose all ...
user avatar
1 vote
2 answers
723 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 ...
user avatar
  • 111
2 votes
1 answer
92 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 ...
user avatar
2 votes
3 answers
12k 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 ...
user avatar
  • 21
0 votes
1 answer
815 views

Error while importing .sql file in phpMyAdmin

Getting error while importing .sql file in phpMyAdmin please help. Error SQL query: CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) ...
user avatar
0 votes
1 answer
98 views

Allow other people to upload to my home web server (inc mysql)

Apologies if this is on the wrong place. I've set up a web server at home, it's basic and is currently running using xampp, I plan on replacing it with an old mac g5 soon and mamp or individual ...
user avatar
  • 135
1 vote
1 answer
48 views

Not able to see databases in symlinked folder

I created a folder on my Dropbox and then symlinked it to both of my computers that I use for development. The folder is working correctly and I can see all the files in it from both computers. The ...
user avatar
2 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 ...
user avatar
  • 1,329
0 votes
2 answers
2k views

Cannot log in to phpMyAdmin with users account: Get root override message

I am trying to access phpMyAdmin but I get: "You are logged in with the root, or reseller's password" message, even though I am logged in using the users account (not my root account). I have tried ...
user avatar
  • 1,329
2 votes
2 answers
471 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 ...
user avatar
1 vote
1 answer
437 views

How to access phpMyAdmin with Hosting Controller?

I am trying to update a site for a client. All the login info they have given me is for something called Hosting Controller. I've never seen it before but it seems like cPanel. I can create email ...
user avatar
  • 1,329