centos7下安装mysql6初始化安装密码的方法_Mysql

centos7下安装mysql6初始化安装密码的方法

2021-01-21 16:30一夜听春雨 Mysql

这篇文章主要介绍了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

									# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.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 登录成功

PS：下面看下Mysql初始化root密码和允许远程访问

mysql默认root用户没有密码，输入mysql –u root 进入mysql

1、初始化root密码

进入mysql数据库

1	`mysql>update` `user` `set` `password=PASSWORD(‘123456') where User='root';`

2、允许mysql远程访问,可以使用以下三种方式:

a、改表。

									mysql -u root –p

									mysql>use mysql;

									mysql>update user set host = '%' where user = 'root';

									mysql>select host, user from user;

b、授权。

例如，你想root使用123456从任何主机连接到mysql服务器。

1	`mysql>GRANT` `ALL` `PRIVILEGES` `ON` `.` `TO` `'root'@'%'` `IDENTIFIED` `BY` `'123456'` `WITH` `GRANT` `OPTION;`

如果你想允许用户jack从ip为10.10.50.127的主机连接到mysql服务器，并使用654321作为密码

1 2	`mysql>GRANT` `ALL` `PRIVILEGES` `ON` `.` `TO` `'jack'@'10.10.50.127'` `IDENTIFIED` `BY` `'654321'` `WITH` `GRANT` `OPTION;` `mysql>FLUSH RIVILEGES`

c:在安装mysql的机器上运行：

									//进入MySQL服务器

									d:\mysql\bin\>mysql -h localhost -u root

									//赋予任何主机访问数据的权限

									mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION

									//使修改生效

									mysql>FLUSH PRIVILEGES

									//退出MySQL服务器

									mysql>EXIT