New one about MySQL for Mac installation directory and startup commands

Terminal Login MySQL

Method 1: Absolute path

Terminal input command:/usr/local/mysql/bin/mysql-u root-p

Tip: Enter your new password

Method 2: (recommended) relative path

Enter the command in the terminal:

To see if there is a path in the path:

Input command in terminal: Echo $PATH

No, go ahead.

Add Required path: path= "$PATH":/usr/local/mysql/bin

later

Input command in terminal: Mysql-u root-p can be

Two. Create User assignment permissions
Grant all privileges on * * to ' user ' @ ' localhost ' with GRANT option
Grant all privileges on * * to ' user ' @ ' localhost ' identified by ' 123456′;
Flush privileges;

Turn from:

Http://blog.sina.com.cn/s/blog_9ea3a4b70101ihl3.html

New one about MySQL for Mac installation directory and startup commands