phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42

  • Hi, Happy New Year.

    Today with the apache2 status command on our home Linux VB server I see this for the first time and I do not know why.

    Apache has been running 3 days with no touching.

    There is one dom we have wordpress on and it has been fine and untouched for this to happen.

    Any help please?

    oz

    
apache2.service - The Apache HTTP Server
Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2023-01-03 11:22:01 AEDT; 21h ago
Docs: https://httpd.apache.org/docs/2.4/
Process: 630 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS)
Process: 3433 ExecReload=/usr/sbin/apachectl graceful (code=exited, status=0/SUCCESS)
Main PID: 807 (apache2)
Tasks: 11 (limit: 10660)
Memory: 62.5M
CGroup: /system.slice/apache2.service
├─ 807 /usr/sbin/apache2 -k start
├─3437 /usr/sbin/apache2 -k start
├─3439 /usr/sbin/apache2 -k start
├─3440 /usr/sbin/apache2 -k start
├─3441 /usr/sbin/apache2 -k start
├─3547 /usr/sbin/apache2 -k start
├─3548 /usr/sbin/apache2 -k start
├─3549 /usr/sbin/apache2 -k start
├─3550 /usr/sbin/apache2 -k start
├─3551 /usr/sbin/apache2 -k start
└─3552 /usr/sbin/apache2 -k start

Jan 04 04:56:49 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:50 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:50 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:51 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:51 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:52 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:52 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:53 zorin162-VirtualBox phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42
Jan 04 04:56:53 zorin162-VirtualBox phpMyAdmin[3437]: user denied: wordspress (mysql-denied) from 134.122.19.42
Jan 04 04:56:54 zorin162-VirtualBox phpMyAdmin[3437]: user denied: wordpress (mysql-denied) from 134.122.19.42
root@zorin162-VirtualBox:~#

    In the URL I get..

    
192.168.20.83/rootsofausssie
Not Found
Not found apache Port 80
--------------------------

    EDIT:

    I have just done a apache2 status again and it says it us running but does not show the mysql or wordpress erros above.
    It still does not resolve the wp site though.

    • This topic was modified 1 year, 9 months ago by Dion Hulse. Reason: fixing code formatting
Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi, you should have a look into the mysql log, there should be the reason (password empty, password wrong, etc…) why you cannot connect to the mysql server

    https://www.percona.com/blog/2012/12/28/auditing-login-attempts-in-mysql/

    From the above acticle:
    The mysql log file is usually located here: /var/log/mysql/mysql.log
    Failed log in attempts look something like this: Access denied for user ‘wordpress’@’localhost’ (using password yes/no)
    In the mysql config you have to set log_warnings = 2 (higher or equal to 2) in order to log login attempts

    So if the user is not using a password this will probably be the error, try adding a database password in the wp-config

    Thread Starter ozstar

    (@ozstar)

    Many thanks for you help.

    I unzipped the error logs(there were 7) and came across this in the last log Jan 1st which was when it stopped. It was repeated a few times.

      2023-01-03T17:55:20.966765Z 13 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ”sha256_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’

    So I am not sure where I go from here.

    I am using ubuntu 20.04 btw.

    Thanks again.

    Thread Starter ozstar

    (@ozstar)

    I have checked the permissions and they are 755 for the site folders and it seems as far as I could tell my pwd is correct.

    How else can I access where the problem may be ?

    Hello, this warning should not cause a problem yet, but in the future. I think if you reset the password it should use a sha2 hashed password and the warning should be gone.

    Please activate WordPress debugging and look into the /wp-content/debug.log file if you see anything there.

    Thread Starter ozstar

    (@ozstar)

    Thank you.
    Unfortunately there was no deg log however I have now added it to the config file foe next time.
    I have been following other info and am now able to access phpmyadmin with the user and pwd and check the wp db data. It all seems okay.

    I am still getting the same 404 with the url 192.168.20.83/mysite which is the exact url that did work. I also tried localhost/mysite.

    Not Found
The requested URL was not found on this server.
Apache/2.4.41 (Ubuntu) Server at 192.168.20.83 Port 80

    I have checked firewall and it is fine and apache2 has correct permissions.

    There is obviously something with the mysql db that is stopping it.

    Any more ideas?

    Thread Starter ozstar

    (@ozstar)

    I finally got it going by changing a few lines in the conf files but whilst I see the home page and admin home page in the box I work on, they show as text with out images in the other boxes on the LAN.

    I also cannot link to any other pages without getting a 404.

    Any help please?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘phpMyAdmin[3437]: user denied: root (mysql-denied) from 134.122.19.42’ is closed to new replies.