Questions tagged [phpmyadmin]

A web-based PHP utility used to manage MySQL databases on a server.

Filter by
Sorted by
Tagged with
1
vote
0answers
43 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 ...
1
vote
1answer
22 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 ...
0
votes
0answers
18 views

Unable to connect phpmyadmin from Docker container to a ssh tunnel established by host

I would like to run phpmyadmin as a Docker container, establish a ssh tunnel from the host machine, make the phpmyadmin container connect to the ssh tunnel. As suggested in this answer I have done ...
0
votes
0answers
21 views

MariaDB Access Denied after Server Reboot

I'm using 10.3.29-MariaDB-0ubuntu0.20.04.1 and every time I reboot the server on my VM I get the error "Access denied for user 'root'@'localhost' (using password: YES)". I can reset the ...
0
votes
1answer
17 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
0answers
283 views

Ubuntu 20.4 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 ,8.0 and 7.4 is the default, I tried to switch to different version for some projects running on older version, doing sudo update-...
0
votes
1answer
396 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 $...
0
votes
1answer
26 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), ...
1
vote
1answer
48 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 ...
0
votes
1answer
28 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 ...
0
votes
3answers
103 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
0answers
138 views

Unable to log in to phpMyAdmin 5.1 using cookie authentication

Running phpMyAdmin v. 5.0.2 and it works fine. Downloaded 5.1.0-rc1, unzipped it to public_html and added server by phpMyAdmin/setup. Also tried to manually edit the configuration. When I try to log ...
0
votes
0answers
13 views

PHPMyAdmin on CentOS 8

I'm currently trying to setup a test server in Virtual Box. It's CentOS8 and so far I have installed PHP, MySQL and SFTP. The only thing I am missing now is PHPMyAdmin however for some reason it doesn'...
0
votes
0answers
19 views

why is my PHPmyadmin config empty

(im relatively new to linux) so I made a fresh PHPMyAdmin install + apache2 on my vps. (ubuntu 18.04 LTS) but the config is in /etc/phpmyadmin/config.inc.php and this is empty, how can I fix this? it ...
0
votes
0answers
34 views

PyMySQL Remote Connection Error

I'm quite new with the database scene so please bear with me if this is too simple, but I couldn't find solutions anywhere. I made a Python script that successfully connected to a local MySQL database ...
0
votes
0answers
15 views

Facing issues in inserting special characters and non english language characters in Wamp server database using excel sheet

I'm using wamp server to store the data's in database using excel sheet but whenever i insert special characters the database won't fetch the data and if i'm using any non english languages then it ...
2
votes
1answer
97 views

How to host a site using apache2 on Ubuntu 20.04 with ip_adress/phpmyadmin accessible

I have a VPS setup with Ubuntu 20.04 and LAMP installed. I could access phpmyadmin then via <ip_address>/phpmyadmin. Later I enabled a virtualhost at /etc/apache2/sites-available/ by adding ....
0
votes
1answer
250 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
1answer
564 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
1answer
263 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
142 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
1answer
143 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
1answer
53 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 ...
2
votes
1answer
553 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
70 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'.
1
vote
1answer
96 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
19 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
0answers
68 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 ...
1
vote
1answer
3k 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 "...
-1
votes
1answer
393 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
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.
1
vote
1answer
138 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
330 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 ...
1
vote
0answers
999 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
1answer
45 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
24k 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
73 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
960 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 ...
1
vote
0answers
138 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 ...
1
vote
0answers
19 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
491 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
948 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
1k 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
961 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
492 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 ...
1
vote
1answer
5k 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-...
-1
votes
1answer
159 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 ...
-1
votes
1answer
1k views

phpMyAdmin JavaScript error when using designer feature

When I try to use the designer feature in phpMyAdmin I get this error 'A fatal JavaScript error has occurred. Would you like to send an error report?'. This freezes the entire site and I have to log ...
3
votes
2answers
8k 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 ...
0
votes
1answer
1k views

phpmyadmin showing code. php is working

I am running Ubuntu 18.04, Apache 2.4.29, php 7.2. The problem is when I try to load phpmyadmin all it shows is code. I know php is working cause phpinfo works perfectly. https://www.aaackley.com/...

1
2 3 4 5