create database IPTV default character set utf8 collate utf8_general_ci;
COLLATE utf8_general_ci:数据库校对规则。ci是case insensitive的缩写,意思是大小写不敏感;相对的是cs,即case sensitive,大小写敏感;还有一种是utf8_bin,是将字符串中的每一个字符用二进制数据存储,区分大小写。
show variables like '%character%';
vim /etc/my.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
character-set-server=utf8
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Linux 卸载mysql
要在Linux系统中卸载MySQL,可以使用包管理器,如果你是通过包管理器安装的MySQL,例如使用apt
(Debian系)或yum
(RedHat系),可以按照以下步骤进行:
对于Debian系(如Ubuntu):
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
对于RedHat系(如CentOS)
sudo yum remove mysql mysql-server
如果你是通过直接下载二进制包或者从源代码编译安装的MySQL,那么你需要手动删除相关文件和目录。
手动删除二进制文件和数据目录:
sudo rm -rf /usr/local/mysql
sudo rm -rf /var/lib/mysql
sudo rm -rf /etc/my.cnf
docker安装 mysql 8
1.拉镜像
docker pull mysql:8.0
mkdir -p /mydata/mysql/data
mkdir -p /mydata/mysql/conf
touch /mydata/mysql/my.cnf
2 修改 mydata/mysql/my.cnf 下的信息
vi /mydata/mysql/my.cnf
在my.cnf中添加如下信息
[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=caching_sha2_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000
lower_case_table_names = 1
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
挂载 mysql,指定容器,挂载目录
sudo docker run --restart=always -p 3306:3306 --name mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql/conf.d \
-v /mydata/mysql/my.cnf:/etc/mysql/my.cnf \
-e MYSQL_ROOT_PASSWORD=Shujuku@3306 \
-d mysql:8.0
重启docker
docker restart mysql
docker update mysql --restart=always
docker ps -a
docker exec -it mysql bash
mysql -uroot -p123456
1. 输入命令,进入msyql 输入密码
mysql -uroot -p
2. 修改密码:
ALTER USER 'root'@'%' IDENTIFIED BY 'Shujuku@3306' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Shujuku@3306';