hmaddy

Well-Known Member
May 6, 2020
351
39
28
Chennai
cPanel Access Level
Root Administrator
Mariadb was corrupted. so need to uninstall it and reinstall. already taken the backups of all databases. so how to uninstall it and reinstall mariadb.???


is there any tools available for repair or reinstall mariadb
 

hmaddy

Well-Known Member
May 6, 2020
351
39
28
Chennai
cPanel Access Level
Root Administrator
okay. All the tables automatically converted to read-only. so how to fix this issue.

i restored the databases with old backups and reinstalled mysql. But after that all the databases throwing some errors on error log.

2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Uses event mutexes
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Using Linux native AIO
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Number of pools: 1
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Completed initialization of buffer pool
2022-01-12 16:37:01 140318089434880 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Highest supported file format is Barracuda.
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: Waiting for purge to start
2022-01-12 16:37:01 140318647867584 [Note] InnoDB: 5.7.36 started; log sequence number 1615526
2022-01-12 16:37:01 140317646907136 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-01-12 16:37:01 140317646907136 [Note] InnoDB: Buffer pool(s) load completed at 220112 16:37:01
2022-01-12 16:37:01 140318647867584 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-12 16:37:01 140318647867584 [Note] Server socket created on IP: '::'.
2022-01-12 16:37:01 140318647867584 [Note] Reading of all Master_info entries succeeded
2022-01-12 16:37:01 140318647867584 [Note] Added new Master_info '' to hash table
2022-01-12 16:37:01 140318647867584 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2022-01-12 16:38:51 140318175745792 [Warning] Access denied for user 's99_mexicocity'@'localhost' (using password: YES)
2022-01-12 16:41:35 140318176052992 [Warning] Access denied for user 's99_srongest'@'localhost' (using password: YES)
2022-01-12 16:41:51 140318175438592 [Warning] Access denied for user 's99_facemask'@'localhost' (using password: YES)
2022-01-12 16:42:01 140318175438592 [Warning] Access denied for user 's99_facemask'@'localhost' (using password: YES)
2022-01-12 16:43:49 140318176052992 [Warning] Access denied for user 's99_techuserict'@'localhost' (using password: YES)
2022-01-12 16:44:04 140318175745792 [Warning] Access denied for user 's99_srongest'@'localhost' (using password: YES)
2022-01-12 16:45:36 140318176052992 [Warning] Access denied for user 's99_beauty'@'localhost' (using password: YES)
2022-01-12 16:48:24 140318176052992 [Warning] Access denied for user 's99_srongest'@'localhost' (using password: YES)

This error happened on all account databases. so please help us to recover on this situations.
 

cPanelAnthony

Administrator
Staff member
Oct 18, 2021
1,041
111
118
Houston, TX
cPanel Access Level
Root Administrator
Hello again! You might want to find a database administrator to assist you with this. You can check the listings here.