CentOS 7.0 use yum to install simple configuration of MariaDB and MariaDB
I forgot about the environment configuration of the space that has been idle for a long time. I have to leave it empty today and reset the disk to re-build the environment. First, install the MariaDB database in CentOS 7.0, and record the installation process here, for later viewing.
1. Install MariaDB
Installation command
yum -y install mariadb mariadb-server
After MariaDB is installed, start MariaDB.
systemctl start mariadb
Set startup
systemctl enable mariadb
Next, configure MariaDB.
mysql_secure_installation
First, set the password. A prompt is displayed, indicating that the password is entered first.
Enter current password for root (enter for none): <-press Enter directly for the first time
Set 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 password of the root user
Re-enter new password: <-enter your password again
Other configurations
Remove anonymous users? [Y/n] <-whether to delete anonymous users, press ENTER
Disallow root login remotely? [Y/n] <-whether to disable remote root logon. Press enter,
Remove test database and access to it? [Y/n] <-whether to delete the test database. Press enter.
Reload privilege tables now? [Y/n] <-whether to reload the permission table. Press enter.
MariaDB Initialization is complete. Next, test logon.
mysql -uroot -ppassword
Complete.
2. Configure the MariaDB Character Set
File/etc/my. cnf
vi /etc/my.cnf
Add under the [mysqld] label
init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake
File/etc/my. cnf. d/client. cnf
vi /etc/my.cnf.d/client.cnf
Add in [client]
default-character-set=utf8
File/etc/my. cnf. d/mysql-clients.cnf
vi /etc/my.cnf.d/mysql-clients.cnf
Add in [mysql]
default-character-set=utf8
All configurations are complete. Restart mariadb.
systemctl restart mariadb
Then enter MariaDB to view the character set
mysql> show variables like "%character%";show variables like "%collation%";
Displayed
+ -------------------------- + ---------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------- +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +
8 rows in set (0.00 sec)
+ ---------------------- + ----------------- +
| Variable_name | Value |
+ ---------------------- + ----------------- +
| Collation_connection | utf8_unicode_ci |
| Collation_database | utf8_unicode_ci |
| Collation_server | utf8_unicode_ci |
+ ---------------------- + ----------------- +
3 rows in set (0.00 sec)
Character Set Configuration is complete.
3. Add users and Set permissions
Create USER commands
mysql>create user username@localhost identified by 'password';
Directly create user and authorize commands
mysql>grant all on *.* to username@localhost indentified by 'password';
Grant Internet login permission
mysql>grant all privileges on *.* to username@'%' identified by 'password';
Grant permissions and grant permissions
mysql>grant all privileges on *.* to username@'hostname' identified by 'password' with grant option;
This is basically the case for simple user and permission configuration.
Only some permissions are granted to change all privileges or all to select, insert, update, delete, create, drop, index, alter, grant, references, reload, shutdown, process, file.
Linux Tutorial: How to check the MariaDB server version
Implementation of MariaDB Proxy read/write splitting
How to compile and install the MariaDB database in Linux
Install MariaDB database using yum in CentOS
Install MariaDB and MySQL
How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu
Install MariaDB on the Ubuntu 14.04 (Trusty) Server