ubuntu下安装mysql和一些命令

1。检查是否安装mysql

(base) joey@JoeySun:~$ dpkg -l|grep mysql

2。安装mysql

(base) joey@JoeySun:~$ sudo apt install mysql-server   //服务端

(base) joey@JoeySun:~$ sudo apt install mysql-client   //客户端

(base) joey@JoeySun:~$ sudo apt install libmysqlclient-dev   //程序编译时链接的库

3。安装完成后检查是否安装成功

(base) joey@JoeySun:~$ sudo netstat -tap|grep mysql

tcp        0      0 localhost:mysql         *:*                     LISTEN      8123/mysqld  

4。登录mysql

mysql -u root -p

然后输入密码

a。showdatabases;  //显示所有数据库

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

b。use mysql;  //进入某一数据库

c。show tables;  //显示所有表格

d。mysql> select * from user;  //显示user表格下内容