Linux环境下mysql shell 操作

喜欢ヅ旅行 2022-03-17 05:40 211阅读 0赞

1.  创建数据库，创建用户
2.  登录mysql

\[root@izwz99z5o9dc90keftqhlrz ~\]\# mysql -u root –p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70][]

1.  创建数据库

mysql> create database dsb\_crm;

![20190222162615927.png][]

1.  为新用户分配该数据库的权限

mysql> grant all privileges on \`dsb\_crm\`.\* to 'dsb'@'%' identified by 'Dsb2019!@\#';

![2019022216261637.png][]

1.  切换至目标数据库

mysql> use dsb\_crm ;

Database changed

mysql> show tables ;

Empty set (0.00 sec)

mysql>

1.  设置数据库编码

mysql> set names utf8;

![20190222162616139.png][]

1.  导入数据

mysql> source /tmp/sys-log.sql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70 1][]

1.  查看表结构

![2019022216261645.png][]

1.  一些常用的命令

mysql> show databases;

![2019022216261658.png][]

mysql> select \* from sys\_log ;

![2019022216261649.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70]: /images/20220317/178401867f7e4d0bafd7552bf3cf39eb.png
[20190222162615927.png]: /images/20220317/076c95fd42a246c4964726a7e9f8fbe3.png
[2019022216261637.png]: /images/20220317/4fb10d6192b8479a9afbd8754593408d.png
[20190222162616139.png]: /images/20220317/05325fdc08c442e1bae158448d278a89.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lleGlhb21vZGVtbw_size_16_color_FFFFFF_t_70 1]: /images/20220317/8f72133dccb44ef3af03ba93df151580.png
[2019022216261645.png]: /images/20220317/08b8941e7f954ef7a240fe8993ad364c.png
[2019022216261658.png]: /images/20220317/11de4d55f0744298b4e07ca7ab367719.png
[2019022216261649.png]: /images/20220317/99b71eb6dc9f42f9972700dfe81372a4.png