Install MariaDB and mariadb in CentOS7
Install MariaDB1.
yum -y install mariadb mariadb-server
2. After MariaDB is installed, start MariaDB first.
systemctl start mariadb
3. Set startup
systemctl enable mariadb
4. Perform simple configuration of MariaDB
Mysql_secure_installation ** 1) First, set the password. You will be prompted to Enter the password ** enter current password for root (Enter for none ): <-when you first run the command, press enter [1] to Set the password Set root password? [Y/n] <-whether to set the root user password. enter y and press enter or press enter New password: <-set the root user password Re-enter new password: <-enter the password you set again [2] other configuration Remove anonymous users? [Y/n] <-do you want to delete anonymous users? Enter y and press ENTER or press Disallow root login remotely? [Y/n] <-do you want to disable remote root login? Enter n and press enter to Remove test database and access to it? [Y/n] <-do you want to delete the test database? Enter y and press ENTER or press enter to Reload privilege tables now? [Y/n] <-whether to reload the permission table. Enter y and press ENTER or press ENTER ** 2) to initialize MariaDB, next, test logon. ** mysql-uroot-p <-press enter and enter the password.
Configure the MariaDB Character Set editing file/etc/my. cnf
[1] vi/etc/my. cnf [2] add init_connect = 'set collation_connection = utf8_unicode_ci 'init_connect = 'set NAMES utf8' character-SET-server = utf8 collation-server = javasskip- character-set-client-handshake
Edit the/etc/my. cnf. d/client. cnf File
[1] vi/etc/my. cnf. d/client. cnf [2] add default-character-set = utf8 under the [client] Tab
Edit file/etc/my. cnf. d/mysql-clients.cnf
[1] vi/etc/my. cnf. d/mysql-clients.cnf [2] add default-character-set = utf8 under the [mysql] Tab
All configurations are complete. Restart mariadb.
systemctl restart mariadb
Go to MariaDB to view the character set
mysql -u root -pshow variables like "%character%";
+--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.01 sec)
show variables like "%collation%";
+----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | utf8_general_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec)
Enable remote connection
Disable firewall or open port 3306
Disable Firewall
systemctl stop firewalld.service systemctl disable firewalld.service
Allow port 3306 (recommended)
firewall-cmd --zone=public --add-port=3306/tcp --permanent
Enable remote connection
Enable remote connection from any IP address of the root user
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION; flush privileges;
Enable the remote connection of the specified IP address of the root user (recommended)
Grant all privileges on *. * TO 'root' @ 'the IP address 'identified BY 'root' with grant option; flush privileges;