mysql latex_mysql

centos mysql

安装

# 下载 rpm

$ wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

# 安装 rpm

$sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

# 安装 mysql

$sudo yum install mysql-community-server

注意：centos7 选择 Red Hat Enterprise Linux 7.

mysql5.7之后，首次登录操作如下：

# 获取首次登录密码

$sudo grep 'temporary password' /var/log/mysqld.log

# 用获取的密码登录

$ mysql-uroot -p

# 修改密码

$ ALTER USER'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

报错:1130-host ... is not allowed to connect to this MySql server

mysql>use mysql;

mysql> update user set host = '%' where user = 'root';

mysql> selecthost, user from user;

mysql> FLUSH PRIVILEGES;

记得一定要flush privileges!!! 修改才能生效！

# 2019/5/22

python mysql-connector

Authentication plugin 'caching_sha2_password' is not supported python

mysql 8 用户认证插件默认采用 caching_sha2_password，而 mysql-connector 采用的是 mysql_native_password 编码，导致错误。

解决办法：

pip uninstall mysql-connector

pipinstall mysql-connector-python

# 2019/6/4

mysql 导出表结构：

# dbname 为要导出表结构的数据库名称

mysqldump-u root -p -d dbname >db.sql

mysql 导出数据：

# dbname 为要导出数据的数据库名

mysqldump-u root -p dbname >db.sql