前言
mysql的相关配置,mysql修改root密码,mysql修改字符集,mysql修改表名不区分大小写,mysql开通root用户远程访问权限。
一、mysql修改root密码
1. 修改/etc/mysql/mysql.conf.d/mysqld.cnf文件,在[mysqld]下加入skip-grant-tables=1,如下图:
2. systemctl restart mysql,重启mysql服务;
3. mysql -u root -p直接回车,就可以进入mysql;
4. 修改密码:
> use mysql;
> update user set authentication_string=PASSWORD("要修改的密码") where User='root';
> flush privileges;
> quit;
5. 将/etc/mysql/mysql.conf.d/mysqld.cnf文件中的skip-grant-tables=1参数删掉;
6. systemctl restart mysql,重启mysql服务;
二、mysql修改字符集
1. 修改/etc/mysql/mysql.conf.d/mysqld.cnf文件,在[mysqld]下加入 character-set-server=utf8;
2. 修改/etc/mysql/debian.cnf文件,在[client]下加入character-set-server=utf8;
3. systemctl restart mysql,重启mysql服务;
4. 验证;
> show variables where variable_name like '%character%';
三、mysql修改表名不区分大小写
1. 修改/etc/mysql/mysql.conf.d/mysqld.cnf文件,在[mysqld]下加入lower_case_table_names=1;
2. systemctl restart mysql,重启mysql服务;
3. 验证;
> show variables like '%case_table%';
四、mysql开通root用户远程访问权限
1. 修改/etc/mysql/mysql.conf.d/mysqld.cnf文件,将“bind-address = 127.0.0.1”参数注释掉;
2. 进入数据库;
> use mysql;
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
> FLUSH PRIVILEGES;
> quit;
3. systemctl restart mysql,重启mysql服务;