Today I updated MySql on the server. After the update, MySql started up and suddenly reported an error:
Then there are all kinds of Baidu, some say mysql directory permission is not given, some say the process already exists mysql and so on… Then I followed the experience of the big guys to try one by one, but, no effect! So toss about a morning, really have no way, finally reinstalled mysql. Thought this under the total should be good, there are any problems are reinstalled can not solve (proud). But as it turned out, I was still too young. Once again, he looks like the bird above!
If you look in the error directory, there is no hong.localdomain.pid. And then I hit on the idea, isn’t there a file called Hong.localdomain.pid?I copied a copy from my local computer, uploaded it to the server, and started mysql again. There you go! I kind of admire myself.
However, in order to be assured that I restart it again after mysql, ok, with reference to above, it is double Look again/WWW/wdLinux /mysql-5.5.27/var/ under hong. Localdomain. pid this file disappeared!
Calm down and think carefully, the file Hong.localdomain. pid actually records the PID of mysql installation, and the PID of my local mysql is definitely different from that of the server.
Edit /etc/init.d/mysql, find the start module, and add –user=root to mysqld_safe to
Then there are all kinds of Baidu, some say mysql directory permission is not given, some say the process already exists mysql and so on… Then I followed the experience of the big guys to try one by one, but, no effect! So toss about a morning, really have no way, finally reinstalled mysql. Thought this under the total should be good, there are any problems are reinstalled can not solve (proud). But as it turned out, I was still too young. Once again, he looks like the bird above!
If you look in the error directory, there is no hong.localdomain.pid. And then I hit on the idea, isn’t there a file called Hong.localdomain.pid?I copied a copy from my local computer, uploaded it to the server, and started mysql again. There you go! I kind of admire myself.
However, in order to be assured that I restart it again after mysql, ok, with reference to above, it is double Look again/WWW/wdLinux /mysql-5.5.27/var/ under hong. Localdomain. pid this file disappeared!
Calm down and think carefully, the file Hong.localdomain. pid actually records the PID of mysql installation, and the PID of my local mysql is definitely different from that of the server.
Edit /etc/init.d/mysql, find the start module, and add –user=root to mysqld_safe to
Read More:
- Node.js operation mysql error Cannot enqueue Handshake after invoking quit
- [Solved] MYSQLD: Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)
- [Solved] MySQL workbench Error: SSL connection error: SSL is required but the server doesn‘t support it.
- [Solved] error when starting dev server:Error: listen EACCES: permission denied 0.0.0.0:80 at Server.set
- Ranger Install Error: [E] ranger_core_db_mysql.sql file import failed!
- [Solved] pagehelper Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 1’
- [Solved] MAC Nginx Error: ginx.pid“ failed (2: No such file or directory)
- ROS Gazabo Error: [ERROR]: No p gain specified for pid. Namespace: /gazebo_ros_control/pid_gains/ ×65374;
- cannot create windows service for mysql. error:0 [How to Solve]
- [Solved] docker: Error response from daemon: driver failed programming external connectivity on endpoint mysql-test …
- rsync error: error starting client-server protocol (code 5) at main.c(1648) [Receiver=3.1.2]
- How to Solve canal & MYSQL or “Kafka cannot consume data” Error
- Sqoop exports hive data to MySQL Error [How to Solve]
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- Exception: logstash:: pluginloadingerror when importing MySQL data into es in Windows
- [Solved] Flinkcdc error: tried to access field com.mysql.cj.CharsetMapping.COLLATION_INDEX_TO_COLLATION_NAME…
- “Error 0162 – Setup data integrity check failure” after updating BIOS via Thinkvantage
- [Solved] PostgreSQL Error: Could not connect to server: no such file or directory
- [Solved] Android7 8 Jack server SSL error: Jack server failed to (re)start, try ‘jack-diagnose’ or see Jack server log
- Error starting ApplicationContext. To display the auto-configuration report re-run your application