Several minor issues with MySQL in Linux

Several Problems with MySQL in Linux today:

Task to be completed: Use a local management tool to manage data on the server

In Linux:

/Usr/local/MySQL/bin/MySQL-uroot-p123456 // enter the MySQL Management Interface

Error:

Error 1045 (28000 ):
Access denied for user 'root' @ 'localhost' (using password: Yes)

Solution:

/Usr/local/MySQL/share/MySQL. server stop // close MySQL first

/Usr/local/MySQL/bin/mysqld_safe -- user = MySQL -- skip-grant-tables -- skip-Networking &

/Usr/local/MySQL/bin/MySQL-u root MySQL

Update user SET Password = PASSWORD ('000000') where user = 'root'; // modify the password

Restart MySQL Service

**************************

Authorize local ip192.168.1.48:

Mysql> grant all on *. * to root @ '192. 168.1.48 'identified by '20140901'; // authorize the IP address access permission

**************************************** ****************************

Local Database Management tools:

Use Database management tools-connect to data management data

Error: Error No 2003 can't connect to MySQL Server on192.168.1.23

My problem may be that the firewall is not closed. There are two solutions:

Disable firewall (1) service iptables stop (temporarily disable)

(2) chkconfig iptables off (effective after restart)

* ******* Connection successful