Shulou(Shulou.com)05/31 Report--

This article focuses on "sorting out common errors in MySQL installation". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "common errors in MySQL installation" bar!

Question 1: # mysql

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

Cause of problem: initialization issu

Solution: delete the data directory reconstruction and reinitialize.

Question 2:

Could not start the service mysql error:0 appears when you install and reinstall

Reason: when uninstalling mysql, the related files and services are not completely deleted, and need to be cleared manually

Question 3:

Make [2]: * No rule to make target `/ usr/lib/libcurses.so', needed by `bin/ccmake'. Stop.

Make [1]: * * [Source/CMakeFiles/ccmake.dir/all] Error 2

Make: * * [all] Error 2

Solution: cp / usr/lib64/libcurses* / usr/lib

Problem 4: there are no mysql users and groups.

Mysql server processes are generally run as non-root users. For security reasons, try not to use root users.

[root@db135 bin] # / mysqld_safe-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data

140704 16:10:10 mysqld_safe Logging to'/ usr/local/mysql/data/db135.err'.

Chown: "mysql": invalid user

Start the mysql server process, no user specified, the server process will run as the mysql user, if there is no user, an error will be reported.

Question 5:

[root@db135 mysql] #. / scripts/mysql_install_db-user=mysql

Installing MySQL system tables...

140704 16:13:37 [ERROR]. / bin/mysqld: Can't find file:'. / mysql/db.frm' (errno: 13)

ERROR: 1017 Can't find file:'. / mysql/db.frm' (errno: 13)

140704 16:13:37 [ERROR] Aborting

140704 16:13:37 [Note]. / bin/mysqld: Shutdown complete

Installation of system tables failed! Examine the logs in

. / data for more information.

Reason: permission error. You need to change the installation target owner and group to mysql before installation, otherwise an error will be reported in the initialization script execution.

Solution: chown-R mysql.mysql / appli

At this point, I believe you have a deeper understanding of "common errors in MySQL installation". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.