can't start Mysql , and this is the mysql log

aaP_towndev200

2023-05-09T12:08:36.111685Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-05-09T12:08:36.111866Z 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.
2023-05-09T12:08:36.111881Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-05-09T12:08:36.111919Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2023-05-09T12:08:36.111967Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.41-log) starting as process 1057721 ...
2023-05-09T12:08:36.133064Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-05-09T12:08:36.133103Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-05-09T12:08:36.133115Z 0 [Note] InnoDB: Uses event mutexes
2023-05-09T12:08:36.133125Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-05-09T12:08:36.133132Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-05-09T12:08:36.133820Z 0 [Note] InnoDB: Number of pools: 1
2023-05-09T12:08:36.134031Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-05-09T12:08:36.135761Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2023-05-09T12:08:36.181104Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-05-09T12:08:36.188513Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-05-09T12:08:36.200588Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-05-09T12:08:36.281175Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-05-09T12:08:36.281289Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-05-09T12:08:36.535372Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-05-09T12:08:36.536496Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-05-09T12:08:36.536520Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-05-09T12:08:36.536991Z 0 [Note] InnoDB: 5.7.41 started; log sequence number 1210319
2023-05-09T12:08:36.537100Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-05-09T12:08:36.537294Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230509 17:38:36
2023-05-09T12:08:36.537332Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2023-05-09T12:08:36.537466Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2023-05-09T12:08:36.538274Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-05-09T12:08:36.540483Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-05-09T12:08:36.540522Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-05-09T12:08:36.540533Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-05-09T12:08:36.540539Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-05-09T12:08:36.541533Z 0 [Warning] CA certificate ca.pem is self signed.
2023-05-09T12:08:36.541657Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-05-09T12:08:36.541870Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-05-09T12:08:36.542060Z 0 [Note] IPv6 is available.
2023-05-09T12:08:36.542073Z 0 [Note] - '::' resolves to '::';
2023-05-09T12:08:36.542106Z 0 [Note] Server socket created on IP: '::'.
2023-05-09T12:08:36.586576Z 0 [Warning] Failed to open optimizer cost constant tables

2023-05-09T12:08:36.586767Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2023-05-09T12:08:36.586790Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2023-05-09T12:08:36.586877Z 0 [ERROR] Aborting

2023-05-09T12:08:36.586920Z 0 [Note] Binlog end
2023-05-09T12:08:36.586979Z 0 [Note] Shutting down plugin 'ngram'
2023-05-09T12:08:36.586989Z 0 [Note] Shutting down plugin 'partition'
2023-05-09T12:08:36.586994Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-05-09T12:08:36.587000Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-05-09T12:08:36.587005Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-05-09T12:08:36.587059Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-05-09T12:08:36.587066Z 0 [Note] Shutting down plugin 'MyISAM'
2023-05-09T12:08:36.587082Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-05-09T12:08:36.587088Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-05-09T12:08:36.587093Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-05-09T12:08:36.587098Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-05-09T12:08:36.587102Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-05-09T12:08:36.587107Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-05-09T12:08:36.587111Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-05-09T12:08:36.587116Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-05-09T12:08:36.587120Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-05-09T12:08:36.587125Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-05-09T12:08:36.587129Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-05-09T12:08:36.587134Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-05-09T12:08:36.587139Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-05-09T12:08:36.587143Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-05-09T12:08:36.587147Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-05-09T12:08:36.587151Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-05-09T12:08:36.587156Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-05-09T12:08:36.587160Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-05-09T12:08:36.587164Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-05-09T12:08:36.587169Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-05-09T12:08:36.587173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-05-09T12:08:36.587177Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-05-09T12:08:36.587182Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-05-09T12:08:36.587186Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-05-09T12:08:36.587191Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-05-09T12:08:36.587195Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-05-09T12:08:36.587199Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-05-09T12:08:36.587203Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-05-09T12:08:36.587208Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-05-09T12:08:36.587212Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-05-09T12:08:36.587217Z 0 [Note] Shutting down plugin 'InnoDB'
2023-05-09T12:08:36.588529Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-05-09T12:08:36.588749Z 0 [Note] InnoDB: Starting shutdown...
2023-05-09T12:08:36.688886Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-05-09T12:08:36.689151Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230509 17:38:36
2023-05-09T12:08:38.187355Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210338
2023-05-09T12:08:38.193200Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-05-09T12:08:38.193266Z 0 [Note] Shutting down plugin 'MEMORY'
2023-05-09T12:08:38.193290Z 0 [Note] Shutting down plugin 'CSV'
2023-05-09T12:08:38.193310Z 0 [Note] Shutting down plugin 'sha256_password'
2023-05-09T12:08:38.193326Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-05-09T12:08:38.193673Z 0 [Note] Shutting down plugin 'binlog'
2023-05-09T12:08:38.220339Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

aaPanel_Kern

aaP_towndev200
Hello, is it a new installation of mysql? If it is a reinstallation, can it be solved?

