Skip to content
Wednesday, June 14, 2023
Latest:
  • How to create Round Buttons and Square Buttons
  • Basic and Simple Examples of Skills with CSS
  • How to SUM Columns value in MYSQL
  • How to create a data table in bootstrap PHP and MySQL ?
  • How to DELETE Data Into MySQL Database Using PHP ?

Eduguru

Tech Blog and Discussion

  • Blog
  • Discussion
  • Asterisk Support
  • Contact Us
  • Quiz
    • C Program
    • C – Input/Output
    • PHP Program
    • Basic SQL

I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST=’127.0.0.1′

MySQL Cluster
Databse mysql 

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

September 4, 2014May 21, 2015 eduguru 0 Comments 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_HOST='127.0.0.1', 0 rows affected (0.00 sec) mysql> reset slave; Query OK, 0 rows affected (0.06 sec), ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log, I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_LOG_FILE='mysql-bin.000000', MASTER_LOG_POS=12345; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log In the error log i didn't see anything, MASTER_LOG_POS=12345; Query OK, MASTER_PASSWORD = 'pass', MASTER_PASSWORD = 'password', MASTER_PORT=53306, MASTER_USER='username', so after googling some time I found the solution: mysql> flush slave; Query OK

I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST=’127.0.0.1′, MASTER_PORT=53306, MASTER_USER=’username’, MASTER_PASSWORD = ‘password’, MASTER_LOG_FILE=’mysql-bin.000000′, MASTER_LOG_POS=12345; ERROR

Read more

Recent Article

  • How to create Round Buttons and Square Buttons
  • Basic and Simple Examples of Skills with CSS
  • How to SUM Columns value in MYSQL
  • How to create a data table in bootstrap PHP and MySQL ?
  • How to DELETE Data Into MySQL Database Using PHP ?
  • How to Create MySQL user and Grant permission ?
  • What is XML & HTML ? What is Difference Between XML & HTML?
  • What is MySQL Binary logs ,their usages and how to purge binary logs ?
  • How to Select Data Into MySQL Database Using PHP ?
  • How to Remove spaces from string in MySQL ?
  • What is Different Between CHAR & VARCHAR ?
  • How to Insert Data Into MySQL Database Using PHP
  • What is MySQL SELECT Statement And Example of MySQL SELECT Query
  • What is INSERT Statement And Example of INSERT Query ?
  • What is MySQL Cluster vs Replication ?

Tags

1st Semester Question Paper Artificial intelligence basics of java C# coronavirus c program c program example c programming c tutorial c tutorials cyber security download bca question paper Download bca Question Paper december 2017 download ignou bca question dec 2017 download previous year question paper Download Question Paper december 2017 Download Question Paper June 2017 ETHICAL HACKING HACKERS HACKING html ignou IT- Security Java java basics java program java programming java tutorials learn c let us C Linux MySQL NEW TECHNOLOGY Question Paper Download RESEARCH AND INNOVATION security Software software testing technology testing ubuntu UNIX web-app web-site Write a C Program
Copyright © 2023 Eduguru. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.