1. 安裝和開機(jī)啟動(dòng)
#yum install mysql
#yum install mysql-server
#yum install mysql-devel
#yum install mariadb-server mariadb
#systemctl start mariadb
2. 設(shè)置配置文件:
#vi /etc/my.cnf
[mysqld]
#skip-grant-tables
character_set_server=utf8
init_connect='SET NAMES utf8'
3. 連接和設(shè)置密碼并開啟遠(yuǎn)程連接
#mysql -u root -p
MariaDB [(none)]> set password for 'root'@'localhost' =password('123456');
MariaDB [(none)]> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;