Linux installs and configures issues that are logged during MySQL and Redis processes

Chapter Catalogue

• Mysql
• Redis

There are many tutorials for deploying MySQL and Redis online under Linux, and here are some of the issues and workarounds that I have encountered during my deployment and configuration.

MySQL① when the installation is complete, the error starting mysql.the server quit without updating PID file to kill/etc/my.cnf The reason is: Mysql_safe under the specified/var/run/mari ADB and/var/log/mariadb do not exist or you can choose to create both directories ② local access after installation, but the remote machine is inaccessible

It needs to be configured so that MySQL can be accessed remotely.  Update user set host= '% ' where user= ' root '; This will error error 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY ' plus and host = ' localhost ', will not be an error, the above should be written to cause the primary key duplication. it will not take effect at this time, call flush privileges;

③ The root account has no permissions to connect to MySQL locally when a user with a user name is empty

Workaround: At this time telnet is possible, delete the user name is empty user, run flush privileges;

Redis① execute command without response using REDIS-CLI tool

After Redis is installed, use the REDIS-CLI tool to connect to the service side, but when you press ENTER to execute the command, the console simply wraps and does not return the result.

Ask others to understand that this phenomenon is the Redis server does not respond, so

Ps-ef|grep 6379 Identify the Redis server process and

Kill-9 the upper command to see the PID kill Redis-server Process

Then restart Redis-server, execute the command again, it's normal.

Http://www.cnblogs.com/tzyy/p/4864640.html

Linux installation and configuration problems logged during MySQL, Redis (GO)