Ubuntu installation MySQL process and remote problem solving

performed under Ubuntu sudo apt-get instlll mysql-serversudoinstall mysql-client

There will be a text interface setting password during installation.

Remember the password

MySQL graphical tool Green Edition recommended

Mysql Workbench:

https://yunpan.cn/cPSFXPvGEhh5v Access Password f31c

Navicat for Mysql: (recommended)

Https://yunpan.cn/cPSFW83eSk9kU Access Password 6317

Local connection:

Mysql–h 127.0.0.1–u root–p

Local Area Connection: Mysql–h127.0.0.1–u root–p No problem LAN connection such as MySQL-H192.168.126.131-U Root-P 2003 Error resolution: Due to Ubuntu under Default configuration binding IP is modified for local IP/etc/MySQL under my.cnfVI/etc/mysql/my.cnf in Bind-address =127.0.0.1Pre-Add # comment execution/etc/init.d/MySQL Restart Restart issue update appears 1045 verification error The ultimate solution: MySQL local MySQL-U Root-p Enter mysqluse MySQLSelectUserpasswd, host from user; View user name Password grant all privileges on*. * To'ROOT'@'*'Identified by"'With grant option grants all external permissions orupdate user SET Password=password ('NewPassword') Where user='Root'; Establish the same password for all users finally execute flush privileges; Refresh

Ubuntu installation MySQL process and remote problem solving