MAC, download mysql8.0.11, visualization tool use is the workbench, always show connection, but the terminal display is available

CodePudding user response:

Is on terminal can link? Tools and services are on a computer?

CodePudding user response:

Feeling didn't open the remote connection permissions, use mysql; The use of mysql; See you log into the user's Host is this column has the authority to % or your computer's IP address, no, you can give a permission, grant statements according to the needs of their assigned permissions,

CodePudding user response:

Mysql8.0.11 this version of the password format is not the sort of, before you to modify the password format
Enter mysql8.0.11 bin shift + right-click the command window to enter
Mysql -u root -p enter into mysql
Perform the ALTER USER "root" @ "localhost" IDENTIFIED BY "your new password";
Complete OK