mysql学习笔记

# 安装服务
mysqld --install mysql --defaults-file=D:\mysql-5.6.40-winx64\my.ini
# 启动服务
net start mysql
# 连接服务器
mysql -u root -h 127.0.0.1 -P 3307 -p
# 修改root密码
USE mysql;
UPDATE USER SET PASSWORD=PASSWORD('xx123456') WHERE USER='root';
# 创建新用户
CREATE USER lniwn IDENTIFIED BY 'xxxx';
# 分配远程访问权限
GRANT ALL PRIVILEGES ON *.* TO 'lniwn'@'%' IDENTIFIED BY 'xxxx';
# 应用权限变更
FLUSH PRIVILEGES;

sudo apt-get update
sudo apt-get install mysql-server
mysql_secure_installation

# 创建指定字符集的数据库
CREATE DATABASE IF NOT EXISTS yyfastbrowser DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# 修改数据库字符集
ALTER DATABASE `yyfastbrowser` CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE 'tablename' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;