Questions tagged [phpmyadmin]
A web-based PHP utility used to manage MySQL databases on a server.
221
questions
0
votes
1answer
20 views
localhost not loading correctly
PhpMyAdmin is not loading correctly after XAMPP starts. I am using the default settings Apache running on ports 80 and 443 and MySQL port 3306. When launch it from XAMPP the page can't be loaded "...
0
votes
0answers
8 views
phpmyadmin error 1045 installation with maria db
I am stuck with the following error when trying to install phpmyadmin on my ubuntu 16.04
this is weird because when i do mysql -u root -p
i can login just fine.. any idea on what to do ?
0
votes
1answer
55 views
Cannot access WAMP over internet
I have installed WAMP 3.2 on Windows Server.
I need to access the phpmyadmin running on localhost of wamp over the internet from anywhere.
After googling things, i found the modifications in httpd-...
0
votes
0answers
26 views
Cyberpanel how do I change the import size for phpmyadmin?
The default database import size is only 2mb, so thats gotta go. I followed this guide from Cyberpanel to the T but myphpadmin still reflects the default size so I still cant import.
https://...
0
votes
1answer
25 views
Error in installing phpmyadmin
I am installing phpmyadmin in Linux Mint 19 using this command sudo apt-get install mysql-server php7.0-mysql phpmyadmin. But I am getting below error while I am trying to browsing phpmyadmin.
0
votes
0answers
14 views
Windows 10 OS: Not able to browse for command-line php.exe path for Composer setup.exe
I am setting up Composer for Windows so that I able to execute the composer commands that will enable me to run commands to install my Laravel environment. I am unable to browse for a php.exe PATH. It ...
0
votes
0answers
8 views
How to setup a Laravel 5.7 and MY SQL database Environment on Windows 10 OS
I have a 32-bit OS x64 based processor Dell that uses Windows 10 OS. I am finding it increasingly difficult to find any useful how-to instructions. Laravel was written off of Mac OS system but there ...
0
votes
1answer
38 views
phpmyadmin: Failed opening required '/usr/share/php/gettext/gettext.inc'
Trying to access phpmyadmin on my centos 7 server,
I get the following error:
Fatal error: require_once(): Failed opening required '/usr/share/php/gettext/gettext.inc' (include_path='.:/usr/share/...
0
votes
0answers
48 views
Need to resolve phpmyadmin dependency issue on Amazon linux running nginx
I have an EC2 instance. I am unable to install phpMyAdmin successfully due to Amazon vs Red Hat dependency differences(I believe).
Error: Package: php-tidy-7.2.26-1.el7.remi.x86_64 (remi-php72)
...
0
votes
1answer
22 views
PhpMyAdmin: Results go by too fast and queries execute multiple times
PhpMyAdmin version: 3.4.9
Problems: two:
When I execute a query, the results are shown on a new page for a split second and then I am returned to my query, so I can't actually see the results of my ...
0
votes
0answers
28 views
Plesk: encrypt/hide specific database from other admins
Is it possible to hide or encrypt a specific database (or its contents) from other users with same privileges in Plesk linux?
0
votes
0answers
672 views
MySQL and XAMPP configuration error - “Cannot connect: invalid settings”
This is my first time on Super User. If this is an inappropriate question, Stack Overflow pointed me this way.
I have been trying to set up XAMPP on a new (well not new, but a new install) Windows 10 ...
1
vote
0answers
49 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 ...
1
vote
0answers
24 views
Setting NULL as default results in 1067 error Invalid default value for 'created'
Trying to set the default value of a column to NULL results in 1067 error: Invalid default value for 'created'.
0
votes
0answers
15 views
I Altered a Table Column and phpMyAdmin Responded by Removing the Table. Is That Table Recoverable? Is my phpMyAdmin Installation Safe to Use?
So, I was added a new, null column to my innoDB table as the second last column. It was a of a type BOOLEAN and as soon as I did it told me that I was betraying a foreign key constraint for doing so. ...
1
vote
1answer
56 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 ...
2
votes
0answers
18 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.
...
0
votes
0answers
23 views
Moving database between two servers
I am moving from Godaddy shared hosting to a VPS. When I export my databases using phpmyadmin as an SQL and import them into the VPS, the databases are not exact matches and the websites are failing.
...
1
vote
0answers
34 views
phpmyadmin not working after php verion Update
I have VPS with below things installed
Nginx, PHP 7.2.22, 10.3.18-MariaDB
Recently Updated PHP version from 7.1.17 to 7.2.22 .. After this, website is working fine.. PHPMyAdmin set on custom ...
0
votes
0answers
17 views
phpmyadmin error when changing any table insert setting through page related settings
I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. Whenever I make any changes to the table Insert Settings using the page related settings, phpmyadmin will ...
1
vote
1answer
623 views
phpmyadmin Default transformations for DateFormat does not change date format
I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "...
0
votes
0answers
236 views
Laravel 404 not found phpmyadmin
I installed laravel on centos 7 .Laravel's home page works fine but when I try to connect myipaddres/phpmyadmin ,I am getting 404 not found error.I don't know what error message I have to show you to ...
-1
votes
1answer
131 views
I cant login to phpmyadmin as root
i downloaded installed WAMP and i could not login to Mysql. i got frustrated with trying different solutions from the internet. I had to uninstall the app, now i have installed xampp and having the ...
1
vote
1answer
2k views
PhpStorm database connection error
I get such error when making connection to the database in PhpStorm. I couldn't find a solution.
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually.
1
vote
1answer
44 views
How to add existing DBase to phpmyadmin
We use phpmyadmin (4.6.6deb5) to admin some MariaDB-databases (10.1.38-MariaDB-0ubuntu0.18.10.2 - Ubuntu 18.10) which are added and design by phpadmin.
Now we add a database and a user by using the ...
1
vote
0answers
81 views
Moodle connnection error after update [Error: Database connection failed]
I recently upgraded to Ubuntu 19.10 (beta) while I have been using Moodle since some months. In last one week I updated my system/software couple of times and then out of nowhere, now, when I go to ...
0
votes
0answers
18 views
New phpMyAdmin user can login into my test XAMPP, but not the actual XAMPP
I'm really hoping that you'll be able to help me with my problem.
I developed a side-project for my friends on my spare time. It was a PHP-mySQL-javascript mashup website and worked great. I ...
0
votes
0answers
10 views
phpMyAdmin 4.8.3 suddenly EDIT hangs on LOADING banner
Been using a XAMPP/LAMPP distribution with phpMyAdmin 4.8.3 on top of MariaDB 10.1.37 on an Ubuntu 18.04.3 LTS ... for several months ... no issues.
Somewhere in the last week, the record EDIT link ...
1
vote
0answers
781 views
PHPMyAdmin 4.9: Failed to set session cookie
I've installed PHPmyadmin 4.9 in ubuntu trusty with nginx and PHP7.1 installed. With PHP is using memcache as session handler. However when I configured phpmyadmin I always get the error
Failed to ...
1
vote
0answers
27 views
Laravel - artisan migrate returns error (General error: 1025 Error)
I tried to migrate a new table in Laravel, but I get this error:
1
vote
2answers
8k views
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
I know this problem has come up before, but none of the solutions worked for me.
I someone could show me a step by step instruction what to do I would highly appreciate it.
Using XAMPP on Windows ...
0
votes
1answer
50 views
DATEDIFF() refuses to run on a MySQL Event
I want to create an event that will run every day and see if an account soon expires. The soon_expires cell will be later used by a Bash script that sends an e-mail to related user informing him of ...
0
votes
1answer
312 views
phpMyAdmin 2-factor authentication, can't see Authenticator App as an option
After a fair bit of doing, I finally got phpMyAdmin to allow 2FA. Unfortunately, it's only giving me two options: None and Hardware, whereas I want to be able to scan a QR code and use an ...
0
votes
0answers
31 views
PhpMyAdmin 4.9.0.1 export MySQL Database latin1_swedish_ci and reimport as UTF-8
I have to update a quite old CMS-system to a new one on an other webspace. This means also a new database.
The original database can't be modified, because at the moment the CMS is in use. There is ...
0
votes
0answers
438 views
Unable to access phpmyadmin in xampp on my MacOS
I am unable to access phpmyadmin in xampp in MacOS. The following thing shows up in the browser.
Access forbidden!
New XAMPP security concept:
Access to the requested directory is only available ...
0
votes
0answers
20 views
How can I access ProFTPD, if XAMPP to AWS web server was done completely through the CLI?
I created a web server using EC2 and LAMPP. I can access the myPHPadmin, but I have no idea how to access ProFTPD. Additionally, XAMPP did not download locally on my pc so I cannot access htdocs. The ...
1
vote
0answers
105 views
phpMyAdmin import csv into database error
I'm trying to import a csv file into a database without having defined a table in it but I got an error. I did it one week earlier but now I am not able to import the same csv file.
When I import ...
0
votes
0answers
58 views
PHP module XMLWriter is not installed
I am working on centos 7.
This is the error that I got:
PHP module XMLWriter is not installed.
Ask your server administrator to install the module.
Checked that libxml installed: php -i | grep "xml" ...
0
votes
0answers
13 views
Cannot redeclare PMA_isRememberSortingOrder()
I get this error on apache log file
[:error] [pid 18756] [client ::1:58908] PHP Fatal error: Cannot redeclare PMA_isRememberSortingOrder() (previously declared in /usr/share/phpmyadmin/libraries/...
0
votes
0answers
7 views
Website error establishing database connection
I restored a wordpress website using updraft(which I've done plenty of times before) and it was successful. Then within 10 seconds the website displayed "Error establishing database connection".
I ...
0
votes
0answers
30 views
PHPMyAdmin Export: Data & structure checkboxes are grayed out
I want to just export the table structure from two tables. The checkboxes for Data & Structure are grayed out.
How can I fix this?
0
votes
0answers
340 views
MySQL said: Cannot connect: invalid settings. XAMPP Error
Error
MySQL said:
Cannot connect: invalid settings.
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (...
1
vote
0answers
18 views
Internal Server Error in Bugzilla after resetting MySql Password
I have reset my mysql password, however now Bugzilla returns an Internal Service Error occasionally when accessing certain pages within Bugzilla. The error goes away when you refresh the page, but it'...
-1
votes
1answer
292 views
localhost/phpmyadmin downloads inddex.php file - ubuntu 16.04
I have install apache2, mysql and all the neccesary thngs and then install phpmyadmin in my ubuntu 16.04.
It worked that day, but now, when I open localhost/phpmyadmin it downloads the index.php file....
0
votes
0answers
807 views
Xampp mysql not starting
Today when I am trying to start my MYSQL from Xampp, its not starting and throwing below error in logs. No other instance is running on my machine for MYSQL.
Attached logs
XAMPP error display:
...
0
votes
0answers
714 views
phpmyadmin error The server is not responding (or the local server's socket is not correctly configured)
I have an online server(Ubuntu) on which I have installed xampp. And then installed WordPress it has been almost 7 months everything was fine. Previously when I updated some post or added more number ...
1
vote
0answers
455 views
Second VirtualHost returns “This site can’t be reached” - Wamp
It's a mystery. I've created a second VH to use with WAMP.
<VirtualHost *:80>
ServerName dev.sitetest.com
ServerAlias dev.sitetest.com
DocumentRoot "${INSTALL_DIR}/www/client/sitetest/web/"
...
0
votes
0answers
659 views
Can't open phpMyAdmin on XAMPP after creating new user
I created a new user via phpMyAdmin and granted it all permissions. Everything was working fine. I then shut down my MySQL via XAMPP and turned it on again.. now I can't access the phpMyAdmin page at ...
0
votes
0answers
166 views
MAMP, can't conect to phpMyAdmin
I have recently installed MAMP on Windows 10 in order to install WordPress. After installation Apache and MySQL are running very fine. However after rebooting system and even turning MAMP server off ...
0
votes
0answers
15 views
Joomla producing database error
I created a table in phpmyadmin for a custom Joomla database (joodatabase)
I get this error when I attempt to access edit the table data entries within joodatabase.
1064 You have an error in your ...
