dongwuming的专栏

MySQLhttps://www.digitalocean.com/community/tags/mysql数据库UbuntuUbuntu 18.04介绍MySQL是一个开源数据库管理系统，通常作为流行的LAMP（Linux、Apache、MySQL、PHP/Python/Perl）堆栈的一部分安装。它使用关系数据库和 SQL（结构化查询语言）来管理其数据。安装的简短版本很简单：更新你的包索引，安装mysql-server包，然后运行包含的安全脚本。sudo apt up...

使用dbeaver 创建新的连接，下载完mysql驱动后，连接报错： Can’t create driver instanceError creating driver ‘MySQL’ instance. Most likely required jar filesare missing. You should configure jars in driver settings. Reason:can’t load driver class ‘com.mysql.cj.jdbc.Driver’ .

正常来说直接执行pip安装，就是可以的，但是MySQL-python偏偏比较独特pip install MySQL-python报错：_mysql.c:44:10: fatal error: 'my_config.h' file not found #include "my_config.h" ^~~~~~~~~~~~~ 1 error generated. error: command 'cc' failed with exit status 1

我在遇到了数据库访问时错误，具体如下：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your      MySQL server version for the right

配置远程连接mysqlMySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;MySQL>FLUSH PRIVILEGES;远程连接mysql时mysql -h127.0.0.1 -u root -p报错:ERROR 2003 (HY000): Can’t co

关闭正在运行的 MySQL ：[root@www.woai.it ~]# service mysqld stop启用安全模式：[root@www.woai.it ~]# mysqld_safe --skip-grant-tables &为了安全可以这样禁止远程连接：[root@www.woai.it ~]# mysqld_safe --skip-grant-tables --skip-netwo

MySQL解决支持插入emoji表情等4字节字符失败1.打开数据库配置文件（centos在/etc/my.cnf），加入下面文字：[client]default-character-set= utf8mb4[mysqld]character-set-client-handshake = FALSEcharacter-set-server = utf8mb4colla...

SET GLOBAL innodb_file_format=Barracuda;SET GLOBAL innodb_file_per_table=ON;SET GLOBAL innodb_large_prefix=1;ALTER TABLE 表名字 ROW_FORMAT=DYNAMIC;ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4...

mac pip install MySQL-python IndexError: string index out of rangepip install mysql Collecting mysql Downloading https://files.pythonhosted.org/packages/06/ef/c4efbf2a51fb46aba9be03a973638d9539c...