mysql相关

mysql的id重新排序

alter table eu_escort drop id;

alter table eu_escort add id int(10) primary key auto_increment first;

root账户创建可远程访问高权限的mysql账户

1. 登录MySQL

mysql -u root -p

2. 创建poker_play用户,允许远程连接

sql-- 创建用户，'%' 表示允许从任何IP连接

CREATE USER 'poker_play'@'%' IDENTIFIED BY '设置你的密码';

3. 授予创建数据库的权限

GRANT ALL PRIVILEGES ON *.* TO 'poker_play'@'%' WITH GRANT OPTION;

4. 刷新权限

FLUSH PRIVILEGES;

5. 验证用户创建成功

查看用户权限

SHOW GRANTS FOR 'poker_play'@'%';

查看所有用户

SELECT User, Host FROM mysql.user WHERE User = 'poker_play';

6. 退出MySQL

EXIT;

7. 配置MySQL允许远程连接

编辑MySQL conf文件：

在mysqld下添加或修改bind-address：

# bind-address = 127.0.0.1

bind-address = 0.0.0.0

8. 重启MySQL服务

systemctl restart mysql