mariadb reinstall
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
-
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. 0
Please sign in to leave a comment.
Comments
3 comments