![]() 13:53:07 22618 InnoDB: Waiting for purge to start 13:53:07 22618 InnoDB: Highest supported file format is Barracuda. 13:53:07 22618 InnoDB: Completed initialization of buffer pool 13:53:07 22618 InnoDB: Using CPU crc32 instructions 13:53:07 22618 InnoDB: Using Linux native AIO 13:53:07 22618 InnoDB: Memory barrier is not used 13:53:07 22618 InnoDB: Mutexes and rw_locks use GCC atomic builtins 13:53:07 22618 InnoDB: The InnoDB memory heap is disabled 13:53:07 22618 InnoDB: Using atomics to ref count buffer pool pages I am facing issue during replication implementation but not got solution: Start the MySQL service /etc/init.d/mysqld start In the above snippet the MySQL is summed to be running on remote server 121.121.134.123 Step 3: If you are using remote server for MySQl then provide the server IP in the bind-address field. You may comment the bind-address field if MySQL service is running on the server itself. Set the bind address IP as per the requirement (mostly localhost / 127.0.0.1) bind-address = 127.0.0.1 Start the MySQL service using below command: /etc/init.d/mysqld start Scenario 2: Step 1:Ĭheck the bind address in the MySQL configuration file my.cnf generally locate at /etc/my.cnf. Note: pid is the proceed id you get after running command specified in step 3. If MySQL service is found running in step 3 then kill the service using below command: kill -9 pid If any other service is running on the port 3306 then you will have to either configure MySQL to run on port other than 3306 or stop the service running on port 3306, re-configure its port to some other port number.Ĭheck this post for all the steps to change default port number 3306 on which MySQL service runs. If port is still in use then check the service running on it. etc/init.d/mysqld stop Step 3:Ĭheck if MySQL service port 3306 is still in use or not by running below command: netstat -apn | grep 3306 If MySQL service is running then stop the service by running below command else skip to step 3. Check the MySQL service status by running below command: /etc/init.d/mysqld status Step 2: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |