MySQL installation common error grooming

Question one: #mysql

ERROR 1045:access denied for user ' root ' @ ' localhost ' (using Password:no)

Problem Reason: initialization problem

WORKAROUND: Delete the data directory rebuild and reinitialize.

Question two:

When you install and reload the could not start the service MySQL error:0
cause: uninstalling MySQL does not completely delete the relevant files and services, you need to manually clear

Question three:

MAKE[2]: * * * No rule to do 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 four: There are no MySQL users and groups.

The MySQL server process is generally run as a non-root user, so as not to use the root user for security purposes.

[Email protected] 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, without the specified user, the server process will run as a MySQL user, if there is no such user error.

Question five:

[Email protected] 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.

Cause: permission error. Before installing, you need to change the installation target owner and group to MySQL, otherwise perform an error in initialization script.

Solution:chown-r mysql.mysql/appli

cation/mysql/

MySQL installation common error grooming