Mysql-apt-config* mysql-client* mysql-common* mysql-community-client* mysql-community-client-core* So, we can include the –purge switch in the regular apt remove command: $ sudo apt remove -purge mysql\* -y For example, a corrupted database could persist. But then, these might keep us from successfully setting up MySQL after removing it. MariaDB's configuration file will be discussed in another article.However, the usual uninstall commands leave some files and metadata. Installing mariadb-server -MariaDB database server MariaDB configuration file The following article explains how to install MariaDB. Other MariaDB information To install MariaDB Let's take a look at the configuration file with the cat command. MariaDB's systemd configuration file can be found under "systemctl status mariadb". To see MariaDB's systemd configuration file Jul 22 13:13:47 shinshina-development-app-00000001 systemd : Stopping MariaDB 10.1.44 database server. Jul 22 13:13:50 shinshina-development-app-00000001 systemd : Stopped MariaDB 10.1.44 database server. Jul 22 13:24:33 shinshina-development-app-00000001 systemd : Starting MariaDB 10.1.44 database server. Jul 22 13:24:36 shinshina-development-app-00000001 / etc / mysql / debian-start : Upgrading MySQL tables if necessary. Jul 22 13:24:36 shinshina-development-app-00000001 systemd : Started MariaDB 10.1.44 database server. Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : / usr / bin / mysql_upgrade: the'-basedir' option is always ignored Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : Looking for'mysql' as: / usr / bin / mysql Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : Looking for'mysqlcheck' as: / usr / bin / mysqlcheck Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : This installation of MySQL is already upgraded to 10.1.44-MariaDB, use -force if you still need to run mysql_upgrade Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : Checking for insecure root accounts. Jul 22 13:24:37 shinshina-development-app-00000001 / etc / mysql / debian-start : Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables If you want to see only the last part of the log, combine the "-r" option. Please note that you will not be able to see the mariadb log unless you run it with sudo. Specify the unit "mariadb" with the "-u" option. Use the journalctl command to see the systemd logs. MariaDB start / stop log is output to systemd log. Servers such as MariaDB are centrally managed by a program called systemd. Restart simply executes the stop command and executes the start command. Run with root privileges using the sudo command. To restart MariaDB, use the systemctl command "restart". If the outage is successful, no successful message will be returned. To stop MariaDB, use the systemctl command "stop". Run with root privileges using the sudo command.Įven if the boot is successful, the message that it was successful is not returned. MariaDB is started using the systemctl command "start". May 19 10:53:02 development-batch systemd : Stopped MariaDB 10.1.44 database server. May 19 10:53:01 development-batch systemd : Stopping MariaDB 10.1.44 database server. May 18 12:38:50 development-batch / etc / mysql / debian-start : OK Main PID: 33941 (code = exited, status = 0 / SUCCESS) Process: 33941 ExecStart = / usr / sbin / mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code = exited, status = 0 / SUCCESS) If it is stopped, the following will be displayed.Īctive: inactive (dead) since Tue 10:53:02 JST 6s ago May 18 12:38:50 development-batch / etc / mysql / debian-start : Phase 7/7: Running'FLUSH PRIVILEGES' May 18 12:38:50 development-batch / etc / mysql / debian-start : Phase 6/7: Checking and upgrading tables May 18 12:38:50 development-batch / etc / mysql / debian-start : performance_schema May 18 12:38:50 development-batch / etc / mysql / debian-start : mysql May 18 12:38:50 development-batch / etc / mysql / debian-start : information_schema May 18 12:38:50 development-batch / etc / mysql / debian-start : Processing databases Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (running) since Mon 12:38:49 JST 22h ago If it is running, the following will be displayed. To check the status of MariaDB, use "status" of the systemctl command.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |