ubuntu 20.04安装mysql 和python mysql的使用

sudo apt-get install mysql-server

service mysql start

service mysql status

查看默认密码:

sudo cat /etc/mysql/debian.cnf

账号密码如下：

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = gDJxvReu3pA7DDXr
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = gDJxvReu3pA7DDXr
socket   = /var/run/mysqld/mysqld.sock

使用默认用户名及密码登录mysql
用户名：debian-sys-maint
密码：gDJxvReu3pA7DDXr

登录：

mysql -u debian-sys-maint -p 

输入密码

gDJxvReu3pA7DDXr

show databases;#查看所有数据库
use mysql; #连接到mysql数据库

quit;#退出

连接其他服务器

别人给了我一个mysql的帐号密码，如下：
Username: publish
Password: xxxxx
URI: 172.16.110.100:43306
我该怎么样用mysql命令进入该数据库查看内容

mysql -u publish -p -h 172.16.110.100 -P 43306

show databases;

use publish_platform

show tables;

select * from stub_events where  name = "$AAAAA" order by id desc limit 10;

select * from stub_events where vehicle_name = "Adfdff" and name = "$AAAAA" order by id desc limit 10;

python mysql下载图像

import pymysql


#连接数据库
# db = pymysql.connect("172.16.110.100:43306","publish","R65ZDrV85i","publish_platform")

try:
    db = pymysql.connect(host="172.16.110.100", port=43306, user='publish', password='xxxxxxxxxx', db='publish_platform')
    print(db)
    print("mysql connect success")
    #使用cursor()方法创建一个游标对象
    cursor = db.cursor()

    #使用execute()方法执行SQL语句

    cursor.execute("SELECT * FROM stub_events WHERE name = '$xxxxx' ORDER BY id DESC LIMIT 20")
    #使用fetall()获取全部数据
    data = cursor.fetchall()
    len_data=len(data)
    print(len_data)
    for i in range(len_data):
        # print(data[i])
        # print(data[i][0])
        # print(data[i][1])
        # print(data[i][2])
        # print(data[i][3])
        # print(data[i][4])
        # print(data[i][5])
        # print(data[i][6])
        # print(data[i][7])
        # print(data[i][8])
        # print(data[i][9])
        # print(data[i][10])
        # print(data[i][11])
        # print(data[i][12])
        # print(data[i][13])
        # print(data[i][14])
        # print(data[i][15])
        # print(data[i][16])
        print(data[i][17])
        image_name=data[i][17]
        image_url="https://s.xxxxxx.cn/vxxxxxxxx/"+image_name
        print("image_path=",image_url)
        # 移除字符串开头的 '$'
        filename_without_dollar = image_name[1:]

        # 将所有 '/' 替换为 '_'
        filename_with_underscores = filename_without_dollar.replace('/', '_')

        # 将文件扩展名从 '.jpeg' 改为 '.jpg'
        final_filename = filename_with_underscores.replace('.jpeg', '.jpg')

        print(final_filename)
        import requests
        res=requests.get(image_url)
        with open(final_filename ,'wb') as f:
            f.write(res.content)

        # print(data[i][18])
        # print(data[i][19])
        # print(data[i][20])
    #打印获取到的数据
    #print(data)

    #关闭游标和数据库的连接
    cursor.close()
    db.close()
except pymysql.Error as e:
    print("mysql connect error：",e)