linux下安装mysql初始密码,centos7下安装mysql6初始化安装密码

这里将告诉您centos7下安装mysql6初始化安装密码,具体完成步骤:

1.先停止数据库服务器

service mysqld stop

2.vim /etc/my.cnf

3.配置文件添加skip-grant-tables

[root@VM_0_8_centos ~]# vim /etc/my.cnf

# For advice on how to change settings please see

# /d/file/shujuku/e2uykriwzw0.html

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-grant-tables 此处！！！！！！

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

4.重启数据库

systemctl restart mysql

5.登录数据库

mysql-uroot-p

如果询问密码，直接空密码登录

6.set password for root@localhost = password('123456');括号里面的密码你自己修改。

7.mysql-uroot-p123456 登录成功

题外话：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' 设置允许远程访问

firewall-cmd --zone=public --add-port=3306/tcp --permanent 开放3306端口centos7下安装mysql6初始化安装密码就为您介绍到这里，感谢您关注懒咪学编程c.lanmit.com.

本文地址：https://c.lanmit.com/czxt/Linux/119453.html