数据库配置查询

基本配置：

[root@serverX ~]# yum -y install mariadb-server mariadb    

[root@serverX ~]# vim /etc/my.cnf 

[mysqld] 

skip-networking           //添加行跳过网络

[root@serverX ~]# systemctl restart mariadb

[root@serverX ~]# systemctl enable mariadb

[root@serverX ~]# mysqladmin -u root -p password 'atenorth' //设置密码

[root@serverX ~]# mysql -u root -p

MariaDB [(none)]> create database Contacts;    //建立组

MariaDB [(none)]> grant select on Contacts.* to Raikon@localhost identified by 'atenorth';      //设置权限密码

MariaDB [(none)]> delete from mysql.user where Password='';           //删除空密码用户

MariaDB [(none)]> quit

mysql_secure_installation     //可直接实现设置密码，删除空密码账户等操作。

[root@serverX ~]# wget http://classroom/pub/materials/users.sql        //下载导入

[root@serverX ~]# mysql -u root -p Contacts < users.sql

数据库查询：

[root@serverX ~]# mysql -u root -p

Enter password:

MariaDB [Contacts]> use Contacts;

MariaDB [Contacts]> select name from base where password='solicitous';

MariaDB [Contacts]> select count(*) from base,location where base.name='Barbara' and location.city='Sunnyvale' and base.id=location.id ;

1