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

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

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

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

can yo usahre me correct way @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?

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

Urgent Help Needed cannot log in to my sql server

aaPanel_Kern

aaP_bobdipesh5

Error establishing a database connection - database is linked correctly on wp config also when i visit website i had this issue no idea what is going one @aaPanel_Kern

aaPanel_Kern

It is recommended that you try using 127.0.0..1 to connect properly

aaP_bobdipesh5

aaPanel_Kern

aaPanel_Kern It is recommended that you try using 127.0.0..1 to connect properly

aaP_bobdipesh5

@aaPanel_Kern how to fix this, can you fix on of the site and give me guide to fix others thanks

aaP_bobdipesh5

aaPanel_Kern thanks its fixed

« Previous Page