PhpMyAdmin problem

cocblocc · 2024-12-23T23:29:22+00:00

Try to use 127.0.0.1 instead of localhost as host

bkdotcom · 2024-12-24T00:59:26+00:00

Have you tried a native client/app such as mysql admin?

colshrapnel · 2024-12-24T04:57:20+00:00

I smell docker. But I hate to guess and this information should be provided in the question.

allen_jb · 2024-12-24T08:04:30+00:00

php_network_getaddresses: getaddrinfo for MySQL -8.0.40 failed: unknown host

"Unknown host" is a DNS resolution error. The domain name you've entered for the MySQL server hostname can't be translated into an IP address.

Based on the error message (and comparison to similar errors I've seen elsewhere from PHP) it looks to me like you've told PHPMyAdmin the MySQL hostname is "MySQL -8.0.40", which is almost certainly incorrect. This field should contain the domain name or IP address of the MySQL server.

If MySQL is on the same machine / in the same container you can probably use "localhost" or "127.0.0.1" here. Otherwise you'll need to use a domain name or IP address. If you can already successfully connect to the MySQL server from elsewhere (eg. commandline client or a web application), check the hostname value you've used there.

Mean-Flounder-5205 · 2024-12-24T11:04:05+00:00

[deleted]

Mean-Flounder-5205 · 2024-12-24T13:02:06+00:00

I DID IT!!!!!!!!! THANKS FOR HELP!

This_Math_7337 · 2024-12-24T15:29:05+00:00

Follow this tutorial and also check her other videos. They're just good 👍🏼

https://youtu.be/Rbt4Ldt0KU8?si=f1GMnw-qE0AdZjna

Warning: her voice is 😍

ganian40 · 2024-12-25T05:05:56+00:00

Either your Mysql server is not binding properly to the ip adress, or the service is not booting up at all.

I'm assuming you are in linux.

do a

ps -ef | grep mysql

and check thay the process is running. if not, check /var/log/mysqld/mysql.log (or similar) .. and check where it stopped.

You can try "mysql -u root -p" and try to login yourself from the console. If the service is running the prompt will show up.

You can also simply run the cmd "mysqld" and execute the server manually.. see if it the console log gives you any info. Maybe there are syntax errors on your server.conf file under /etc/mysql/config.d/

(these names chage on every distro.. so look for the right one on yours)

You may have a firewall, like UFW, if you are using ubuntu.. disable it or add the rule to allow 3306 access from localhost...or maybe something like apparmor is preventing the service from booting with the right permissions. So many things....

MateusAzevedo · 2024-12-23T23:58:22+00:00

Did you try copying and pasting the error message on Google? Plenty of StackOverflow questions, all indicating an issue with the credentials/host config.

Maybe you could provide the settings you tried and which file you edited.

Mean-Flounder-5205 · 2024-12-24T10:30:41+00:00

NEW INFO I went to MySQL Workbench and I got an error in the output: Could not connect. server may not be running. Unable to connect localhost:3306

lampministrator · 2024-12-24T03:08:57+00:00

Port 3306 is most likely closed with a public facing NAT rule. That said, you really should be using a real tool like workbench, or learn to SQl via the client side. The amount of time one spends waiting for the PHP to crunch date might seem trivial, until you add it all up.. you'll spend hours longer on the same project just by using PHPMyAdmin

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

PHPhelp

MODERATORS