Install MySQL Common Errors and Solutions

The following error occurs when installing MYSQL:

1.

Checking for tgetent in-ltermcap... no
Checking for termcap functions library... configure: Error: No curses/termcap library found

Solution:

Yum-y install ncurses-devel

2.

../Depcomp: Line 571: Exec: G ++: not found

Solution:

Use the following two commands to install GCC and GCC-C ++:

Yum-y install gcc

Yum-y install gcc-C ++

3.

Command: mysqladmin password 'Password'

Bash: mysqladmin not found

Solution: add the path name "mysqladmin" to "Configure -- prefix =" XXX "and run it in MySQL/bin]

4.

Error:/usr/local/MySQL/bin/mysqld: Unknown option '-Skip-bdb'

Solution: if there is a my. CnF in/etc/MySQL, change the name of/etc/MySQL/My. CNF.

5.

Error: 'Can't connect to local MySQL server through socket '/tmp/MySQL. Sock' (2)

Solution: ln-S/var/lib/MySQL. Sock/tmp/MySQL. Sock

6. Error 1290 (hy000) occurs when Grant all privileges is used to authorize MySQL.

An error occurs when Grant all privileges on *. * To root@192.168.0.3 identified by "123" is used to grant remote access to the MySQL database:
Error 1290 (hy000): the MySQL server is running with the -- skip-grant-tables option so it cannot execute this statement.
The solution is as follows:
Flush privileges.
Run the grant all command again.