老师我执行在主从复制运行命令报错

来源：9-2 配置MySQL主从复制

SunXQ_

2017-05-09

在执行

GRANT REPLICATION SLAVE ON *.* to slave@192.168.235.135 identified by '123456';

报这个错

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

写回答

7回答

Jason

2017-05-09

目测都有权限，你root登录的时候输密码了吗

Jason

SunXQ_

直接mysql登录，不要用户名和密码，然后添加新的root用户

2017-05-09

共16条回复

Jason

2017-05-09

应该是当前用户没权限
查一下 select * from mysql.user where user="root" \G

SunXQ_

提问者

2017-05-09

[root@localhost xiaohange]# pkill mysqld

[root@localhost xiaohange]# mysqld_safe

170509 01:00:31 mysqld_safe Logging to '/usr/local/mysql/var/localhost.err'.

170509 01:00:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

mysql -u -p

Grant all on *.* to root@localhost identified by "123";

SunXQ_

提问者

2017-05-09

Host: ::1

User: root

Password: *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: Y

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

ssl_type:

ssl_cipher:

x509_issuer:

x509_subject:

max_questions: 0

max_updates: 0

max_connections: 0

max_user_connections: 0

plugin:

authentication_string:

SunXQ_

提问者

2017-05-09

Host: 127.0.0.1

User: root

Password: *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: Y

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

ssl_type:

ssl_cipher:

x509_issuer:

x509_subject:

max_questions: 0

max_updates: 0

max_connections: 0

max_user_connections: 0

plugin:

authentication_string:

SunXQ_

提问者

2017-05-09

Host: %

User: root

Password: *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: Y

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

ssl_type:

ssl_cipher:

x509_issuer:

x509_subject:

max_questions: 0

max_updates: 0

max_connections: 0

max_user_connections: 0

plugin:

authentication_string:

SunXQ_

提问者

2017-05-09

+-----------+------+-------------------------------------------+

| host | user | password |

+-----------+------+-------------------------------------------+

| % | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |

| 127.0.0.1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |

| ::1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |

+-----------+------+-------------------------------------------+

Yii2.0进阶版高级组件ES/Redis/Sentry优化京东平台

进阶更高阶的Yii 2.0开发，获得2-3年yii 2.0实战经验

514 学习 · 210 问题

查看课程

相似问题

Mac 虚拟机vmware fusion怎么配置，实现主从复制

回答 2

互为主从，互相监听问题

回答 1

老师在做主从的时候？如何确保从的同步数据节点与主是一致的？现在主库已经有N多数据了

回答 1

老师在做主从的时候？如何确保从的同步数据节点与主是一致的？现在主库已经有N多数据了

回答 1

老师,在yii2-dev的版本里面应该怎么用,他是没有commands这个文件夹的

回答 6

打开慕课网App查看更多内容