centos7怎么修改mysql默认配置

centos7怎么修改mysql默认配置

编辑他的配置文件
vi /etc/my.cnf

1.登陆mysql或者mariadb(两种任选其一) ? 1 2 [root@localhost ~]# mysql -u root [root@localhost ~]# mysql -uroot -p 2.切换到存储用户名和密码的数据库 ? 1 2 3 mariadb [mysql]> use mysql;回车，会显示以下内容 reading table information for completion of table and column names you can turn off this feature to get a quicker startup with -a database changed 3.修改密码，适用password()函数进行加密，实际上就是执行sql语句来更新指定用户的密码 ? 1 2 3 4 mariadb [mysql]> update user set password=password('新密码') where user='要更新密码的用户名';回车 -> ; query ok, 0 rows affected (0.00 sec) rows matched: 5 changed: 0 warnings: 0 4.刷新用户权限列表 ? 1 2 mariadb [mysql]> flush privileges;回车 query ok, 0 rows affected (0.00 sec) 5.退出mysql登陆 ? 1 2 mariadb [mysql]> quit bye 6.重启mysql或者mariadb服务 ? 1 2 [root@localhost ~]# service mysqld restart(重启mysql) [root@localhost ~]# service mariadb restart(重启mariadb)