Ubuntu22.04 安装mysql

Ubuntu22.04 安装mysql

安装sudo apt update sudo apt install -y mysql-server sudo mysql 改密码use mysql; alter user 'root'@'localhost' identified with mysql_native_password by '123456'; flush privileges; 开启远程use mysql; select user,host from user; update user set host = '%' where user = '您的用户'; flush privileges; su...

基础运维 2023-03-03 AM
jupyter 导出HTML 报错500

jupyter 导出HTML 报错500

500报错 nbconvert failed: module 'jinja2' has no attribute 'Markup'报错原因是jinja2 版本问题,高版本中部分功能名称修改了导致报错,修改其为指定版本就解决了执行pip3 install -I jinja2==3.0.3

基础运维 2023-02-06 AM
golang 编译报错unrecognized relocation (0x2a) in section  问题修复

golang 编译报错unrecognized relocation (0x2a) in section 问题修复

报错/usr/local/go/pkg/tool/linux_amd64/link: running gcc failed: exit status 1 /usr/bin/ld: /tmp/go-link-2149430067/000031.o: unrecognized relocation (0x2a) in section `.text' /usr/bin/ld: final link failed: Bad value 查看ld 版本 ,使用命令:ld -v,得知当前版本 ;大概率是ld版本过低,因此使用更高版本。移除当前的ld命令yum remove -y binutils 重...

经验开发,基础运维 2023-01-10 AM
confluent-kafka-go依赖 librdkafka-devel 安装

confluent-kafka-go依赖 librdkafka-devel 安装

golang项目依赖confluent-kafka-go。这个包是 librdkafka(c++) 项目的golang绑定,所以需要在机器上安装正确的librdkafka包项目才能编译成功我们服务器centos7。 按照文档说明配置yum 源:sudo rpm --import https://packages.confluent.io/rpm/7.2/archive.key 配置源创建 vim /etc/yum.repos.d/confluent.repo,内容如下:[Confluent] name=Confluent repository baseurl=https://packag...

经验开发 2023-01-10 AM
mysql 表结构查询

mysql 表结构查询

查询mysql表结构,表注释,表主键,字段类型,字段长度等select distinct t.TABLE_SCHEMA, t.TABLE_NAME, t.TABLE_COMMENT, t1.COLUMN_NAME, t1.COLUMN_TYPE, t1.IS_NULLABLE, t1.COLUMN_DEFAULT, t1.COLUMN_COMMENT, t1.COLUMN_KEY from information_schema.`tables` t inner join information_schema....

经验开发 2023-01-09 PM