Questions tagged [phpmyadmin]
A web-based PHP utility used to manage MySQL databases on a server.
211
questions
0
votes
1
answer
511
views
keep getting mysqli_real_connect(): (HY000/1045): Access denied for user 'testing'@'localhost' (using password: YES) for non-root users
I have a linux web server as a part of a college course (i.e, all of my applications and setting are done according to my teacher instructions, and I get the needed files from his ftp server). I'm ...
- 3
0
votes
0
answers
139
views
Getting debconf-set-selections right for scripted install of phpMyAdmin
I'm setting up a Vagrant box on my MacBook Pro (again, because the transition to Apple Silicon changed a lot), with Ubuntu 20.04 as the guest OS. I'm trying to do it all using provisioning scripts, ...
- 71
0
votes
0
answers
70
views
Updating docker container with new image version but keeping configs
I have phpmyadmin Docker's container that runs an older version of phpMyAdmin. I need to update the phpMyAdmin to the latest version. The common solution here is to stop the current container and then ...
- 308
-1
votes
1
answer
161
views
Unable connect to local webserver via secure ssh tunnel
I have problem with connection to the virtual server. I always get connection refused and I don't know how to solve it.
I installed bitnami wordpress on virutal machine(VirutalBox). This working ...
- 1
1
vote
1
answer
122
views
How to access PHPMyAdmin from the web on a VPS (IaaS) server environment? [closed]
Ubuntu server 22.10.
If PHPMyAdmin doesn’t have this path /var/www/html/phpmyadmin then how could I access it from https://IP-ADDRESS/phpmyadmin?
I thought about creating a softlink from /usr/share/...
- 43
2
votes
1
answer
6k
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
1
answer
897
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
-1
votes
1
answer
658
views
Install phpMyAdmin for remote access
I use Ubuntu 20.04, and using a remote MySql DB (which is installed on an external server).
I am looking for installing phpMyAdmin without installing a local MySql server, but cannot find how to do it....
- 127
0
votes
1
answer
7k
views
Phpmyadmin access denied due to accidentally lock account
Hello my Xampp was working and I access also the phpmyadmin in website, at first I was able to access the PhpMyAdmin site when I was there I accidentally lock the local host after that I was not be ...
0
votes
2
answers
955
views
Secure phpmyadmin site with nginx
I have a server with many websites. The configuration is done with nginx.
I installed phpmyadmin and I add a domain name to open it in the navigator.
I want to restrict access to see it only when I am ...
- 1
1
vote
0
answers
1k
views
phpmyadmin installation return ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I already have a mysql database in local (installed, configured and containing things for a service).
When I try to install phpmyadmin, I get the following error : ERROR 1045 (28000): Access denied ...
- 11
1
vote
0
answers
87
views
"ERROR 1064", "error in your SQL" when installing phpMyAdmin
I am running a VPS using Debian 10 and I've been trying for a few hours now to install phpmyadmin, I've correctly installed, purged and then reinstalled mysql but every time I get this errort when ...
- 11
1
vote
2
answers
24k
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
0
votes
1
answer
75
views
MySQL 1273 Workbench
I have initially started to run https://www.youtube.com/watch?v=7S_tz1z_5bA&t and installed it all. When using MySQL Work Bench I initially run it, I get thunder icon when it runs but then I get ...
0
votes
1
answer
2k
views
Ubuntu 20.04 switch to multi version of PHP returns error 500 on phpMyAdmin
I have installed multiple version of PHP 5.6, 7.2, 7.3, 7.4 and 8.0 with 7.4 set as the default. I tried to switch to different version for some projects running on older version, doing this:
sudo ...
- 101
0
votes
1
answer
6k
views
How to set up an SQL database on Synology NAS?
I would like to set up REST API, which can communicate with my database on my NAS. I made this simple PHP code for the database connection, and it works perfectly with Xampp on my computer.
<?php
$...
- 103
0
votes
1
answer
101
views
MySQL beginner: How to set an user's host if there is no static public ip?
I want to connect to a database called 'data' of my web server from my local raspberrypi. To accomplish this, I have already set up a user named raspberrypi (using the web server's phpmyadmin UI), ...
- 101
1
vote
1
answer
655
views
Cannot log in to the MySQL server _After data dir changed _cent os 7
I am having centos 7 and recently i changed my data directory of mysql from /var/lib/mysql to /test/sql after the migration i am able to login from mysql server through terminal but not able to login ...
- 34
0
votes
1
answer
275
views
TOTP 2FA option is not appearing in phpMyAdmin
Using phpMyAdmin 5.0.4 (remi repository). I've installed all of the pre-requisites that I know of:
yum install php-pragmarx-google2fa php-bacon-qr-code php-samyoul-u2f-php-server
But only U2F is ...
- 13
0
votes
3
answers
1k
views
2 Raspberry PI connecting to same MYSQL database on the same network
I am working on a project which requires 2 Raspberry Pis to share some data.
I have figured that it would be most convenient for me to use MySQL database since I had a bit of experience on that. I ...
0
votes
1
answer
3k
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
1
answer
2k
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-...
- 1
0
votes
1
answer
1k
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://...
- 101
0
votes
1
answer
318
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.
- 161
0
votes
2
answers
1k
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/...
- 147
0
votes
1
answer
192
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 ...
- 113
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
1
vote
0
answers
288
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'.
- 11
2
votes
1
answer
439
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
0
answers
179
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.
...
1
vote
0
answers
306
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 ...
- 11
1
vote
1
answer
6k
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 "...
- 13
-1
votes
1
answer
2k
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
1
vote
1
answer
3k
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.
- 11
1
vote
1
answer
409
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 ...
- 11
1
vote
0
answers
644
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 ...
- 11
1
vote
0
answers
2k
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
1
answer
136
views
Laravel - artisan migrate returns error (General error: 1025 Error)
I tried to migrate a new table in Laravel, but I get this error:
- 11
1
vote
3
answers
43k
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 ...
- 11
0
votes
1
answer
182
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 ...
- 27
1
vote
1
answer
2k
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 ...
- 13
1
vote
0
answers
328
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 ...
- 11
1
vote
0
answers
23
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'...
- 11
-1
votes
1
answer
829
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....
- 101
0
votes
0
answers
1k
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:
...
- 113
1
vote
0
answers
3k
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 ...
- 11
1
vote
0
answers
1k
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/"
...
- 11
0
votes
0
answers
843
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 ...
- 21
1
vote
1
answer
8k
views
phpMyAdmin CentOS 7 cannot log in to the MySQL server
I am setting up a brand new CentOS 7 LAMP server. I installed phpMyAdmin using yum and epel, following the directions here:
https://linuxize.com/post/how-to-install-and-secure-phpmyadmin-with-apache-...
- 21
-1
votes
1
answer
178
views
GCP app engine connect to GCP cloud SQL
follow these steps https://cloud.google.com/sql/docs/mysql/phpmyadmin-on-app-engine
I open the service to connect cloud SQL, and type the password.
It shows
#2006 - MySQL server has gone away
...
