There is nothing you can do about the previous libraries and tables. However, after modifying the character set of the database, it will only take effect for libraries and tables created later. Plus init_connect = 'SET NAMES utf8' (set utf8 encoding when connecting to mysql database to make mysql database run as utf8) Some add default character set = utf8, but the service cannot be started after I use centos7 In order to solve the problem of Chinese garbled codeīy modifying the configuration file my.cnf, add character set server = utf8 under See MySQL Code, two are not utf-8，If you enter Chinese, there will be garbled code You can directly mysql -u root -p show variables like 'character%' If mysql or mariadb has been installed before and the user has not been deleted, the original user password file is still there. Service rvice status All four methods can display the service statusĬonfigure mysql, just like mariadb mysql_secure_installation To delete with rpm，yum OK, but the deletion may not be complete. Note: if installed mysql，Will completely overwrite the previous mariadb，yum install mysql Change to download Mysql(The default is mariadb)
This step may take some time, and the previous will be overwritten after the installation is completed mariadb If the download path is not specified, it will be installed in the current folder by defaultįrom yum Install in Library mysql-community-server ((you can't start the service without this) Wget Download instructions url of rpm Package. Wget Command passed yum install wget Download and install
Install package from the official website wget # download package You can use rpm -qa | grep mariadb to see whether to install mariadb (rpm -qa is used to query all installed software packages)
Therefore, CentOS 7 has mariadb by default. MariaDB aims to be fully compatible with MySQL, including API and command line Easily become a substitute for MySQL. One of the reasons for developing this branch is that after Oracle acquires mysql, there is a potential risk of closing the source of MySQL, so the community adopts the branch method to avoid this risk.
MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community and licensed by GPL. Installing MySQL on Linux (Centos7) View system html]# cat /etc/redhat-releaseĬentOS 7 removes MySQL database software from the default program list and replaces it with mariadb
0 kommentar(er)
