Urgent Help Needed cannot log in to my sql server

aaP_bobdipesh5

i using
ols php 7.4 but i cannot conect sql i tried using root also did not work

Error Log
file: "ibtmp1"
2025-02-17T06:46:31.684984Z 0 [Note] Shutting down plugin 'MEMORY'
2025-02-17T06:46:31.684991Z 0 [Note] Shutting down plugin 'CSV'
2025-02-17T06:46:31.684997Z 0 [Note] Shutting down plugin 'sha256_password'
2025-02-17T06:46:31.685001Z 0 [Note] Shutting down plugin 'mysql_native_password'
2025-02-17T06:46:31.685189Z 0 [Note] Shutting down plugin 'binlog'
2025-02-17T06:46:31.692872Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2025-02-17T06:46:32.932180Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2025-02-17T06:46:32.932256Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-02-17T06:46:32.932259Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2025-02-17T06:46:32.932271Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2025-02-17T06:46:32.932281Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 6941 ...
2025-02-17T06:46:32.983103Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-02-17T06:46:32.983121Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-02-17T06:46:32.983124Z 0 [Note] InnoDB: Uses event mutexes
2025-02-17T06:46:32.983127Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-02-17T06:46:32.983129Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-02-17T06:46:32.983317Z 0 [Note] InnoDB: Number of pools: 1
2025-02-17T06:46:32.983370Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-02-17T06:46:32.983884Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2025-02-17T06:46:33.012946Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-02-17T06:46:33.020176Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-02-17T06:46:33.031093Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-02-17T06:46:33.045571Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-02-17T06:46:33.045606Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-02-17T06:46:33.056849Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2025-02-17T06:46:33.057143Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-02-17T06:46:33.057147Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-02-17T06:46:33.057322Z 0 [Note] InnoDB: Waiting for purge to start
2025-02-17T06:46:33.107451Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 171506776
2025-02-17T06:46:33.107598Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2025-02-17T06:46:33.107663Z 0 [Note] Plugin 'FEDERATED' is disabled.
2025-02-17T06:46:33.109063Z 0 [Note] InnoDB: Buffer pool(s) load completed at 250217 6:46:33
2025-02-17T06:46:33.115652Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-02-17T06:46:33.115665Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-02-17T06:46:33.115671Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-02-17T06:46:33.115675Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-02-17T06:46:33.116162Z 0 [Warning] CA certificate ca.pem is self signed.
2025-02-17T06:46:33.116185Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-02-17T06:46:33.116236Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2025-02-17T06:46:33.116332Z 0 [Note] IPv6 is available.
2025-02-17T06:46:33.116337Z 0 [Note] - '::' resolves to '::';
2025-02-17T06:46:33.116379Z 0 [Note] Server socket created on IP: '::'.
2025-02-17T06:46:33.120732Z 0 [Note] Failed to start slave threads for channel ''
2025-02-17T06:46:33.124170Z 0 [Note] Event Scheduler: Loaded 0 events
2025-02-17T06:46:33.124392Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.44-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2025-02-17T06:47:24.511527Z 11 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2025-02-17T06:47:24.511805Z 12 [Note] Access denied for user 'root'@'localhost' (using password: YES)

i am facing issue is cannot connect database of my website

aaPanel_Kern

Hello, please check whether the following two parameters in the php configuration file are: /tmp/mysql.sock
pdo_mysql.default_socke
mysqli.default_socket

Is it possible to add a test database to the Databases interface?

aaP_bobdipesh5

aaPanel_Kern

Haven't you solved it? The above is to check if it is correct

aaPanel_Kern Hello, please check whether the following two parameters in the php configuration file are: /tmp/mysql.sock
pdo_mysql.default_socke
mysqli.default_socket

Is it possible to add a test database to the Databases interface?

aaP_bobdipesh5

test database is same i created a new test database and haivng issue cannot login same like on the picutre

root@ubuntu-16gb-fsn1-1:~# php -i | grep mysql.sock
pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock

@aaPanel_Kern

aaPanel_Kern

Hello, please go directly to the corresponding PHP configuration file to view

aaP_bobdipesh5

re instlaled and instlal php 7.4 again and its back to normal now

aaP_bobdipesh5

but why this is happening

aaP_bobdipesh5

@aaPanel_Kern

aaPanel_Kern

It may be caused by incorrect configuration of mysql in the lsphp configuration file

aaP_bobdipesh5

can yo usahre me correct way @aaPanel_Kern

aaP_bobdipesh5

aaPanel_Kern still i got the same error kem - can you help me out. thanks now database connection failed

aaP_bobdipesh5

Hello, please check whether the following two parameters in the php configuration file are: /tmp/mysql.sock
pdo_mysql.default_socke
mysqli.default_socket
@aaPanel_Kern how to check this any cmd or give me direction

aaP_bobdipesh5

i am able tologin root database

aaPanel_Kern

aaP_bobdipesh5

@aaPanel_Kern
https://codeshare.io/Mk3xnp

can you check this my configuration

aaPanel_Kern

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

aaP_bobdipesh5

please do check your email sent

aaP_bobdipesh5

@aaPanel_Kern can you see why this is happening agian and agian email sent

aaPanel_Kern

Hello, my test is normal, what problems are you facing?
You can log in normally phpmyadmin

aaP_bobdipesh5

i had website but its not connected database. database error check one of my website start with mkv @aaPanel_Kern

aaPanel_Kern

aaP_bobdipesh5