1、mysql_secure_installation 设置数据库密码
2、mysql -u root -p password -h 127.0.0.1；
以root账号，本地ip 127.0.0.1登录数据库
3、show databases；
查看数据库
4、use luodb；
进入数据库luodb
5、desc table1；
列出table1
6、select * from table1；
列出table1所有信息。
7、help 查看帮助
1、登录数据库：
[root@Centos7 ~]#mysql -uroot -p666666 -h 127.0.0.1
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 99
Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
2、查看数据库
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| blogdb |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
#有5个数据库
3、进入"mysql"这个数据库
MariaDB [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
4、列出当前数据库的表格
MariaDB [mysql]> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| time_zone_transition_type |
| user |
...部分省略
+---------------------------+
24 rows in set (0.00 sec)
#列出当前数据库的表格，可以看到有24个表格
5、查看user这个表格的结构
MariaDB [mysql]> desc user
-> ;
+------------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
...部分省略
42 rows in set (0.00 sec)
6、列出表格”user“的host、user、password三个字段的信息。
MariaDB [mysql]> select host,name,password from user;
ERROR 1054 (42S22): Unknown column 'name' in 'field list'
MariaDB [mysql]> select host,user,password from user;
+-----------------+--------+-------------------------------------------+
| host | user | password |
+-----------------+--------+-------------------------------------------+
| localhost | root | *B2B366CA5C4697F31D4C55D61F0B17E70E5664EC |
| centos7.luo.com | root | *B2B366CA5C4697F31D4C55D61F0B17E70E5664EC |
| 127.0.0.1 | root | *B2B366CA5C4697F31D4C55D61F0B17E70E5664EC |
| ::1 | root | *B2B366CA5C4697F31D4C55D61F0B17E70E5664EC |
| 127.0.0.1 | wpuser | *B2B366CA5C4697F31D4C55D61F0B17E70E5664EC |
+-----------------+--------+-------------------------------------------+
5 rows in set (0.00 sec)
7、help
MariaDB [mysql]> help