aaP_towndev200

Fatal error: Uncaught mysqli_sql_exception: SELECT command denied to user 'tto'@'localhost' for table 'user' in /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Dbi/DbiMysqli.php:199 Stack trace: #0 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Dbi/DbiMysqli.php(199): mysqli->query() #1 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/DatabaseInterface.php(316): PhpMyAdmin\Dbi\DbiMysqli->realQuery() #2 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/DatabaseInterface.php(2390): PhpMyAdmin\DatabaseInterface->tryQuery() #3 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/DatabaseInterface.php(2332): PhpMyAdmin\DatabaseInterface->isUserType() #4 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Menu.php(562): PhpMyAdmin\DatabaseInterface->isSuperuser() #5 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Menu.php(107): PhpMyAdmin\Menu->getServerTabs() #6 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Menu.php(70): PhpMyAdmin\Menu->getMenu() #7 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Header.php(445): PhpMyAdmin\Menu->getDisplay() #8 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Response.php(323): PhpMyAdmin\Header->getDisplay() #9 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Response.php(336): PhpMyAdmin\Response->getDisplay() #10 /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Response.php(495): PhpMyAdmin\Response->htmlResponse() #11 [internal function]: PhpMyAdmin\Response->response() #12 {main} thrown in /www/server/phpmyadmin/phpmyadmin_aec01266f50f2ce5/libraries/classes/Dbi/DbiMysqli.php on line 199

aaP_towndev200

thank you! it is solved

aaP_towndev200

however, https://192.168.0.132:7800/e4c0f27a is not working today,and it was fine till yesterday, what can be the solution

aaPanel_Kern

Hello, is the server status normal?
Whether the bt service is started: bt status
What information can't be accessed

aaP_towndev200

aaPanel_Kern
hi, server status is not normal , can't open aapanel
it says,
This site can’t be reachedhttps://192.168.0.132:7800/e4c0f27a is unreachable.
ERR_ADDRESS_UNREACHABLE

aaP_towndev200

$ bt status

/usr/bin/bt: line 17: cd: /www/server/panel: Permission denied
cat: /www/server/panel/BT-Panel: Permission denied
sed: can't read /www/server/panel/BT-Panel: Permission denied
cat: /www/server/panel/BT-Task: Permission denied
sed: can't read /www/server/panel/BT-Task: Permission denied
chmod: cannot access '/www/server/panel/BT-Panel': Permission denied
chmod: cannot access '/www/server/panel/BT-Task': Permission denied
cat: /www/server/panel/data/port.pl: Permission denied
cat: /www/server/panel/data/port.pl: Permission denied
Bt-Panel (pid 1948) already running
Bt-Task (pid 1101 201822 201823) already running

aaPanel_Kern

aaP_towndev200
top or htop command to observe server load
Execute the bt command with root privileges

aaP_towndev200

yes, performed bt command with root privileges and htop command is normal, but https://192.168.0.132:7800/e4c0f27a isn't working

aaPanel_Kern

aaP_towndev200
This is an intranet address that needs to be on the same network as the server to access. Did you use this address before?
Can't access what information?
bt 14 command to view the default address of the panel

aaPanel_Kern

aaPanel_Kern This is an intranet address that needs to be on the same network as the server to access. Did you use this address before?
As mentioned before, the intranet can only be accessed by the same network connection. Different intranets do not communicate with each other.
Is it possible to use the external network address to access?

aaP_towndev200

yes,my internet network is different today did you mean that?

aaP_towndev200

bt command says,$ bt
/usr/bin/bt: line 17: cd: /www/server/panel: Permission denied
cat: /www/server/panel/BT-Panel: Permission denied
sed: can't read /www/server/panel/BT-Panel: Permission denied
cat: /www/server/panel/BT-Task: Permission denied
sed: can't read /www/server/panel/BT-Task: Permission denied
chmod: cannot access '/www/server/panel/BT-Panel': Permission denied
chmod: cannot access '/www/server/panel/BT-Task': Permission denied
cat: /www/server/panel/data/port.pl: Permission denied
/usr/bin/bt: line 336: /usr/bin/python: No such file or directory

aaPanel_Kern

aaP_towndev200
Can't access what information?
Can't access what information?
Can't access what information?
sudo bt 14

aaP_towndev200

Can't access aapanel dashboard information and website added in it

aaPanel_Kern

sudo bt 14

aaP_towndev200

aaPanel_Kern

Use to check whether the bt service is started: sudo bt status
Check if you are accessing with the correct link: sudo bt 14

aaP_towndev200

aaPanel_Kern
sudo bt status
Bt-Panel (pid 1948) already running
Bt-Task (pid 1101) already running

aaP_towndev200

is this because i use different internet network today when compared to yesterday

aaP_towndev200

how can i have a server not the localhost one